Don't ask me how.

We created a new user to the DB and then we had to go TABLE BY TABLE reconnecting the link.

After that - it all worked...

I did not create this database nor setup this ODBC, I am just trying to get it to work again. Why /SYSTEM is doing anything, I don't know. But I...

It still says NT AUTHORITY/SYSTEM Failed to open the explicitly specified database. Then dies.

Now I am getting Password does not match that for the login provided. This is in the SQL server logs.

But I can refresh the link on any table....it does...

I removed Trusted Connection from DSN because I could not link tables using Trusted Connection check box.

Ok, new development.

I opened 1433 in my SQL firewall - I created a SQL ODBC connection and it worked!!

I then ran Linked Tables Manager in Access and entered my...

They double click the db2 file and then it opens in Access. Forms then run.

A couple questions:

1. What or whom is trying to use the Access database when you get this error? Is it a Windows service (something unattended) or an interactive user (i.e....

- The DB is no longer there

In SQL Service Management - I can log into the DB and see it and see permissions and users.

- The DB cannot be...

As far as updates or service packs, there have not been many. This db has been used in an archival mode only for the last 2 years. We look at...