Manipulate external Access97 databases 1

[Klopper]

From a given Access97 database, what is the best way to check and / or change the properties of tables and queries in OTHER access databases? Specifically tables and pass through queries with Sybase ODBC links.

I have been playing with workspaces and opening databases but without much success - am I barking up the proverbial?

Thanks,
Klopper

 

[Databaseguy]

Dim dbs as database
Dim tdf as tabledef
Set dbs=opendatabase("YourExternalDBName&quot
Set tdf = dbs.tabledefs("YourTable&quot
With tdf
.name = "Something"
.connection = "something else"
'Etc
End with
Set tdf = nothing
Set dbs = nothing Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[Klopper]

Thanks Tyrone, this is the answer I am looking for.

Klopper