Change path to back end

[tarheelkate]

I need to change the path from my front end to my back end. I thought this
was done using the Linked Table Manager, but I don't have any linked tables,
so Access 2007 will not let me open the LTM.

Just to see what I could find, I went ahead and made an arbitrary linked
table and opened up the manager. There was nothing there that would allow me
to change fe-be path.

Don't know if any of this matters, but I originally split my database using
the database splitter. I just upgraded to Office 2007 (I'm not a huge fan).

Any suggestions on how to change the path?

 

[Jackie L]

At first I was going to tell you that you needed to split your data from your
program, but then you said you had used the database splitter, but then
again, you said you have no linked tables...

Why would you need to change the path if there are no linked tables? If you
do indeed have linked tables, you can just delete the link and relink to the
new data location, otherwise, you need to truly split your data and then you
can use the linked table manager to change the location.

(ditto on the 2007 comment)

 

[tarheelkate]

I split the database so that all my tables were in the back end and all my
queries, forms, and reports were in the front end. I did this becasue I have
several front end users who don't know anything about Access and i didn't
want them to damage any of the tables.

Everythign works beautifully on my machine. The problem is that both
databases are saved on my company's share drive. For some reason the drives
are listed differently on each of our computers. For example, the drive is
listed as X on my computer, but as L on someone else's. My IT director told
me that when I split the database, it used the path on my computer, but I
need to amend it and include the full directory path so that it will work on
everyone else's. He gave me the correct path to use, but I have no idea how
to change it.

Thanks in advance!

 

[Jackie L]

You need to make sure that all the workstations are mapped the same to the
data (which is what I hope your IT guy is directing you to). If you are
having trouble with the linked table manager, then delete the link to the
tables (make sure that the tables are linked before deleting, you will get a
warning about the link being deleted, not the actual table) and relink the
tables (in A2007) by going to External Data - Access - click on the box to
link and browse to the data.

If you are not running separate copies of the fron end, you should be. Each
workstation should have their own copy of the front end stored locally.

Hope this helps.
Jackie

 

[Ken Sheridan]

You might like to take a look at the following link from which you can down
load a demo of how to automatically check for invalid links at start-up, and
if any are invalid, open a form to refresh them by browsing to the back end.
The demo includes versions for single and multiple file back ends. It was
posted some years ago but I think it should still work with later versions of
Access:


http://community.netscape.com/n/pfx/forum.aspx?msg=19444.1&nav=messages&webtag=ws-msdevapps


Ken Sheridan
Stafford, England

 

[Douglas J. Steele]

When you're in the Linked Table Manager, navigate to the back-end through
the Network Neighborhood (or whatever it's called), rather than navigating
to it using your mapped drive. That will result in the linked tables using a
UNC (\\server\share\folder\file.mdb), rather than a drive letter
(X:\folder\file.mdb)

 

[tarheelkate]

Everything you are saying makes complete sense to me. (In fact, I believe
I've done it before in an earlier version of access). I can't seem to figure
it out in Access 2007. My database will NOT allow me to open the Linked
Table Manager. Is it becasue I have no tables in the front end becasue they
are all stored in the back end? This is driving me crazy!

 

[Douglas J. Steele]

Sorry, I don't have Access 2007 installed on this machine, so I can't check
what's going on.

Hopefully someone else can offer some advice.