Re: SQL Error 53 and 17

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Andrew Madsen (andrew.madsen_at_harley-davidson.com)
Date: 06/04/04 

Date: Fri, 4 Jun 2004 09:51:54 -0500

When you say you opened it on 2 PC's do you mean at once or two different
PCs at different times? Also in your earlier messages you said there was
plenty of connections available was that fro SQL Server or the server it is
running on. The connection count can be different. Also have you looked at
the logs for SQL Server after the second machine fails to attach? there
should be some information there identifying the failure to connect or the
refusal to connect.

As far as the application goes:

You get the error if you are trying to connect to a SQL Server from a
second separate instance of the Access file when one is already opened on
another machine? is the Access file shared off of the LAN? Or is it
installed locally to the workstation? 

-- 
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Tom R" <anonymous@discussions.microsoft.com> wrote in message
news:7C523270-F96F-4B48-B548-D88D088D96F7@microsoft.com...
> Yes I just did that. I was able to open the database on 2 PCs.
>
> Here is how the application seems to work from just looking at the front
end.
>
> A GUI opens that has basicly 3 main fields. The top field is
AccessDatabase.mdb. Then then next two are data sources. SQL-Source1 and
SQL-Source2. AccessDatabase.mdb is always the same. SQL-Source1 and
SQL-Source2 can be picked from a pick list. Both SQL sources have DSNs that
I have checked and tested about a million times. Clicking the open button
produces the error after about 30 seconds.
>
> After clicking OK a SQL server login box appears. I can try the login here
but get the same 53 & 17 error. So I just click cancel. Get another error
message: Unable to create link to table "AppAccount" (Action cancled by
user). Click OK and get another error: Error linking in App tables. After
that I am back to the main GUI.
>
> It does not matter what SQL sources I pick. I have about five to pick from
in each list.
>
> Should I be focusing on the Access part more?
Quantcast