Data Source

[Kris]

Hi
I'm trying to write a small project, few forms connected to a
database (Access) I wrote the code and everything is working fine but
when I try to install the program and database on different computer I
get error message. The problem is that the program is looking for a
database in specified path which is different on different computers.
Could someone give me a hint how to prevent such error and I would
really appreciate some code to fix the problem.

Thanks
Kris

 

[Nikos Yannacopoulos]

Kris,

Use UNC addressing, instead of drive mapping. That is, use the server
name and path to folder to reference the back end file, like:

\\ServerName\Folder\SubFolder\...\FileName.mdb

which is independent of drive mappings.

HTH,
Nikos

 

[Kris]

Thanks for that. Will give it a go