shared file problem

[Lenny]

Please accept my apologies straight away for not knowing anything about
access.
I have a front end program that is written to use Access databases and both
the program and the database are in the same folder on the C drive. On the
'server' computer all works just fine. I click on the link and the program
opens fine. I have shared and then mapped the drive onto another computer
but when I try to open the program (file type when I right click and check
properties- Access MDE Database) I get an error message that says
C:\database\myprgram_be.mbd is not a valid path.........
I have no problems at all opening the database on it's own though (File
type - Access Application)
Why?
Thanks
Lenny

 

[Jeff Boyce]

Lenny

If I'm following the error message, Access is telling you that it cannot
find the backend file in the location specified (e.g., "C:\database\...")
.... and that makes sense! You mentioned that you put it on a server.

A common topology would be to put a copy of the front-end on each user's PC,
and link to the back-end tables on a LAN server.

But I'm not clear on whether you have an .mdb file or an .mde file...

More info, please

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Lenny]

What I mean by the server is the main PC that the program is based on, in
this case the reception. The program and Access database works fine from the
database folder on this computer. I have then shared the same files over the
network and mapped the network drive to the office computer but even double
clicking on the same file (Which is actually on the X drive of the office
computer (because it is a networked drive)) I then get the error messages on
the program but the database opens fine.

Is it because it is looking for the C:\database file on the office computer
instead of over the network and C on the reception computer? If this is the
case how can I change that link without affecting the reception computer?

Thanks

 

[Jeff Boyce]

Lenny

One approach would be to link to the back-end/table using UNC names, rather
than "share" names. This would look something like:
\\servername\foldername\..."

To do this, open Access to the database window, click on the Tables tab,
select File | Get External ... | Link ...

Then, instead of selecting "C:\..." (the path on the 'server' PC), use the
Entire Network selection and navigate to the file in the folders on the PC
that is 'serving' up the back-end.

This link should work from every PC that is part of that (shared) network.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Lenny]

thanks Jeff, That is very obvious all of a sudden. I appreciate it. cheers.