Connecting .adp file to SQL database

[Bob W]

I am trying to learn .adp applications. My planned first step was to
checkout NorthWindCS.adp in the office Samples folder. I am using Access2002
and have installed Microsoft SQLServer Desktop Engine Version 8.00.194. On
boot up the SQLServerService Manager Icon appears on the task tray and
aftera short while indicates green and says running. Checking the icon
brings up the Service Manager popup showing SERVER: WUND100 (that is my
computer name); SERVICES: SQL SERVER; auto start on when OS starts: Running
: \\WUND100- MSSQL Server

When I then select NothwindCS.adp and open it I get a message:
" Please select computer with MicrosoftSQLServer installed and running from
the following dialog & choose any database on the server" There is no
dialog box, only OK. Checking the task tray, the icon for the service
Manager has diappeared. Checking Windows Task manager Processes shows a file
called sqlServer.exe is running.

If I reboot the computer the Service Manager icon appears but on trying to
run an .adp application the whole process fails again with the icon
disappearing. It acts like the SQL connection fails the system when called
upon. Any help much appreciated.

 

[Sylvain Lafontaine]

You must configure NorthwindCS.adp to use the local server. From the menu:
File --> Connection. From there, fill options 1, 2 and 3: Server, Login and
Database.

 

[Sylvain Lafontaine]

I forgot to say that there is a newsgroup about ADP:
m.p.access.adp.sqlserver .

 

[Bob W]

I tried to configure option 1 wund100, 2 NTF, 3 Select database as
C:......... \samples\ NorthwindCS.sql and then got an error message
"[DBNetList][Connection Open(conect()) SQL Server does not exist or Access
denied" I tyried to reopen the original program NorthwindSC.adp and I got
an error message ttated below "Please select a computer
with.........Microsoft SQLServer instaled and running ...." The SQL server
seems to shut down or not be visible. the tray icon is gone but
sqlServer.exe stills shows as running on the task window. I am stuck and do
not know enough to diagnose where the process breaks down. Help

 

[Sylvain Lafontaine]

Files such as C:......... \samples\ NorthwindCS.sql are not database files
but are text files with all the necessary SQL commands to recreate the
database on a SQL-Server. These files can be run from a program such as
SQL-Server Query Analyser to create a new database.

The Attach A Database File that you have seen in the connection window are
for databases that have been previously detached and have the suffixes .MDF
and .LDF and cannot be used with .SQL files.

It's my opinion that the installation procedure of Access should have
already done the step of creating a database on the SQL-Server; however, as
I never installed or use the exemple NorthWindCS.adp, I cannot tell you for
sure. If the database has already been created, then you should be able to
choose it from the dropdown list in the connection window.

From Access, you can create a blank new Project (or ADP) by using an
existing database or by creating a new database. I suggest that you explore
these two possibilities to have a better understanding of SQL-Server and see
what's missing from the installation of the Northwind exemple.

The lack of administrative tools such as Enterprise Manager with the
installation of MSDE is a real pain. I suggest that you download a free
tool such as EMS MS SQL Manager Lite for Windows
(http://www.sqlmanager.net/en/products/mssql/manager ) to get an easier way
of administrating your MSDE. The next version of MSDE, SQL-Server 2005
Express, will have better administratives tools.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

I tried to configure option 1 wund100, 2 NTF, 3 Select database as
C:......... \samples\ NorthwindCS.sql and then got an error message
"[DBNetList][Connection Open(conect()) SQL Server does not exist or Access
denied" I tyried to reopen the original program NorthwindSC.adp and I got
an error message ttated below "Please select a computer
with.........Microsoft SQLServer instaled and running ...." The SQL server
seems to shut down or not be visible. the tray icon is gone but
sqlServer.exe stills shows as running on the task window. I am stuck and do
not know enough to diagnose where the process breaks down. Help

You must configure NorthwindCS.adp to use the local server. From the
menu: File --> Connection. From there, fill options 1, 2 and 3: Server,
Login and Database.