Connection to database on network
I have an access database frontend installed on multiple workstations on the network. The backend (containing the tables) is stored on a network drive. Beint new to access, and VBA, I am not sure how to connect to the backend. As this is a multiple user environment, I would also like to lock and unlock the back end after upon open and before closing respectively. I really appreciate any assistance in this matter.