MSDE 2000 installation

Hi,
I'm creating an install disk that our company is distributing to a selected
group of our immediate direct customers. We are using the SQL server database
in house and we are creating a program that these customers can enter
contract data at their own PC, print the data in a report format and then
send us the contracts with the remittance report. We are developing an
executable program that uses a SQL server database with 6 tables in house.
I'm using installshield to create a disc that the user will load onto their
own PC. We want to be able to populate these tables by having the user's log
onto our web site and doing a update for the latest table updates. So far
I've been pursuing the idea of using MSDE 2000 for the user's PC's, however,
is this the wisest decision. Would it be better (simpler) to use a different
database on the user's PC's and use a driver to import data from our SQL
server tables to the database on the PC. If MSDE 2000 is the best bet, where
does MDAC version 2.6 come in the picture or does it. I know this is fairly
lengthy message, but I could use some direction on this
MSDE is an alternative for MS Access. It is more robust and can scale up to
SQL Server SE or EE. It has royalty free re-distribution rights; however,
the caveat is that you can not use the SQL Server Administrative tools. You
must code your own administrative features into your application yourself.
It can be more complex; however, it may be worth your time.
MDAC automatically gets installed when you install MSDE onto the client.
Sincerely,
Anthony Thomas

"Randers" <Randers@.discussions.microsoft.com> wrote in message
news:B5893843-1A3D-4207-94BF-8480B9FEB5AF@.microsoft.com...
Hi,
I'm creating an install disk that our company is distributing to a selected
group of our immediate direct customers. We are using the SQL server
database
in house and we are creating a program that these customers can enter
contract data at their own PC, print the data in a report format and then
send us the contracts with the remittance report. We are developing an
executable program that uses a SQL server database with 6 tables in house.
I'm using installshield to create a disc that the user will load onto their
own PC. We want to be able to populate these tables by having the user's log
onto our web site and doing a update for the latest table updates. So far
I've been pursuing the idea of using MSDE 2000 for the user's PC's, however,
is this the wisest decision. Would it be better (simpler) to use a different
database on the user's PC's and use a driver to import data from our SQL
server tables to the database on the PC. If MSDE 2000 is the best bet, where
does MDAC version 2.6 come in the picture or does it. I know this is fairly
lengthy message, but I could use some direction on this