Use Access Link table to use SQL server tables.# Database - 数据库
b*u
1 楼
I have an SQL server database host on the server. And I have a tiny Access
application, which just includs some reports, base on those SQL server tables.
I used link table in the Access.
The problem is, to use link table, I need to set up ODBC for the SQL server. I
set it up on the computer that SQL db is hosted. Both Access application and
the SQL server are on network. I want to open the Access application from
another computer in the network, but I got error that says "ODBC - connection
to [S
application, which just includs some reports, base on those SQL server tables.
I used link table in the Access.
The problem is, to use link table, I need to set up ODBC for the SQL server. I
set it up on the computer that SQL db is hosted. Both Access application and
the SQL server are on network. I want to open the Access application from
another computer in the network, but I got error that says "ODBC - connection
to [S