liste alle sybase tabeller med access odbc

Its years since I played ariund with Sybase but as SQL Server is based on this then you may be anble to use this.

The sysobjects table conatins information on tables, views etc. so an SQL

SELECT * from sysobjects where type = 'U'

should give you the USER tables. Obviously you will need the correct permissions to select from the table.

In Access it is also possible to make what is called a Pass-through query. This sends the SQL to the database where it gets executed (if valid). It may be necessary to use such a query if the sysobjects table isnt available in the list when you try linking tables.

You can create a Pass-through query in code
http://support.microsoft.com/kb/q210415/

In Access you can make a passthrough query by making a normal query but without selecting any tables. Then right click in the query window and choose SQL Specific and then Pass-Through. Then you write the SQL given above. You can NOT use the SQL designer as the SQL is specific to the database type.
Now when you run the query you will need to choose which DSN to use.

Thanks for the reply Terry,

It won't be possible for me to test this before the end of the month, but sounds like it is what i need :-)

/Claus

Ok, I'll place an answer now hope to hear from you as soon as you have tested.
Terry

.

whats the status here Claus?

Hi Claus
Two months have gone by now, can we close this question please?
mvh
Terry

may as well forget this one

Hi Terry,

sorry for not returning - but my wife gave bith to a son and then and other things became less important :-)

But thanks for yor reply - and sorry for slow reply.

/Claus

Hi Claus
Congratulations with your son, I can fully understand that your family is more important than "work"

and thanks for the points