Signed StationeryI am using the linked table manager to connect the front
end of my database to a different back end.  Sometimes when I 'select all'
once the manager has located the back end it links all the selected tables
after one prompt. Sometimes it gives me a location prompt after each
individual table - very tiresome with 30 tables!

I know it isn't the 'always prompt for new location' check box.  That merely
allows you to select a new location, even when the old one is valid,  Any
thoughts on how to control this would be very welcome


Steve K
~~~~~~~~~~~~~~~~~~
Steve Klein
tel:         0118 984 5109
mobile   0797 181 5676
~~~~~~~~~~~~~~~~~

That's happened to me quite often as well - however, for the most part, 
the pattern I've noticed is that if there is more than 1 existing source 
for the tables.
eg: 
Table1=C:\db1.mdb
Table2=C:\db1.mdb
Table3=C:\db1.mdb
Table4=C:\db2.mdb
Table5=C:\db1.mdb
Table6=C:\db1.mdb

Because the source of Table4 is different, it will prompt you for the 
source of every table.

If you have 2 backend files that are linked, do all the tables from one 
file, then all the files from another

However, sometimes it just screws up and keeps asking you.

Steven