My configuration:
All my site files are on a remote server including a simple db. When I try to specify the database connection through my
local computer.

My problem:

Within 'Connection' dialog box:

I get this error when I try to test the connection to a data source on a remote server, when I've specified within the DSN

dialog box "Using DSN on App Server".

Operation was canceled.

Operation was canceled.

-------------------------------

And when I specify 'Using Local DSN', it returns with this error:

[Microsoft][ODBC Microsot Access Driver]General error Unable to open registry key
'SOFTWARE\ODBC\ODBC.INI\customer_db.mdb'.

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

Can anyone help a frustrated IT individual??