|
Home > Archive > MS Access Multiuser > February 2006 > Database Crashing
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| I'm encountering a crashing problem (database inconsistency) with a shared
Access 2002 database. I've split a DB into a front-end (sales.mdb) and
back-end (sales_be.mdb) and there are approximately 5 users logged into the
DB at any given time.
The problem is that I have one user who has to continually update the BE to
push sales orders (every 15-20 minutes) and it at least 2-3 times a day, the
BE crashes and I have to rebuild it (after kicking everyone out).
Is there a way to allow this user (who's pushing sales orders) to LOCK all
tables for the 2-3 minutes that it takes to push orders? Or, if this isn't
the best solution, can anyone help with this?
Thanks in advance for your help.
Regards,
G
| |
| Tony Toews 2006-02-02, 3:25 am |
| "G" <G@discussions.microsoft.com> wrote:
>I'm encountering a crashing problem (database inconsistency) with a shared
>Access 2002 database. I've split a DB into a front-end (sales.mdb) and
>back-end (sales_be.mdb) and there are approximately 5 users logged into the
>DB at any given time.
>
>The problem is that I have one user who has to continually update the BE to
>push sales orders (every 15-20 minutes) and it at least 2-3 times a day, the
>BE crashes and I have to rebuild it (after kicking everyone out).
>
>Is there a way to allow this user (who's pushing sales orders) to LOCK all
>tables for the 2-3 minutes that it takes to push orders? Or, if this isn't
>the best solution, can anyone help with this?
No, you should really deal with the fundamental corruption problem.
Corruptions about once a year at most are typical. Ideally of course
non are wanted.
Trouble is it can be a daunting task to figure out why there are
corruptions.
For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
|
|
|
|
|