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?

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Man Utd" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?
>
>

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
--
-Larry-
--

"Man Utd" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?
>
>

you can read about how this works here:

http://www.members.shaw.ca/AlbertKal...plit/index.htm


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.members.shaw.ca/AlbertKallal