MS Access 2007

[Jack]

We have tried repeatedly to share an Access database (i.e. provide for
multi-user access to an Access 2007 database) with no success. We have tried
splitting the database and any other user but the creator of the database
can't open it. Can anyone help us? There must be a way to create an Access
db and have two people access it! Thank you.

 

[KARL DEWEY]

Click on the Office Button, select Access Options, Advanced, scroll down to
Advance, and select Default Open Mode - Shared.

You may have another problem - the early bird gets all. The only cure I
found in searching was to split into FE & BE.

 

[Larry Daugherty]

Access is multi-user capable right out of the box if everyone uses the
same front end: Just place the application in a network share and the
users can run it from there. Every user needs a copy of Access on
their system. For very lightly loaded applications you can get away
with that. You have, wisely, decided to move up the ladder of
robustness by splitting the application. To complete that process
properly you need to place a compiled copy of the FrontEnd (in the
form of MDE or ACCDE so that there are no design changes accidentally
made) on every user's system. Place the BackEnd on a network share.
Before making the MDE/ACCDE copies, link the FrontEnd to the BackEnd
tables using the Linked Table Manager of "get external data - link"
method. Navigate to the BackEnd and select all of the tables. Now
make the MDE/ACCDE version and give/email a copy to each user with
installation instructions.

HTH

 

[FMS Development Team]

We have tried repeatedly to share an Access database (i.e. provide for
multi-user access to an Access 2007 database) with no success.  We havetried
splitting the database and any other user but the creator of the database
can't open it.  Can anyone help us?  There must be a way to create anAccess
db and have two people access it!  Thank you.

If you have a front-end back-end database design, then you simply want
to distribute the front-end to every user so they install it on their
local machine.

That can be done manually, through email, etc.

If you are interested in a professional solution that lets you
centrally manage the process, automatically installs your front-end
database on each user's desktop, and makes sure each user launches the
right version of Access, check out our Total Access Startup program:
http://www.fmsinc.com/MicrosoftAccess/VersionLauncher.asp

A demo version is avaialble.

Good luck!

Luke Chung
FMS, Inc.
http://www.fmsinc.com

P.S. Visit our Micosoft Access Help Center for more resources:
http://www.fmsinc.com/MicrosoftAccess/help.html