Database Splitting

[supportt]

I have a general question about database splitting, I have searched the threads and really can not find an answer. I just finished up my access db and need to pass it to other users, only three or four users total. I am reading that splitting is the way to go with a FE and BE. Well, I used the wizard for splitting and it did create the BE file (that goes on the share or server) how do I create the FE for the user PC's? Will multiple users be able to use the database at once?

Thanks

David

 

[DBL]

When you use the wizard to split your database it creates a new database for the backend, with a new name and leaves the front end in the existing database. If you open the existing database and look at the tables you will see that all the tables are there but with black arrows to the left of the table name which shows that the tables are linked.

Now that you have split it you can do one of two things - copy the frontend on to each user's pc (my preferred option). The only draw back to this is that if you are still developing the frontend you will need to copy the database to each PC every time you create an update. The alternative is to put the frontend on the server too and create a shortcut to the frontend from each PC. If you are still updating the frontend, use a different frontend than the one the users are accessing or you may get conflict problems where it might not let you save changes.

The only other thing to do is make sure that you have set the record locking levels: Tools>Options>Advanced and select Shared under Default Open Mode and Edited Record under Default Record Locking.

Having done the above you should be good to go with four or five users accessing the database at the same time.

HTH

 

[supportt]

DBL- Thanks for the advise....I will give it a shot.

David