Cycle through db tables

[Guest]

I want to be able to open a blank Access db, then connect to a SQL Server db
using:
Set cnDB = CreateObject("ADODB.Connection")
cnDB.ConnectionString = "Provider=SQLOLEDB.1; Integrated Security=SSPI;" _
& "Persist Security Info=False; Initial Catalog=ProjectServer;Data
Source=jnicapproject"
cnDB.Open

Then cycle through all the tables in the SQL Server database looking for a
specific field name. Can this be done?

 

[Guest]

You could use sysobjects table:

select name
from sysobjects
where type='U'

HTH

 

[Tim Ferguson]

Then cycle through all the tables in the SQL Server database looking
for a specific field name. Can this be done?

Look up help for the ADOX.Catalog object.

Hope that helps


Tim F