Database problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I cannot load my Ms Access 2000 database. It says 2 users are trying to
change or access database at the same time. How do I fix this?
 
Need more info Juan. Where is this database located in relation to you and
the other user/users?

If you have this database on your own machine and are sharing it with other
users or it is on someone else's computer and you use it, the database is
corrupted and it needs repairing. Everyone and I mean everyone must have
this database closed on their own machines. You also need to find out if an
ldb file exist after everyone closes the database from their own machine.
The ldb file will have the same name as the database such as mydatabase.ldb.
As long as the user has closed the database, this file can be deleted. Be
sure it ends in ldb and NOT mdb. Once it is deleted, then open Access
without selecting any database. Then Under Tools | Database Utilities select
Compact/Repair (some versions of Access combine this, Access 97 is
separated). Locate and pick your database. This will compact and repair your
database. If everything goes well, then you can rename the 'bad' database to
reflect the databasenameOLD.mdb and then rename your repaired database back
to the original name. DO NOT ERASE THE .MDB part. Double click to open. If
all goes well, then this is what you do next to share a database with
others.

Split the database into a 'front-end and back-end database. The front-end
contains linked tables from the back-end, queries, forms, etc. and goes on
each user's machine. The back-end contains only the original tables to the
database. Put the back-end database on a server running Windows 2000/2003
Server. There is a wizard within Access to Split your database. However,
before you do this, MAKE A COPY of your newly repaired database and place it
somewhere safe, in the event the split goes badly.

If your database is already on a server, it probably just needs repaired.
Someone probably shut their computer off with the database open, which
corrupted the database or you tried to edit the same record and placed the
database into a 'Deadlock'. However, if it is not a split database as
described above, it needs to be split.

Split databases are used for Network sharing.
 
Back
Top