Paths

[smich]

Hi, I have a project linked to an external mdb data. My problem
is that every time that I modify my proyect in my computer and I put it in the network I have to relinked to the data file in the network. Is there any code that will keep the path where the linked files resides, but will not take in account the drive letter or the computer name?

Thanks for your input

Salvador

 

[Autoeng]

Are you saying that you are modifying the front end of a db on your local machine and the link gets broken after upload of the front end to the server for distribution to the users?

 

[smich]

Thanks for your attention.

When I started the proyect I had my 2 mdb's (proyect & data) in my computer, after I put it in the network the linked was still related with the files I have in my computer. What I did, is erased
the links to my computer and then relinked to the files stored in
the network.
And I have to do the same task, evety time I make a modification
to the forms, code, etc. in my computer and then replace the one
I have in the network.
Sometimes I forget to relinked it and I start hearing yields from the end users.
I want that access pick the data in the directory in which is stored,
which by the way it has the same name in my computer and in the network.

Thanks

Salvador

 

[Autoeng]

Here's what I do. I only modify the FE on my computer that way the link is always to the data on the server. Never needs updated. If I modify the BE do it on the server after saving a copy.

You shouldn't have the BE on your computer except for backup.

 

[ghudson]

I am going to guess that you are linked to a backend on the server and your backend in located @ X:\Databases\Files\Test.mdb. Your users have a different drive mapped to the same server.

If so, you need to use the server and partition names instead of drive letters to link the front end to the back end.

My examples has the back end on the server named "Biggie" and the partition named "Slice" and the main directory is named "Testing" and the backend file is named "MyData.mdb"

Open the Linked Table Manger and select all your tables that you want to relink.

Copy/paste (or type) the \\server\partition\directory\ name where the backend file is located in the File Name field...

\\Biggie\Slice\Testing\

Click the Open button and you should see your backend file. Link it and you will not have to worry about the drive letters the users are mapped to the server with.

HTH

 

[Autoeng]

Thanks ghudson. Figured I was missing something.