Linking Tables Problem

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

re: Linking Tables Problem

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
resource@pcdatasheet.com
www.pcdatasheet.com


"mooseshoes" <mooseshoes@gmx.net> wrote in message
news:uxoWc.7147$QJ3.6789@newssvr21.news.prodigy.co m...[color=blue]
>
> All:
>
> I've set up a database using two separate files so that I can keep the[/color]
data[color=blue]
> 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[/color]

re: Linking Tables Problem

<snip>
[color=blue]
> If the other person creates a folder with the same path as you did for the
> data.mdb, there won't be any problem.[/color]

[color=blue][color=green][color=darkred]
>>> The other person is dropping the files onto a network drive, which is[/color][/color][/color]
something I don't have so the paths can't be the same.


Steve

re: Linking Tables Problem

In message <DHoWc.11262$EQ7.7871@newssvr29.news.prodigy.com >, mooseshoes
<mooseshoes@gmx.net> writes[color=blue]
><snip>
>[color=green]
>> If the other person creates a folder with the same path as you did for the
>> data.mdb, there won't be any problem.[/color]
>
>[color=green][color=darkred]
>>>> The other person is dropping the files onto a network drive, which is[/color][/color]
>something I don't have so the paths can't be the same.[/color]

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.

re: Linking Tables Problem

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
resource@pcdatasheet.com
www.pcdatasheet.com


"mooseshoes" <mooseshoes@gmx.net> wrote in message
news:DHoWc.11262$EQ7.7871@newssvr29.news.prodigy.c om...[color=blue]
> <snip>
>[color=green]
> > If the other person creates a folder with the same path as you did for[/color][/color]
the[color=blue][color=green]
> > data.mdb, there won't be any problem.[/color]
>
>[color=green][color=darkred]
> >>> The other person is dropping the files onto a network drive, which is[/color][/color]
> something I don't have so the paths can't be the same.
>
>
> Steve[/color]

re: Linking Tables Problem

Mighty cool. Thanks!

re: Linking Tables Problem

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

re: Linking Tables Problem

Always glad to help a fellow "Steve"!

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

Steve
PC Datasheet


"mooseshoes" <mooseshoes@gmx.net> wrote in message
news:0FuWc.11350$GD2.10494@newssvr29.news.prodigy. com...[color=blue]
> 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[/color]

re: Linking Tables Problem

<snip>
[color=blue]
> What's the URL to download "Virtual Drive Creator" ?[/color]
[color=blue][color=green][color=darkred]
>>> Choose your favorite freeware download site or try:[/color][/color][/color]

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

re: Linking Tables Problem

Thanks, Steve! Have a good one.


"mooseshoes" <mooseshoes@gmx.net> wrote in message
news:jHvWc.11366$573.8254@newssvr29.news.prodigy.c om...[color=blue]
>
> <snip>
>[color=green]
> > What's the URL to download "Virtual Drive Creator" ?[/color]
>[color=green][color=darkred]
> >>> Choose your favorite freeware download site or try:[/color][/color]
>
> http://www.smartdownloads.net/download-8487.html[/color]