MSysObjects question

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

I have a very simple report that shows me all the tables
in the app. But, since I have split the database, I do
not show any tables. I used the following to show before
splitting and am lost on what and where to add so the
tables show. Boths ends are in the same folder on the
same server. I tried it with everything located on my
harddrive (split) but still can't get it.

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((Left([Name],4))<>"MSys") AND ((MSysObjects.Type)
=1))
ORDER BY MSysObjects.Name;

Any help is welcomed.
*** John
 
Graham, thanks.
*** John

-----Original Message-----
Hi John

Linked tables have a Type of 6, not 1.

--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

I have a very simple report that shows me all the tables
in the app. But, since I have split the database, I do
not show any tables. I used the following to show before
splitting and am lost on what and where to add so the
tables show. Boths ends are in the same folder on the
same server. I tried it with everything located on my
harddrive (split) but still can't get it.

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((Left([Name],4))<>"MSys") AND ((MSysObjects.Type)
=1))
ORDER BY MSysObjects.Name;

Any help is welcomed.
*** John
Click to expand...


.
Click to expand...
 
Back
Top