Linked File Specs

[Paul Hammond]

Over time databases tend to collect a number of defunct file specs. Many of
these are almost identical. How is it possible to tell which spec a linked
file is using so that I can reference that in code or simply delete the
spurious ones to make the program easier to debug?

TIA,

Paul Hammond

 

[Roger Carlson]

Open the linked table in Design View. I will complain that you cannot make
design changes, but do it anyway. Then view the Properties of the table.
(Use the Properties button on the toolbar or go to View > Properties.) The
Description line of the Properties box should look something like this:

Text;DSN=Myfiles Link Specification,...(more stuff)

the part following DSN= is the specification used to link that table.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Paul Hammond]

Thanks, that worked.