Icon Confusion

[Jackson]

I'm installing an Access application on a single computer
for use by two different user groups each with their own
data set (mdb). I've created two folders, call them A and
B. Ive installed the application (mde)in both folders and
A's mdb in the A Folder and B's mdb in the B folder. I've
created two icons on the desktop that target the mde's of
each user group, but when I click the icons they both open
the DB with A's data in place. What can I do to get A's
icon to open A's data and B's icon to open B's data?

Many thanks.

 

[Joan Wild]

Hi Jackson,

It isn't the icon that you need to change, but the mde in folder B.

The application contains links to the data mdb. When you copied the
application, you copied the same file to folder A and to folder B, so they
are both linked to the same data.

Open the B shortcut. Go to Tools, Database Utilities, Linked Table Manager,
select all the links, put a check in the 'always prompt for new location' at
the bottom, and locate the data mdb in B's folder.

It is unusual to keep separate databases for data. Won't you want to query
based on the combined data?