Ms Access 2003 Project (.adp) database connection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gabry.morelli@libero.it - 04 Jan 2007 08:45 GMT

Hi everybody,

I wanted to start an application using the MS Access 2003 Project, but
as I create an .adp file it asks me to connect to a SQL Server. But I
needed to create the dabase directly inside the adp project. Is that
possible? If so, what's the procedure to create it?

Thank you for your help.

Reply to this Message

Lyle Fairfield - 04 Jan 2007 10:47 GMT

> I wanted to start an application using the MS Access 2003 Project, but
> as I create an .adp file it asks me to connect to a SQL Server. But I
> needed to create the dabase directly inside the adp project. Is that
> possible?

Probably not in the way you describe. Access is not a database
engine/server. It must use something else for those services.
Typically an ADP uses a MS-SQL Server connected via ADO (although many
of the connections and their charactertistics are arcane). This Server
is entirely independent and separate from Access.
An MDB uses JET which also hosts the Access application but it can link
to many technologies through ODBC also.
The AccDB of 2007 uses ACE which seems to be a very minimally modified
JET with (not always) a new spelling.

I'm trying to envision an ADP without MS-SQL server but so far the
screen is just Snow and the sound intermittent scraps of "Fools Walk
In, Where Wisemen Never Go". Then again there may be other Wisemen.

Reply to this Message

Tom van Stiphout - 04 Jan 2007 14:14 GMT

Not possible.
You first need to install SQL Server, e.g. using a free download of
the Express Edition.
Once installed, you can use SQL Server tools or indeed MsAccess to
create a new database, and access it from your application.

-Tom.

>Hi everybody,
>
[quoted text clipped - 4 lines]
>
>Thank you for your help.

Reply to this Message

gabry.morelli@libero.it - 05 Jan 2007 10:04 GMT

Thanks a lot guys, I found what I wanted using a workgroup file. In
that way I can manage users access and still using tables inside the
mdb file.

Thanks a lot anyways!!

Cheers
Tom van Stiphout ha scritto:

> Not possible.
> You first need to install SQL Server, e.g. using a free download of
[quoted text clipped - 12 lines]
> >
> >Thank you for your help.

Reply to this Message