Problem connecting Project to MSDE

  • Thread starter Thread starter Jesse Aviles
  • Start date Start date
J

Jesse Aviles

I have a adp from another person that when i try to open I receive the
following runtime error:
Error No -2147467259 (80004005)
Cannot open database requested on 'ProjTrial'. Login Failed.
(When the project is opened, it has code attached that selects the server
based on wether the computer is connected to a network with SQLServer or to
MSDE)
When I go to File - Connection, the adp is not listed in the server
databases (the samething is happening to NorthwindCS.adp). I have tried to
find a way to add the databases to the MSDE but haven't been able to. There
is no help for MSDE and there is no interface to add them manually. If I
try attaching a database file by name, the adp doesnt get recognized (it
wants a .mdf file). With NorthwindCS, I get a disconnected message and
can't use any of the forms, I cant even see the tables. Thanks for your
help.
 
The SQL-Server service must be running in order to use any databases. You
will see a small server looking icon with a tiny green trianfle in it when
the server is running. If you don't see it, you'll need to turn it on before
anything works.

Once it is opened and running, you'll need to point it to the various
databases so that they can be seen from the Connection menu item in the file
menu.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
The server is running all the time. The databases do not appear as a choice
on the combo box under step 3 of the file - connection dialog box from
access.
 
I just downloaded the State University sample project from the Microsoft
Website and I see a .mdf file which is the one that I can use on the
connection dialog. I dont see a mdf file in the samples folder where
NorthwindCS is located. Only thing in there is NorthwindCS.SQL. With SQL
Server Desktop engine, am I able to create a mdf file? Will the MSDE only
accept mdf files and no others? If I dont have a mdf file, how can I create
one, even for an Access Project for which I dont have the mdf file?
 
Back
Top