Access and SQL server

[Phonez]

I am currently looking for a way to query a field in an access database against a field in an SQL server database.

Is this possible or do the fields have to be in the same database

Thanks in advance

 

[Jonax]

If you rightclick TABLES in Access, you have an option to LINK TABLES... If you do this you can have SQL-Server tables acting as local Access tables...

I guess that should do the trick... This is not a bug - it's an undocumented feature...
;-)

 

[Jonax]

Oh yeah:
You should set up a DSN in ODBC-Datasources that connects to the SQL-Server in question.
After doing this, you should link the tables - select ODBC Databases as the filetype. This is not a bug - it's an undocumented feature...
;-)

 

[Phonez]

Sorry for the long delay in replying. I have been trying out both ways, creating an odbc connection and linking the tables through the odbc in access.

For some reason I cannot connect to the database in asp. Is there a way to specify a password for linked tables because I believe this could be the problem.

Thanks

 

[Jonax]

You setup login-info when you create the DSN... This is not a bug - it's an undocumented feature...
;-)