Flash Memory Disk changed when I use it in other computer

  • Thread starter Thread starter samm
  • Start date Start date
S

samm

Hi for all

Flash Memory Disk changed when I use it in other computer
so I made link tabel to flash memory disk name's (H) in
my Home Copmuter then I used it in Work Computer but the
disk name became (G) so I can't open the data,
 
Sam,

If linking to a removable medium (other than a floppy) is your only choice,
then I'm afraid you'll have to live with that situation. The best suggestion
I can offer is to use some code at db startup to recognize the computer (by
its name) and relink the tables accordingly. Alternatively, you could make a
folder with the same name under C: on all computers you use, and copy your
back end back and forth so you don't have to play with the links.

Nikos
 
samm said:
Hi for all

Flash Memory Disk changed when I use it in other computer
so I made link tabel to flash memory disk name's (H) in
my Home Copmuter then I used it in Work Computer but the
disk name became (G) so I can't open the data,
Click to expand...

Code for using the Windows Common Dialog API directly can be found at
http://www.mvps.org/access/api/api0001.htm.

Also, visit http://www.mvps.org/access/resources/downloads.htm and look for
the "Orders.MDB and Solutions.MDB". In the Solutions MDB, there's a topic
"Use multiple databases" with a subtopic "Relink tables at startup" that
will have code you can either use or adapt.

As the other poster said, you will need to dynamically set the links, or
copy the database. The two references I gave should help with the first
option, and I'd suppose that you'd do the second manually.

Larry Linson
Microsoft Access MVP
 
Back
Top