Multi-user database: Locking problem:

[Pramod Vispute]

I am working on maintenance Access project. This database
in one shared folder of network. Those want to use, create
shortcut of that and use it.
Every body has full control of that folder.
A database contains every object like forms, rpts,
queries, macro, tables.
I am using on W2K Operating system and Access XP (Access
2002).
And hope default open mode is shared and record
locking "No Locks", as I am not getting Tools/option menu.

If 4 users working on it and fifth user joining it
following message pops up.

I observed the .ldb file also. It was showing 7 users
logged on with machine name and followed by "Admin" Word.

Here is a description of the error window that pops up
when the database becomes "locked":
================================================
The database '\\SharedMe\MultiMedia\MyMedia DB.mdb' needs
to be repaired or isn't a database file.
You or another user may have unexpectedly quit Microsoft
Access while a Microsoft Access database was open. Do you
want Microsoft Access to attempt to repair the database?
Yes No
================================================
After this message appears, all users must quit out of the
database and then one user must repair it before other
users can log on again.

As message says abnormal exiting of any user, you can't
recognize which use exit obnormally?

Any help would be appreciated

 

[TC]

Pramod, the "accepted wisdom" is that a multi-user database must be split-up
into a "front-end/back-end" structure to avoid corruption. The front-end
(FE) ciontains all of the queries, forms, reports, macros & modules, but
none of the tables. The back-end (BE) contains all of the tables. The FE has
links to the tables in the BE. There is a single copy of the BE, on the
server or where-ever. But each user must have their own copy of the FE. Each
FE links to the tables in the common BE.

HTH,
TC

 

[Pramod]

Thank you. Appreciated. But its already developed
application contains 30 forms strongly connected with
queries and tables. Now is it possible to separate the FE
and BE? If yes what is the shortest and fastest way to do
it? I know by coping/exporting all FE objects in new
database can be distributed for each workstation. What are
the basic changes to do in forms (I guess like record
source as query on BE)? Please suggest links based on it.
Regards,
Pramod

 

[Pramod]

Hi, I have done it using "Database Splitter" utility.

 

[TC]

Ok. Good luck! (I would have replied before, but I only just got back to the
PC.)

TC