Switchboard - Error executing command

[goaksmith]

I have a database that is all finished and works fine on my local server (ServerA). The database opens to a switchboard which the users navigate to get to form, reports, etc. My server on my network is the G:// drive. I have another user who's local server is ServerB. She views my database on her J:// drive. Now she can open the database just fine. The problem comes when she tries to open a form or a report through the switchboard. It is giving her the error message "Error executing command" Does anyone know why this is happening? I am assuming that is it b/c somewhere in the database it is referencing the path G:// and not the name ServerA. Any help on this would be appreciated. If there are any additional questions I will try to answer them as well as I can. Thanks!

Gretchen

 

[WayneRyan]

Gretchen,

What you can do is look in the table MSysObjects. In one of
the columns, you will see all of the names of linked tables, etc.

The invalid spec should stand out easily.

Wayne

 

[goaksmith]

Wayne,

I looked at the linked table manager and it links the tables to G://Databases....So, I had them change the links to reference J://Databases....Is there a way to reference the name of the drive as in ServerA://Databases...Instead of the drive letter so that I don't have to change it for each user on a seperate server?

Gretchen

 

[WayneRyan]

Gretchen,

Yes, that is the UNC naming convention. You must use this
syntax when you link the tables. Do not use the mapped
drive letter, cause obviously this can change.

Wayne

 

[goaksmith]

How would I change this? I have already linked the tables using the Link Manager.

 

[Pat Hartman]

Open the linked tables manager.
Select all the tables.
Check the box that says "Always prompt for new location".
When the dialog opens, type the UNC name in the file name box.

Look through your code for any drive letter references and modify them to be UNC names.

 

[goaksmith]

When I try to type in the UNC name I get the following error. Is there something else that I should be doing?


The folder 'G:\\mkefsfp02\Share\TADabases\Backends\OnlineAdjustmentRequest_be.mdb' isn't accessible. The folder maybe be located on an unavailable volume or protected with a password.

It automatically puts the G:\\ in front of it. I typed only the UNC Name in the file name.

 

[Pat Hartman]

Type the name as:

\\mkefsfp02\Share\TADabases\Backends\OnlineAdju