Split Database

[scouser]

I have a database that resides on a file server share. I have split the database to create a backend. I then posted a shortcut of the front end to the desktops of two users who have access to the share. I then tried to access the front end from the two machines simultaneously. It opened on the first PC but not the second? When I viewed the server share it had a 'padlock' icon?

Where am I going wrong? This is the first time I have attempted this scenario!!
Thanks in advance,
Phil

 

[KenHigg]

Sounds like you may not be putting a copy of the front end on each workstation...

 

[boblarson]

What is happening is that one machine is opening the database in exclusive mode. The best thing when doing a Front-end/Back-end scenario is to let each user have a copy of the front end on their machine. Then, no one will get locked out. Also, you will have fewer problems like you may have when you have multiple people opening the same file.

For easy changes to the front-end and then letting the front-end auto-update itself check out this post:
http://www.access-programmers.co.uk/forums/showthread.php?t=111132

 

[scouser]

Thanks

Thanks for the replies guys. I will put your comments into action.
Phil.

 

[scouser]

Download

I have downloaded the auto update front end db. I will have a look and hopefully put it to good use!!
Many Thanks,
Phil.