Deploying access project

[damjanu]

Hi;

I have spent some time investigating this issue, and I would like to
verify with you my findings. I would greatly appreciate someone
experianced saying yes to what I concluded, or no and why....

I have access project. It was developed on MS SQL Server 2000 full
edition....
I want to destribute it to my customers. They do not need MSSQL
Server.

I understand that I can package my access project with Microsoft SQL
Server 2000 Desktop Engine (which is lighter version of MSSQL Server,
but (equally???) capable database in its core?) using Microsoft Office
Developer. It would turn my project and MS SQL DE into an exe file
which would be
easily installable to clients machine.
Am I right? Is this the only way to do this?

Thanks a lot
Damjan

[Jerry Boone]

You are correct, with exception to some limitations on database size and
user concurrency in using MSDE (desktop engine). Read the MSDE White Paper
to find out more, from Microsoft of course.

The Office developer edition has a wizard that will package the entire
installation. I would suggest deploying .ADE instead of .ADP with the
access runtime if you want to protect your code.

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz

<da*****@hotmail.com> wrote in message
news:2f**************************@posting.google.c om...

Hi;

I have spent some time investigating this issue, and I would like to
verify with you my findings. I would greatly appreciate someone
experianced saying yes to what I concluded, or no and why....

I have access project. It was developed on MS SQL Server 2000 full
edition....
I want to destribute it to my customers. They do not need MSSQL
Server.

I understand that I can package my access project with Microsoft SQL
Server 2000 Desktop Engine (which is lighter version of MSSQL Server,
but (equally???) capable database in its core?) using Microsoft Office
Developer. It would turn my project and MS SQL DE into an exe file
which would be
easily installable to clients machine.
Am I right? Is this the only way to do this?

Thanks a lot
Damjan