Database corrupts several times a day.

[Yvonne]

I have a database application that is all in one mdb file
and is shared by several users on a network. It is
constantly corrupting several times a day. There is one
main form that has many subforms. If I split the data out
to a separate file and link the tables it runs extremely
slow. Can anyone help me with a suggestion? Thanks

 

[Immanuel Sibero]

Hi Yvonne,

It's highly recommended to split the database. The corruption you're
experiencing is probably due to the fact that you have multiple users using
unsplit database.

Check out Tony Toew's site below to deal with performance:

http://www.granite.ab.ca/access/


HTH,
Immanuel

 

[Yvonne]

Thanks for your reply. The problem is that if I split the
database into 2 mdb files it runs ridiculously slow. This
is not a viable solution. Isn't Access supposed to be
able to handle multiple users

 

[Douglas J. Steele]

Yes, Access can handle multiple users, but the recommended way to do this is
to split the database. Every user has a copy of the front-end on their hard
drive, and only the back-end is on the server. If you don't do this, the
risk of corruption is high. Your experience is bearing this out.

Did you check the link Immanuel suggested? Tony talks about performance of
split databases in http://www.granite.ab.ca/access/splitapp.htm