How Can I Find What a Linked Table is Doing?

[txdave35]

Hey guys,

Still trying to figure out this Access mdb. It was set up with several linked tables to our live SQL server. Behind the scenes are VB instructions for running a control form.

I need to figure out exactly where the form is pulling data from in the live database behind the scenes. I tried looking in the object properties and Event, but that just takes me to the VB codes. Is there any way to easily see what a linked table is doing?

 

[MajP]

What is in the forms "recordsource" property? This tells you where the data comes from for the form.

 

[txdave35]

The record source is referencing one of the tables designed in the Access database. Apparently, the macros and queries are pulling data from our SQL server and importing into this table in Access.

 

[ProgramError]

Isn't this the same question you are asking in the thread thread702-1549711 ?


Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.

 

[JoeAtWork]

Linked tables don't "do" anything. They are just there as a source of data. Your form may be:

1. Linked to a table or query (if it's Record Source property is filled in), with controls that are bound to specific fields in the table/query (in order to be bound to a field, a control's "Control Source" has to be filled in
2. Linked as above, but also there may be code which could be doing almost anything - you would need to look at the code to find out
3. Unboud (i.e. the form's Record Source is blank), in which case everything must be done through code