database corruption

[Sam63]

I have a vb6.0 interface connecting to a ms access database. The database frequently gets corrupted and I cannot figure out why? Two questions?

Can I repair the database from code in vb6.0?
Can I run a vb6.0 interface and connect to a .mde file rather than a .mdb file? Supposedly the .mde version of a ms access database is more stable.

thanks
Sam

 

[Lightseeker]

Yes you can repair the database. But it must be closed first, so either close it from within your code or write a second app that will do the repair while nobody accesses it.

http://www.vbsquare.com/databases/dbclass/

 

[Lightseeker]

Does the database get shutdown frequently without going through the proper closing, i.e. system crashes, code crashes, etc.? This could lead to a corrupted database. I didn't have time to answer the second question something came across my desk.

Don't know about mde files.

 

[zemp]

You can compact an access database using the JRO objects. I also believe that microsoft has made the compact and repair into one process. Check the links below for more details.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q230501

http://msdn.microsoft.com/library/d...owCompactDatabaseDefragmentFreeDiskSpaceS.asp

Quote from microsoft msdn.
"Compacting and repairing have been improved, and they are now integrated into a single process that is safer and more effective. " Thanks and Good Luck!

zemp

 

[Sam63]

The database is opened and closed frequently by users (approx 50 people). Problem is some sit in it overnight while our LAN does backups and this sometimes corrupts the database. I've figured out how to log people out automatically at 6pm, but haven't worked out the repair so that the first person who logs in does the repair rather than wait for me to come in 4 hours later.

Sam

 

[johnwm]

Access was really only designed as a desktop database app. rather than a real database server. It stands up reasonably with 2-3 users, can cope with 5-8 with performance hits, but rapidly gets unstable beyond that. With 50 users you might want to look at a SQL database. Have a look through the database forums to see what is around to suit your needs. Let me know if this helps
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'There are 10 kinds of people in the world: those who understand binary, and those who don't.'