Linking Tables Problem

[Jay]

Hi all,

I've got a FE linked to the tables in the BE. Everything works WONDERFUL of
my computer. Sadly, nowhere else.

The issue is the network drives. When I linked the tables, the location in
a E: drive, which I have mapped to the network drive 'testdev\rnd'. When I
create the link in the tables, it shows the path of the link as:
'E:\AccessDB\BackEnd' when it should in fact be:
'\\testdev\rnd\AccessDB\BackEnd'

In code, I access another Excel file template, using the full pathname and
it works fine, but when I try to run queries on the form (for combo boxes),
it says it can't find the file in E:\AccessDB\BackEnd. I don't know how to
change the path name of the BE.

I tried changing, in the FE, the link by entering design mode, right
clicking and entering properties, and changing description but it doesn't
work. And that's the only place I can find the path of the BE.

If anyone can help me out here, I'd appreciate it. This little stuff is
death by a thousand cuts...

Thanks,
Jay

 

[Jeff Boyce]

Jay

In the Linked Table Manager window, check one of the tables and check the
(?) always prompt checkbox at the bottom. When the window pops up for you
to identify the file, follow your Network path, rather than your named
"share" (on your PC, "E:"), to identify/select the table.

Do this for any/all tables you need to link via the UNC (e.g.
\\yourserver\yourpath\yourfile)

Regards

Jeff Boyce
<Office/Access MVP>

 

[Jay]

That did it! Thanks!

Jay

Jay

In the Linked Table Manager window, check one of the tables and check the
(?) always prompt checkbox at the bottom. When the window pops up for you
to identify the file, follow your Network path, rather than your named
"share" (on your PC, "E:"), to identify/select the table.

Do this for any/all tables you need to link via the UNC (e.g.
\\yourserver\yourpath\yourfile)

Regards

Jeff Boyce
<Office/Access MVP>