Split Database

[Guest]

OK. Here is a question that I am sure will turn out to be simple. I have
created a database with five (5) users. I recently split the database using
the wizard in the Access utility menu. Problem is I don't know what to do
now. I have two files in the database folder with ext of .be and .mbd. How do
I use these files to enable simultaneous multiple users? Right now (after
the split) one user has to log off the database in order for another to log
on and save data.

A step by step explanation will be greatly appreciated.

Thank you.

 

[Guest]

copy the front end .mdb to each desktop's computer. Leave the be on the
server.

 

[Guest]

Thank you. I will give it a try. Seems simple enouth.

 

[John W. Vinson]

OK. Here is a question that I am sure will turn out to be simple. I have
created a database with five (5) users. I recently split the database using
the wizard in the Access utility menu. Problem is I don't know what to do
now. I have two files in the database folder with ext of .be and .mbd. How do
I use these files to enable simultaneous multiple users? Right now (after
the split) one user has to log off the database in order for another to log
on and save data.

A step by step explanation will be greatly appreciated.

Thank you.

Actually the extension for both is .mdb. The splitter wizard renames the
backend from yourdatabasename.mdb to yourdatabasename_be.mdb.

See http://www.granite.ab.ca/access/splitapp/ for a thorough discussion.

John W. Vinson [MVP]