By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,222 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,222 IT Pros & Developers. It's quick & easy.

Linking Tables Problem

P: n/a

All:

I've set up a database using two separate files so that I can keep the data
stable while playing around with the structure. The tables in the data
file are linked into the structure file (eg. structure.mdb, data.mdb). I
am building this database for someone else, however, and when they install
the two files on their computer and try to open a table in the structure
file, Access complains that the links don't have the proper path (eg. the
path on the computer of origination).

Logically, this makes sense, but I would like to work around this.

Any suggestions?

Thanks in advance.

Steve
Nov 13 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
If the other person creates a folder with the same path as you did for the
data.mdb, there won't be any problem.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"mooseshoes" <mo********@gmx.net> wrote in message
news:ux*****************@newssvr21.news.prodigy.co m...

All:

I've set up a database using two separate files so that I can keep the data stable while playing around with the structure. The tables in the data
file are linked into the structure file (eg. structure.mdb, data.mdb). I
am building this database for someone else, however, and when they install
the two files on their computer and try to open a table in the structure
file, Access complains that the links don't have the proper path (eg. the
path on the computer of origination).

Logically, this makes sense, but I would like to work around this.

Any suggestions?

Thanks in advance.

Steve

Nov 13 '05 #2

P: n/a
<snip>
If the other person creates a folder with the same path as you did for the
data.mdb, there won't be any problem.


The other person is dropping the files onto a network drive, which is

something I don't have so the paths can't be the same.
Steve
Nov 13 '05 #3

P: n/a
In message <DH******************@newssvr29.news.prodigy.com >, mooseshoes
<mo********@gmx.net> writes
<snip>
If the other person creates a folder with the same path as you did for the
data.mdb, there won't be any problem.


The other person is dropping the files onto a network drive, which is

something I don't have so the paths can't be the same.


If your machine has networking software on it you may be able to create
a share then connect to it as if it were a network drive. That way you
could re-create the same path that your friend has.

The alternative is to try to edit the path recorded in the database. I
expect that this is in one of the system tables and so might be edited
with SQL.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

Nov 13 '05 #4

P: n/a
1. Execute the following DOS command:
Subst <Full Path To Folder On His Network Drive> <C:\Folder On Your
Computer>
2. Place Data.mdb in C:\Folder On Your Computer
3. Open Structure.mdb and relink to tables in Data.mdb

Database will now work on the other person's system.

Note: Double check the Subst command to be sure I have the paths in the
right order.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"mooseshoes" <mo********@gmx.net> wrote in message
news:DH******************@newssvr29.news.prodigy.c om...
<snip>
If the other person creates a folder with the same path as you did for the
data.mdb, there won't be any problem.


The other person is dropping the files onto a network drive, which is

something I don't have so the paths can't be the same.
Steve

Nov 13 '05 #5

P: n/a


Mighty cool. Thanks!
Nov 13 '05 #6

P: n/a
As a point of closure, I downloaded a freeware tool called "Virtual Drive
Creator" which, for what I can see, is a pretty front end to the SUBST
command. In any event, it was very easy to emulate the other working
environment this way and consequently everything is now working (always a
happy way to end a story).

Thanks for all your help!

Steve
Nov 13 '05 #7

P: n/a
Always glad to help a fellow "Steve"!

What's the URL to download "Virtual Drive Creator" ?

Steve
PC Datasheet
"mooseshoes" <mo********@gmx.net> wrote in message
news:0F*******************@newssvr29.news.prodigy. com...
As a point of closure, I downloaded a freeware tool called "Virtual Drive
Creator" which, for what I can see, is a pretty front end to the SUBST
command. In any event, it was very easy to emulate the other working
environment this way and consequently everything is now working (always a
happy way to end a story).

Thanks for all your help!

Steve

Nov 13 '05 #8

P: n/a

<snip>
What's the URL to download "Virtual Drive Creator" ?

Choose your favorite freeware download site or try:


http://www.smartdownloads.net/download-8487.html
Nov 13 '05 #9

P: n/a
Thanks, Steve! Have a good one.
"mooseshoes" <mo********@gmx.net> wrote in message
news:jH******************@newssvr29.news.prodigy.c om...

<snip>
What's the URL to download "Virtual Drive Creator" ?

Choose your favorite freeware download site or try:


http://www.smartdownloads.net/download-8487.html

Nov 13 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.