[AccessD] ADP Connection Problems

If I could get in to change the connection, that would be the end of it.
The problem appears that the connection of an ADP is messed up altogether.
I cannot change any parameters to try it.  I really don't think the SQL
files are the problem.

Debbie



-----Original Message-----
From: MartyConnelly [mailto:martyconnelly at shaw.ca] 
Sent: Friday, January 27, 2006 6:38 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] ADP Connection Problems


runtime error 76 is generally path not found.

So Microsoft OLE DB Provider for SQL Server files
C:\Program Files\Common Files\System\Ole DB\sqloledb.dll
C:\Program Files\Common Files\System\Ole DB\sqloledb.rll
'this one updated by winxp sp2
C:\Program Files\Common Files\System\Ole DB\msdasql.dll

You can run MDAC Component Checker according to this kb article 
run on working and non working machines for differences

http://support.microsoft.com/kb/301202/en-us 

You might be using a File DSN that points locally rather than System DSN



Elam, Debbie wrote:

>I have a legacy database Discipline.adp in Access XP connection to a SQL
>2000 database.  On one particular computer, the database will not connect.
>It gives me a runtime error 76 then tells me to go to File> Connect and
>change the connection parameters.  If I try to open that, it just gives me
>the same error and message. 
>
>I can make an ODBC connection to that same database on that machine.  
>
>I also tried making a new .adp database and making the connection there.
It
>immediately gives me the same error and message and no way to get to that
>menu.
>
>I have already un-installed and re-installed Access, and still get the same
>problem.
>
>Does anyone have any ideas about how to fix this?  I am going for a
re-image
>on Monday if nothing else works.
>
>Debbie
>
>-
>

-- 
Marty Connelly
Victoria, B.C.
Canada



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
- JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject
to the Attorney-Client Privilege, (2) an attorney work product, or (3)
strictly confidential. If you are not the intended recipient of this
message, you may not disclose, print, copy or disseminate this information.
If you have received this in error, please reply and notify the sender
(only) and delete the message. Unauthorized interception of this e-mail is a
violation of federal criminal law. 
This communication does not reflect an intention by the sender or the
sender's client or principal to conduct a transaction or make any agreement
by electronic means.  Nothing contained in this message or in any attachment
shall satisfy the requirements for a writing, and nothing contained herein
shall constitute a contract or electronic signature under the Electronic
Signatures in Global and National Commerce Act, any version of the Uniform
Electronic Transactions Act or any other statute governing electronic
transactions.