Split Database With Multiple Users

[codybecker]

Hi All

Have a question with regards to having a split database.

I have two separate database files, a front end with all my forms and a back end with all my tables. The backend is stored on a network drive, is there any way of being able to store the frontend on the drive with the backend? Users do not use the actual computer to store information or access files, everything is usually saved on the network drive. I have created a shortcut that launches the front end database in the read only kiosk mode.

Any and all help will be greatly appreciated.

 

[khodr]

you would need to Map a network drive to the database folder on the network from every workstation you would need to run the database on it, and then open that mapped network drive from the workstation after clicking on my computer icon, and drag the database file while holding the shift key and drop it on your desktop double click it and it should work fine.
hope that what you need.
how to map a network drive?
double click on my computer
then go to Tools,
then Map Network drive
then Browse and locate your database folder
then click ok and don't forget to click on reconnect at logon

 

[codybecker]

Im having trouble understanding. Right now i have both the frontend and the backend stored on a mapped network drive. It shows up as being stored in O:/DatabaseHolder. Inside the folder is: frontend.accdb, backend.accdb, and a shortcut that opens the frontend in /runtime format. Can i just create a shortcut with the full address to the frontend (eg. \\servername\DatabaseHolder\frontend.accdb) that can be copied to everyones desktop?

 

[khodr]

ok open your O:/DatabaseHolder right click on the database and choose create a shortcut, then right click again on the shortcut icon and choose cut go back to your desktop right click on the desktop and choose paste, it should work.

 

[cpberg1]

For access to operate properly without risk of corruption you'll need to have each user opening a separate frontend file. That frontend file would normally be kept on users C drive and point at backend tables on O. I've had some success with having each user assigned a frontend file unique to them residing on the network. Mydatabase - smith.mde for example. Create a shortcut to the individuals unique frontend.

Usually you'll have someone try to open one not assigned to them and cause problems. If you have a small enough group perhaps it won't be an issue.

Have fun!

 

[khodr]

Well for me it happened once and i was lucky to have a backup and since then I am using the front end on each computer linked to the backend on the server but I have 35 users on my database and sometimes they use the same forms for the data entry