Modifying an Open Source Database

[Blue_Jazz]

Hello everyone, I am somewhat of an intermediate MS Access user and I have come across a problem that I need some guidance with. Please bear with me as I attempt to explaint the problem I am experiencing. I downloaded a public domain database from some freeware site and I am in the process of modifying it for use in my small business. I copied all of the tables from the DB in the freeware version to a newly created db on my hard drive and proceeded to work on modifying the newly created db. I did this because the freeware version had some linked tables that I didn't want to have to deal with. Anyhow, all was going well until I moved the database to a shared directory on the network. What I am realizing is that the freeware version was an executable that installed to my hard drive. When I copied all of the tables and code to a new DB, the code still references the program path that the executable installs to. So now, I have a form and an HTML file that calls to the program path in order to load. So, my question is, how can I track down all references to the program path in the code, and change it. Once I locate the program path, what do I change it to? Is this something anyone can help me with? If so, I would really appreciate it. My boss is on me to get this thing completed.

Thanks,
Robyn

 

[MHM]

Hey Robyn,

you may need to change the connections of each _connected_ table to a new destination - and of course the mdb the connected tables refer to.
At best call the "connection-wizard" at Extras/addins and choose to connect to the new location.

Should work.

(We normally deliver a code to customers checking all connections and in case trying to connect to a new destination.)

Mic