Have you gone into access and pointed each table towards the sql server?
I have done this many times, by simply creating an ODBC link, then going
into Access and right clicking and select link table, then choose ODBC
link...

Cant be more specific than that.

Also, is there any logic in the access database, that points towards
another Access file or table. Check macro's and modules.

Hope it helps.
__________________________________________
Anthony Hand
DBA | Systems Integration
Aon Risk Services Australia Ltd
Ph: +61 2 9253 7516
Fax: +61 2 92537952
Mob: +61 415 877 988




"Sean Rodgers"
<[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed]
hoo.co.uk> cc:
bcc:
30/04/2003 05:14 Subject: ODBC question
AM






Hi All......


I am currently in the middle of transferring data so that it is held in a
sql-server database rather than an access database while still keeping an
access front end. (with forms/queries etc)

There are 6 users with runtime versions of access. (on PC's on the network)
These connect to the access database on a server.(which holds the data).
This currently works fine. I have now moved the data from access database
to
a sql server and put ODBC linked tables into the access database on the
server. The runtime is then pointed to the new db.

If I then run the new access database on the server it is fine and the
application works. I then try to run the access runtime versions on the
PC's which points to this access database and I get an ODBC error saying
the
connection failed.( the ODBC connection which fails is the one that
connects
the access database and the sql server db on the server).

Anyone got any ideas?

Thanks,

Sean






**********************************************************************
"The information contained in this email and any attached files is strictly private and confidential. This email should be read by the intended addressee only. If the recipient of this message is not the intended addressee, please call Aon Risk Services Australia, Aon Consulting, Aon Re Australia Ltd and other associated Aon Companies on +61 2 92537000 and promptly delete this email and any attachments.

The intended recipient of this email may only use, reproduce, disclose or distribute the information contained in this email and any attached files with Aon's permission. If you are not the intended addressee, you are strictly prohibited from using, reproducing, disclosing or distributing the information contained in this email and any attached files.

Aon advises that this email and any attached files should be scanned to detect viruses. Aon accepts no liability for loss or damage (whether caused by negligence or not) resulting from the use of any attached files."
**********************************************************************

MS Sql Server LazyDBA home page