Access 2000 Link to SQL Server db tables

[Joe K.]

I have a Access 2000 database that has approximately 100 tables. I would
like to link the Access tables to SQL Server database tables to give better
access to the report and forms in Access. Please let me know the best way to
link Access tables to SQL Server database tables.

Thanks,

 

[John W. Vinson]

I have a Access 2000 database that has approximately 100 tables. I would
like to link the Access tables to SQL Server database tables to give better
access to the report and forms in Access. Please let me know the best way to
link Access tables to SQL Server database tables.

Thanks,

Ummmm.... what kind of "link" do you have in mind?

You can use File... Get External Data... Link to connect your Access frontend
(forms, queries, reports, etc.) to an existing ODBC connection to a SQL/Server
database. You may need some tweaking of the frontend, JET (the Access builtin
database engine) and SQL are somewhat different.

If you mean you want to link local Access tables to other SQL tables, please
explain the nature of the "link".