SQL Server Question

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

Hi all-

I have an Access Data Project (.adp) file that I got from
a friend, and I wanted to open it on my computer, but I
couldn't, even though the SQL server on my pc is running.
Does that mean when you create an adp file, the database
including tables, queries, and reports will be stored in
the SQL Server, NOT in the adp file itself, so that when
you try to open it on a different computer with another
SQL server it will not work?!! If not, what can I do to
open this file?

Thanks
 
Jack said:
Hi all-

I have an Access Data Project (.adp) file that I got from
a friend, and I wanted to open it on my computer, but I
couldn't, even though the SQL server on my pc is running.
Does that mean when you create an adp file, the database
including tables, queries, and reports will be stored in
the SQL Server, NOT in the adp file itself, so that when
you try to open it on a different computer with another
SQL server it will not work?!! If not, what can I do to
open this file?

Thanks
Click to expand...

Your'r best re-asking this on the newsgroups specialising in Access
and/or SQL Server ...
 
I tried to do that, but I couldn't find any newsgroup
here that specializes in Access and/or SQL Server!
 
That is correct. An ADP file only describes the
connection. It doesn't contain any of the tables, views,
stored procedures, queries, etc. Those are housed
elsewhere on a SQL Server, MSDE server, etc.
 
I tried to do that, but I couldn't find any newsgroup
here that specializes in Access and/or SQL Server!
Click to expand...

That's surprising. These available:

SQL Server:

microsoft.public.sqlserver.programming
microsoft.public.sqlserver.server
microsoft.public.sqlserver.connect
microsoft.public.sqlserver.clients

Microsoft Access:
microsoft.public.access.3rdpartyusergroups
microsoft.public.access.developerstoolkit
microsoft.public.access.3rdpartyusrgrp
microsoft.public.access.developerstoolkitode
microsoft.public.access.activexcontrol
microsoft.public.access.devtoolkits
microsoft.public.access.adp.sqlserver
microsoft.public.access.externaldata
microsoft.public.access.chat
microsoft.public.access.forms
microsoft.public.access.commandbarsui
microsoft.public.access.formscoding
microsoft.public.access.conversion
microsoft.public.access.formsprogramming
microsoft.public.access.customcontrols
microsoft.public.access.gettingstarted
microsoft.public.access.dataaccess.pages
microsoft.public.access.importexportlink
microsoft.public.access.developers.toolkitode
microsoft.public.access.internet
microsoft.public.access.interopoledde
microsoft.public.access.replication
microsoft.public.access.macros
microsoft.public.access.reports
microsoft.public.access.modulesdaovba.ado
microsoft.public.access.reportsprinting
microsoft.public.access.multiuser microsoft.public.access.security
microsoft.public.access.multiusernetworks
microsoft.public.access.setupconfig
microsoft.public.access.odbcclientserver
microsoft.public.access.setupconfiguration
microsoft.public.access.odbcclientsvr
microsoft.public.access.tablesdbdesign
microsoft.public.access.queries
 
Thanks a lot, that makes sense!

-----Original Message-----

That is correct. An ADP file only describes the
connection. It doesn't contain any of the tables, views,
stored procedures, queries, etc. Those are housed
elsewhere on a SQL Server, MSDE server, etc.





.
Click to expand...
 
Back
Top