MS Access & VB Coding

west9510

Beta member
Messages
3
Location
USA
Hey guys,

The company I'm working for has a microsoft office access database they use to record/edit information in their inventory. One of my tasks is to edit and modify the database, however whenever I make any changes to the back end (when I make a local copy of the database) it affects the database on the server as well. Is there any way in which I can link the database as a relative path as opposed to absolute path? I want to be able to edit and work with a copied version of the database without affecting the original copy on the server. The front end is just a forum with VB coding to support it but how do I link that to a locally copied back end?

- West
 

OS-Wiz

In Runtime
Messages
334
Location
USA
Just copy the .accdb/.mdb to another folder for which you have permissions. Then use a copy of the VB to edit/modify it or do it directly in Access.
 
Top