Linking Tables Problem

[mooseshoes]

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

[PC Datasheet]

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

[mooseshoes]

<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

[Bernard Peek]

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.

[PC Datasheet]

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

[mooseshoes]

Mighty cool. Thanks!

[mooseshoes]

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

[PC Datasheet]

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

[mooseshoes]

<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

[PC Datasheet]

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