Access / SQL Server 2000 Redistributable

Hello,
I want to upgrade my Access 2003 app to have a
VB 6.0 front-end and SQL Server 2000 Standard back-end, that I want
to sell on the market. I do not want to use MSDE
because of the 2GB limitation. My questions are:
1) will my customers have to purchase SQL Server 2000?
(or me, and then give them the copy w/ my app).
2) what is the best way to wrap this up in an install
package? I already have InstallShield Express 4.0
and SageKey's Access 2003 MSI Wizard; am investigating
if these will let me include SQL Server. . . any ideas
on how to mass-sell something w/ SQL Server back-end?
Thanks,
Christy Warner.
Christy Warner
www.autoaudit.com
1) Yes, they will have to purchase a copy of SQL Server standard edition.
2) Most people use a DSN, and then have an install script. This install
script can either create the database and schema, and populate it with data,
or they attach a database withe the schema and data in place.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"ChristyWarner" <cwarner@.autoaudit.com> wrote in message
news:79169CF3-5804-47D1-B91B-59791AB1037C@.microsoft.com...
> Hello,
> I want to upgrade my Access 2003 app to have a
> VB 6.0 front-end and SQL Server 2000 Standard back-end, that I want
> to sell on the market. I do not want to use MSDE
> because of the 2GB limitation. My questions are:
> 1) will my customers have to purchase SQL Server 2000?
> (or me, and then give them the copy w/ my app).
> 2) what is the best way to wrap this up in an install
> package? I already have InstallShield Express 4.0
> and SageKey's Access 2003 MSI Wizard; am investigating
> if these will let me include SQL Server. . . any ideas
> on how to mass-sell something w/ SQL Server back-end?
> Thanks,
> Christy Warner.
> --
> Christy Warner
> www.autoaudit.com
>
|||What's wrong with MSDERelA? It's free!
Cons: No Enterprise Manager (but who needs it?)
HTH. Aubrey
"Hilary Cotter" wrote:

> 1) Yes, they will have to purchase a copy of SQL Server standard edition.
> 2) Most people use a DSN, and then have an install script. This install
> script can either create the database and schema, and populate it with data,
> or they attach a database withe the schema and data in place.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "ChristyWarner" <cwarner@.autoaudit.com> wrote in message
> news:79169CF3-5804-47D1-B91B-59791AB1037C@.microsoft.com...
>
>