Database connection problem

Just one of those things that happens with access. Especially if you have a large (>5 users) accessing the database it is quite likely that it will be corrupted from time to time. Usually because of users abnormally terminating the connection or their transaction. You already have the one and only solution which is to repair the database. It may make sense to add some code to the application which on each user's exit of the application will attempt to obtain exclusive use of the database; if it does it can then automatically run the repair/compact code to assist in the maintenance of the database.

Access is not really the best solution for a multi-user database with a large number of users for this (and other) reasons. I would personally be considering upgrading to SQL server (either the desktop edition if you only have a few users) or the full scale version if it is a large number of users.

Probably using Access 2000.

For error 3343, have a look at these 2 articles:
http://support.microsoft.com/support/kb/articles/Q238/4/01.ASP
http://support.microsoft.com/support/kb/articles/Q272/6/22.ASP

For error 91, the problem will surely be solved if 3343 is fixed.

you can try the MSDE if you don't want to pay for sql server.  it is on the vb cd, and also i think on the office cd.

MSDE won't help for that kind of problems!

why not.  it won't get corrupted like that.  it is more powerful than access and will hold more users.

MSDE is limited to 5 users for full speed. It will trottle all the connection when the 6th user log-in.

The problem that cwchaw has is not corruption, it is caused by drivers.

access is limited also. according to ms you use access for single user to a couple of users, use msde for anything up to needing a full sql server.  I'll see if i can find the article I read.

I suspected it was due to the multi-user and possibly the instability of Access in such an environment but what has got me stumped is that I have another system which is multi-user as well, and the size of the DB is double the problematic one...  BUt that one works fine...

Is your DB in Access 2000?

No, is Access 97 using VB 5 with SP2.

No, is Access 97 using VB 5 with SP2.

I had that problem once when a user opened the DB with Access 2000 and converted it. My app was not running anymore after.

I am using Windows NT to host MS Access 97 database but occasional the problem happen.  So I move to Windows 2000, worst it happen everyday.

But I have found that my another application where the Access 97 is host on Windows 95 is working fine until now even with bigger size, so does it mean Access 97 will only work well on desktop such as Windows 9x/ME?

Question(s) below appears to have been abandoned. Your options are:
 
1. Accept a Comment As Answer (use the button next to the Expert's name).
2. Close the question if the information was not useful to you. You must tell the participants why you wish to do this, and allow for Expert response.
3. Ask Community Support to help split points between participating experts, or just comment here with details and we'll respond with the process.
4. Delete the question. Again, please comment to advise the other participants why you wish to do this.

For special handling needs, please post a zero point question in the link below and include the question QID/link(s) that it regards.
https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
 
Please click the Help Desk link on the left for Member Guidelines, Member Agreement and the Question/Answer process.  Click you Member Profile to view your question history and keep them all current with updates as the collaboration effort continues, in the event new items have been created since this listing was pulled.

https://www.experts-exchange.com/jsp/cmtyHelpDesk.jsp

To view your open questions, please click the following link(s) and keep them all current with updates.
https://www.experts-exchange.com/questions/Q.20142853.html
https://www.experts-exchange.com/questions/Q.20142859.html


PLEASE DO NOT AWARD THE POINTS TO ME.  
 
------------>  EXPERTS:  Please leave any comments regarding this question here on closing recommendations if this item remains inactive another three days.
 
Thank you everyone.
 
Moondancer
Moderator @ Experts Exchange


P.S.  For any year 2000 questions, special attention is needed to ensure the first correct response is awarded, since they are not in the comment date order, but rather in Member ID order.

Thank you for returning and finalizing this question.

Please take an extra moment when you grade questions less than an "A" to comment as to why.  This helps not only the experts who have helped you, but also others in the future who may access this question to get help.  If you've found alternative solutions to achieve your goal and add it here, it further adds value to this item which has not moved to our PAQ (Previously Asked Question database).  Anytime that you need our help, for example, if the grade was chosen in error, let us know by posting a zero point question in the Community Support with the URL to the question involved, we're happy to help.  The points to you are the same, regardless of grade assigned, but the expert points which flow are directly impacted by grades assigned.  There is more about this in the HELP DESK link regarding Questions and Answers.

Thanks,
Moondancer - EE Moderator