ERROR - Repair Database

[stlrain95]

I have a Database that I have distributed through a warehouse. They use this DB strictly in Access Runtime. But for some reason, every so often, I get an error that I need to repair the DB. Access 2000 repairs the error, but I have to boot everyone off.

Is there a more simple solution? What am I doing wrong?

Appreciate the help in advance.

 

[johnwm]

How many users on the database? I've found Jet unreliable for multi-users above about 5 with heavy use, although you'll get away with more with light use.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[stlrain95]

I have about 10-15 users.
Is there something that I need to change?

 

[johnwm]

Don't forget that Access/Jet was designed as a desktop database - not an enterprise type server - even though it supports more than one user.

You need to choose the most appropriate vehicle for the use intended. Do some research on alternative db engines if Access isn't serving your needs, each one has it's pros and cons.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[stlrain95]

Thanks for the input