Linked tables

Hey,
I'm trying to link a table in an Access 2000 DB to a table in an MS SQL
Server 2000. As you might have guessed by now I'm not having any luck
with this.
This is what I've done:
I've used a file-dsn, which logs on to the SQL Server DB using the
logged on NT account. This account, which is used to log on to the
website, has sufficient permissions to view the data in the linked
table. I've also tested the dsn locally and it all works fine. Still,
when I try to execute a query from the website, which uses data from the
linked table, I get an error message saying this:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'SQL
Server(local)' failed.
Does anyone have a clue?
______________
the woim toins
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!Instead of a DSN, you'd be better off writing code and supplying the
connection information directly through the connection string in
VBA/DAO to link tables. DSNs are notoriously difficult to support and
debug. Examples of ODBC connection strings can be found at
http://www.able-consulting.com/ADO_Conn.htm. Also, make sure that the
Windows user/group has been granted a login and permissions in the
database if you are using integrated security.
-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
On Tue, 10 Feb 2004 06:21:43 -0800, Harlan Dorado
<harlandorado@.spray.no> wrote:

>Hey,
>I'm trying to link a table in an Access 2000 DB to a table in an MS SQL
>Server 2000. As you might have guessed by now I'm not having any luck
>with this.
>This is what I've done:
>I've used a file-dsn, which logs on to the SQL Server DB using the
>logged on NT account. This account, which is used to log on to the
>website, has sufficient permissions to view the data in the linked
>table. I've also tested the dsn locally and it all works fine. Still,
>when I try to execute a query from the website, which uses data from the
>linked table, I get an error message saying this:
>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'SQL
>Server(local)' failed.
>Does anyone have a clue?
>______________
>the woim toins
>
>*** Sent via Developersdex http://www.examnotes.net ***
>Don't just participate in USENET...get rewarded for it!