I had this problem at first. I updated MSDE to SP3 (use the SPs for SQL 7).
If you are trying to connect to a SQL 6.5 database, I think you have to be
at SP5.
> -----Original Message-----
> From: Peter Froh [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 10, 2001 1:57 PM
> To: CF-Talk
> Subject: OT: Access 2K and MSDE Connection Problem
>
>
> Hi all!
>
> Is there anybody out there that has used access 2k to work with SQL Server
> (or MSDE)?
>
> This is the problem:
>
> I have installed MSDE on our server and then tried connecting to
> it through
> Access 2k on a workstation.
>
> After I open an existing project I choose File->connection and I get the
> error
> message "Microsoft Access could not find the database on the
> server. Verify
> that
> the database name is correct." Even when I try to create a new
> project with
> an existing database I get
> that error.
>
> If I choose to create a new project with a new database it does
> allow me to
> specify the IP of the server and the database does get created in SQL
> Server, but I can't access it from this particular workstation (mine of
> course) I just keep getting the above error.
>
> If I go to another workstation and do the same thing it connects to the
> server with no
> problems and I can work with the SQL database in Access 2k.
>
> I have even gone through the registry and trashed anything related to
> MSSQLServer, deleted and reinstalled Access and used regclean in the hopes
> that it would "clear" the problem. Somehow, somewhere it is remembering a
> bad server address that I typed in when I first tried to connect
> to SQL and
> for the life of me I don't know where Access is getting that information
> from.
>
> I have poured over the MS knowledge base and the Access help files,
> but I have not found the answer yet.
>
> Very frustrated! Any suggestions?
>
> Peter
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
