Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kamii47
Constraint Violating Yak Guru
353 Posts |
 Posted - 2006-03-19 : 01:40:16
|
| My questiin is i have that what is the query in Ms Access thatreturns All the nams of our databases in Access and similar way allthe names of table in one particular database. |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-03-19 : 03:09:53
|
| SELECT NameFROM MSysObjectsWHERE (Name Not Like "MSys*")AND (Type In (1,4,6))ORDER BY Name???Sucess Comes to those who Believe in Beauty of their Dream.. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-20 : 01:34:42
|
Also post your Access related questions at Access Forum  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
All databases name and and tables name is access