MSysObjects Does Not List All Tables

J

Justin

MSysObjects only lists 12 local tables, but there are well over 100 in my
MDB. Does anyone know why? The tables that are not listed in MSysObjects
cannot be queries through DoCmd.RunSQL, DLookup or Recordset operations.
Help!
 
B

Brent Spaulding \(datAdrenaline\)

How are your view the tables from MSysObjects? Through a Query or directly
at the table level? ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tables/Queries Exists() Function 4
How to clean up MSysObjects 3
copy SQLserver tables into .mdb (not linked) 0
Access Forms disappeared 1
>> List of database queries 4
record count of table while looping through all tables 2
Code without Form 5
Sumif does not work 2

Top