adding a reference to the table

[talktobatchu]

Hello,
I have several tables of data in my access database and they are
from different sources. How can I keep a reference or track or add a note to
the table for identifying the source? Is there any way this can be done in
access! Thanks for any help.

talktobatchu.

 

[Ken Snell [MVP]]

Is there any reason you can't add a field to the table that would hold a
text string or other value that would identify the source of the data
record? You could populate that field whenever a new record is added to the
table.

 

[Van T. Dinh]

It is inbuilt in Access!

If you hover the mouse on the Table name in the Tables tab of the Database
Containers window, the Connection String (the source) will appear for the
Table looking like a ToolTip.

Alternatively, in code:

CurrentDb.TableDefs("TableName").Connect will give you the Connection
String.

If you really want to (after the above), you can right-click on the Table
then select Properties and you can type your note in the Description box.