cwchaw
asked on
Database connection problem
My Visual Basic application is using MS Access database and it is multi-user. Lately I encounter the following error message when stating the application:
1. Error #3343 was generated by DAO workspace unrecognized database format 'h:\brains.mdb'
2. Error #91 was generated by Project1 object variable or with block variable not set.
After repair the database the problem will solve. Why the database corrupted and what is the possible cause?
1. Error #3343 was generated by DAO workspace unrecognized database format 'h:\brains.mdb'
2. Error #91 was generated by Project1 object variable or with block variable not set.
After repair the database the problem will solve. Why the database corrupted and what is the possible cause?
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.
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.
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.
ASKER
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?
ASKER
No, is Access 97 using VB 5 with SP2.
ASKER
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.
ASKER
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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
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
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.