Access application linked to fixed database

[Man Utd]

We got an Access 2 application which was written long time ago.
I was testing and investigating the business logic of it. I copied the whole
lot of files (.mdb, .ldb, .dll, .mda,...) into another temp directory.
Then I ran the .mdb from that temp directory, however, I found the original
Access database was changed whenever I played with the application.

How come the Access application linked to the original data?

 

[Douglas J. Steele]

It was probably split into a front-end (containing the queries, forms,
reports, macros and modules), linked to a back-end (containing the tables
and relations). The linkage is hard-coded: it's an absolute path.

Afraid I don't have Access 2 installed on this machine anymore, and I don't
remember whethere it was called the Linked Table Manager or the Attachment
Manager, but look under Add-Ins on the Tools menu to relink which back-end
to use.

 

[Larry Daugherty]

IYour application was properly split into a FrontEnd and a BackEnd..
To get it to safely play as you want, open the FrontEnd in your
sandbox and then go to File|AddIns|Attachment Manager. It's been a
long time since I did it in Access 2.0 but Access 2.0 Help will get
you through the process. You want to un-link the tables from the
former location and then point to the BackEnd you have in the sandbox
and all will be well.

HTH

 

[Albert D.Kallal]

you can read about how this works here:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm