Access multiple users

R

Raul

Hello, I maintain a database at work, we work off of a share drive. We are
having corruption problems with our database. There are 3 people that share
the database, I do not have the database split - just have it on the share
drive. Could this be the problem.

Also, we had 97 version and converted to 2002-2003 format (the database)
when we installed Office 2003. We are also in addition to the corruption
message when we recover our database from a copy, we get a message stating
that the database has been converted from a prior version fo Access and has
left the database in a partial converted state, and we are unable to access
our database.

Raul
 
T

Tom Wickerath

Raul,

Nearly two years ago, I attended a seminar at Microsoft that dealt with Access and SQL Server. A
Microsoft Access Program Manager told the group that sharing an entire database had been
identified as the #1 cause of database corruption. You can search this newsgroup for similar
questions, and you will always see that the advice is to split the database. Each user should
have their own copy of the front-end on their hard drive; only the shared data is placed in the
back-end database on a file server.

Is your copy of the database, that you are using for recovery, an Access 97 database? This would
explain the conversion messages. My suggestion is to create a brand new database, using the
Access 2000 file format. Then import all objects one group at a time (ie. all tables, followed by
all queries, followed by all forms, etc.) until you have imported all groups of objects. When you
import the tables, make sure to include Relationships, Menus and Toolbars and Import/Export
Specs. Set the startup properties and references the same as the source database. Then do a
Debug > Compile to compile the VBA code.

This might be a good time to add a table with one field and one record, which you can use to
maintain a single connection. Use code in a startup form, or call a function in an autoexec
macro, to open a form in hidden mode that is bound to this table. Something like this:

DoCmd.OpenForm FormName:="frmNameOfHiddenForm", windowmode:=acHidden

Then split your database. Also recommend converting the front-end to a .mde file. If you take
this last recommendation, you'll need to convert the front-end to the Access 2002 / 2003 file
format first.

Tom
_______________________________


Hello, I maintain a database at work, we work off of a share drive. We are
having corruption problems with our database. There are 3 people that share
the database, I do not have the database split - just have it on the share
drive. Could this be the problem.

Also, we had 97 version and converted to 2002-2003 format (the database)
when we installed Office 2003. We are also in addition to the corruption
message when we recover our database from a copy, we get a message stating
that the database has been converted from a prior version fo Access and has
left the database in a partial converted state, and we are unable to access
our database.

Raul
 
Top