I know, poor naming convention but...can't find table

[cpberg1]

Hey all,

Working in someone else's Access 2003 database. Based on my limited knowledge of VBA and access I expected to find a table called "CFI11 for CFIMaster_form" (read code below). However no such table exists. Can someone point me in the proper direction? The SQL is the same as [CFI11Basic].CFIID which actually has a corresponding table "CFI11Basic". All my code is working fine just trying to lean and understand other techniques;

C

        strSQL = "SELECT [CFI11 for CFIMaster_Form].CFIID, [CFI11 for CFIMaster_Form].CFI11LastName, [CFI11 for CFIMaster_Form].CFI11FirstName " & _
                "FROM [CFI11 for CFIMaster_Form];"

 

[Galaxiom]

It would be a query. Queries and tables are essentially the same thing to SQL until you get to the advanced stuff.

 

[RainLover]

Someone may have hidden it.

In Access Options Click the View Tab. See if all three options on the right are checked. This may make the Table appear. No guarantee.

Don't forget to restore back the way it was.