Getting Not a Valid Path Error

[bconner]

I have a database that I split and placed on a shared network and when I copy and past the front end on other users computers when they try to open a form they get and error stating that database path isn't valid. Each person may have their network mapped with a different letter for example mine is A:\FOLDER\DATABASENAME and someone elses might be Y:\FOLDER\DATABASENAME. How can I install the Front End Database so that it will open on each persons PC?

 

[Rabbie]

Look at using UNC type names for the back-end files like


\\servername\FOLDER\DATABASENAME

 

[bconner]

Rabbie, I am fairly new at this what does it mean to use a UNC type name on the Back End Files?

 

[Rabbie]

UNC is the format I gave in my example. You don't give a drive number which can be different on each PC but instead give the server name of the computer where the BE is stored.

 

[bconner]

Rabbie,
Where do I make this change?

 

[bconner]

The database opens it's just when a user clicks on a button that is attached to a macro to open a form the following message pops up:'A:\BAM\CustomerServiceTelephoneTracking.mdb' is not a valid path.

 

[gemma-the-husky]

it would make sense to have a consistent naming convention in your company for drive letters - using drive a: for a network drive is definitely strange

 

[DCrake]

To simplify matters get your IT dept to create a shared drive on the server lets say M:
Let them know who will be using the application and ask IT to give them access to it, don't forget yourself. Next place the back end in a subfolder M:\Data

Use Link Table Manager to refresh your links to the back end. Create a new new folder (M:\Application) copy the front end into this folder. Next ask users to navigate to this folder and copy the front end onto there own machines in a common location, such as C:\Program Files\Databases\AppName

Where AppName is the name of the front end. Now when the users open the front end they should all have access to the data.

The advantage of this is that once in place you should not have any connection issues and when front end updates are available they can copy the latest version from the Application folder down to their own pc.

David