all groups > sql server programming > november 2004 >
You're in the

sql server programming

group:

MSDE to Access?


MSDE to Access? TheNortonZ
11/21/2004 11:09:38 PM
sql server programming:
We have an application (client server, single user, all installed on the
users machine) and we use MSDE 2000.

One major complaint we have had is that if people download the product from
the web, it is such a large download (70mb) just for the desktop engine.

Our marketing department is now asking what other options we have (to get
rid of the large download).

I suppose one option would be to change all the SQL stuff to Access but then
we would have to change the stored procs to queries and I'm not sure what
differences there are with this.

Any ideas how others have solved this MSDE download issue? What about moving
everything to Access? Any speculation on how difficult this would be?

Oh, BTW, yes, we explained to the marketing folks many many times about the
size of the download even before we started coding :-)

Norton

Re: MSDE to Access? Mike Epprecht (SQL MVP)
11/22/2004 7:01:13 AM
Hi

MSDE2000a is only 43Mb
(http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=413
744d1-a0bc-479f-bafa-e4b278eb9147#filelist)

If you ship the product on CD, include it there, else, you don't have much
choice but for the customer to download it.

If you use Views or SP's in your project, backporting it to Access will be a
major amount of work, so in effect you will have 2 code bases.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]

Re: MSDE to Access? TheNortonZ
11/22/2004 11:19:33 AM
Mike,

Thanks for pointing me to this link!

What is interesting is, that is says that if this is a new install, use the
43mb install, however, if it is an upgrade, it points you to them SQL2000
desktop SP3 install which is 70MB. Does that make any sense at all as to why
the upgrade would be almost double in size?

Norton
[quoted text, click to view]

Re: MSDE to Access? Andrew D. Newbould
11/26/2004 9:11:50 PM
In message <eYkhgkE0EHA.3908@TK2MSFTNGP10.phx.gbl>, TheNortonZ
<thenortonz@hotmail.com> writes
[quoted text, click to view]

There are in fact two downloads available from Microsoft:

MSDE 2000 Runs in at 43 Mb
MSDE 2000 + SP3 Runs in at 70 Mb

Don't figure ?

Anyway, you could include the smaller distribution package and save you
potential users 30Mb of download (not a bad saving for no real effort -
just don't tell marketing how you did it :-> ).

Another alternative would be to make two downloads available. The first
as current with 43Mb MSDE files. The second without MSDE for those users
who already have MSDE or SQL Server installed on their LAN (obviously
means your potential users have to have an ounce of common sense). This
second option would possibly require you to provide a separate database
setup utility within the package to create you DB, tables, views and
sprocs in a user defined place (still less work than re-writing for
Access).

Do you REALLY want to re-code your application for Access !!!

Kind Regards,
--
Andrew D. Newbould E-Mail: newsgroups@NOSPAMzadsoft.com

AddThis Social Bookmark Button