3 replies to this topic

[williamevanl]

I wrote an forms application for work that just records information about jobs and writes it to an acess database, after X number of info is added about a job it tallies each thing about the job along with a list of the job names and generates an automatic email which it then sends to three people.

When I run this it works perfectly but after distrubuting this to the office reports started getting sent that contained only partially formed emails, it started with missing job numbers and then some of the job information was also ommitted.

The program isnt throwing any sort of error message and my inability to reproduce the error suggest that it has something to do with multiple people accessing the .mdb *access* data table at the same time. I asked a co-worked to help me bug test it by running it at the exact same time but we couldn't get it to error this way either.

Does anyone know what might be going on here or how I can fix it? My boss is like WTH!! is going on and honestly don't know. :|

[WingedPanther]

Access is NOT an enterprise level database. MySQL, Firebird, PostGRESQL, SQL Server, Oracle, and many others would be good replacements (some free, others not). How many users are normally accessing this system at once?

[williamevanl]

WingedPanther said:

Access is NOT an enterprise level database. MySQL, Firebird, PostGRESQL, SQL Server, Oracle, and many others would be good replacements (some free, others not). How many users are normally accessing this system at once?

Maybe 7 at a time, It shouldn't be any problem for access. Now the error occurs everytime I debug the program but not when I run it normally. Why would debug cause it to run differently?

[plypencil]

Because in DEBUG mode warnings are normally treated as errors, in normal mode warnings are ignored.

Thats just a possibility, I think that your problem is that access is not designed for multiple users to access and update a single file at the same time.