Multi-User Database

Z

Zanstemic

The database I created is not accessable from multiple workstation and comes
up as locked if another user already has it loaded.

What is the best way to make a database accessable from multiple workstations?
 
J

John

The database I created is not accessable from multiple workstation and comes
up as locked if another user already has it loaded.

What is the best way to make a database accessable from multiple workstations?
Click to expand...
 
R

RD

The database I created is not accessable from multiple workstation and comes
up as locked if another user already has it loaded.

What is the best way to make a database accessable from multiple workstations?
Click to expand...

See this:
http://www.augsd.org/sampleapps/Splitting a Database.ppt

After splitting the database open the front end, from the menu click Tools >
Options. On the Advanced tab, for Default open mode check Shared. For Default
record locking choose choose Edited record. Choosing No locks leaves the
possibility that two people will try to edit the same record.

HTH,
RD
 
Z

Zanstemic

After splitting the database and following the steps, I installed the FE on
each computer.

I'm getting two error messages based on which computer I load first:

1) Database in use. (does not launch)

2) When I do get two machines running off the same BE, When I go to enter a
new record, I get the error "Can't go to record, end of table
 
R

RD

1. Did you make sure the opening and file lock options are set correctly on
*all* of the users computers.

2. Is there code behind this form? Can you see where the error occurs?
 
Top