Multiuser enviroment

[gile2004]

Hello to everyone!

This is my first post but I am reading this for a while now and I learned a lot from this site. Now, I have a problem which I cannot solve and I hope that you can help me with some advise.

I designed database for production proces calculation and for warehouse management. I have BE and Fe which are on server and every user has the copy of FE for himself. FE is also on server. Maximum number of concurent users is 3. The problem is that sometimes I get wrong calculations.

For example, when someone click the button for finishing the production process, calculation of production cost goes wrong. But, that is not happening everytime. Let's say one of the 10 calculations goes wrong. I tested aplication localy on my computer and everything is working normaly. I also tested the database in network enviroment (in my house, BE on one and FE on second computer) and everything is also working good.

I have to mention that this factory is rather old and we are constantly experiencing power loss or voltage disruptions. And also I have to mention that network cables are not installed profesionaly. We bought several aditional UPS devices to secure the network from voltage disruptions and now I will test the database again. But, any additional help would be appriciated.

The strange thing is that I never get any kind of error message. Everything seems to work good, but when I look at the numbers I can see that some of the calculations are wrong.

And just one more thing. In my database I have some procedures which are based on several queries which are executed one after another.

Something like this:

docmd.openquery "Query1"
docmd.openquery "Query2"
docmd.openquery "Query3"

etc.

In some places I have up to 7 queries which are executed one after another one (first query deletes the data from table, second one makes the initial calculation, thirdone updates the warehouse data, fourth is calculating the new price, etc.)
Maybe this is the problem?

Thank you in advance,
gile2004

Sorry for my bad english...

 

[Len Boorman]

Sounds as if your problem is associated with the queries and multiple users. Consider

User 1 is doing something

User 2 is also doing something

User 1 then calls the queries that do update calculations

User 2 is still changing some data elements

Queries run on data that exists at that instant

User 2 changes something after 1 of more of the queries has executed

Result

Figures are not correct

Solution

You need to fire the queries to update record that has been changed or added only.

Len

 

[gile2004]

Thank you for your reply. But, I have three companies which are using databases of theirone. And in one company I have only one user working on database.

So, I think that is not the problem.

Please advise...

Gile2004

 

[Len Boorman]

Okay so in the single user situation you still get errors in calculation.

You say you have FE/BE. So the other cpmpanies including the one with a single user have their own separate FE and BE's.

If you are getting errors in single user situation then User is doing something you are not when you are testing. Can user exit form/programme without firing queries.

Len

 

[gile2004]

I really appreciate your help. Yes, they can exit the form without runnig the queries. But, I designed it on that way that if they want to close the form nothing happens. Only if they want to go on next step then queries will run.

I just examined all the calculations for one of the companies and I noticed that they were doing calculations for about 500 articles and only 11 of them went wrong. All other articles were calculated on right way. This is making me crazy.

Do you think if I put Pause function between queries (for about second or two) is this going to fix the problem?

Is it possible that when queries are executing and in some moment LAN receives the power loss for a second Access just skippes one of the queries and goes to the next one without starting previous query?

I hope that I was clear because of my bad english...

gile2004

 

[gile2004]

Here it is again

Hello again to everyone!

I have to tell you that I still have the same problem. So, I was thinking about this very intensively and here are my question:

All three databases are running on one server. I wasn't able to put FE's on local computers because LAN connection is not good. So, all of the FE's are also on server. And all three databases are operational all day. And, in fact, they are same. The difference is only the name of databases.

It is Windows 2000 server where I also have Exchange Server installed, Veritas Backup....., in short words that is server for everything.
And it is not brand new server. It's 2 years old.

Is it possible that mistakes are happening because of all this I mentioned above?

Please, advise, now I have serious problems and I don't know what to do.

And, the worst thing is that when I test the database in my test enviroment (also on LAN but in my home office) I cannot force the program on any way to do these kind of mistakes. And, because of this, I cannot find the solution...

Thank you in advance,
Gile2004