Re: access as frontend to backend sql 2000

Tom,

Some background: I have an backend mdb that contains just over 560MB. Since it continues to grow as new features are added and even more data is inserted, I've started to think about going to something that has more capacity. I understand that a backend's max capacity is 2GB and that MSDE's is also. So I was thinking about going to SQL Server 2005 Express (4GB) with both Access 2002 and Access 2003 being used by the users for frontends.

As I've been following some of the newsgroup comments, I've found the options/suggestions confusing. I'd like to expand my question. Do you find that you need other tools besides ADE and SQL DE for such an environment?

I should mention that this is my first database and I just happened to do one that has become very popular with this organization. So, I'm on a steep learning curve to keep up with it. Hence my desire to get some good input. Thanks.

Al Williams


Tom Ellison wrote:
Al Williams:

Access Developer Edition (ADE) includes a license to distribute MSDE and Access run-time applications to clients without any special license. It includes tools to create run-time.

SQL Server Developer Edition (SQL DE) includess development tools, especially Enterprise Manager and Query Analyzer (EM and QA) that are indispensable. "Don't leave home without it!" (TM) class of benefits! Improves productivity working with MSDE, and online help you cannot get along without.

Wow! That endorsement reads like some kind of commercial.

If you don't need distribution to clients without Access installed, then ADE is optional. If you are going to develop MSDE applications SQL DE is not optional. It is very inexpensive. It pays for itself in less than a week.

Tom Ellison

[snip]

Hi Tom,

I would appreciate an explanation of how you use Access Developer Edition and SQL Server Developer Edition. Will your approach work with SQL Server 2005 Express? Thanks.

Al Williams

[snip]
.

Relevant Pages

  • Re: access as frontend to backend sql 2000
    ... Tom Ellison wrote: ... The ADE is the product that gives you the license to deploy the 2003 runtime components and you have to have Access 2003 installed in order to install the ADE. ... then I recommend you just purchase ADE by itself and SQL Server Developer Edition. ... Access Developer Edition includes a license to distribute MSDE and Access run-time applications to clients without any special license. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: access as frontend to backend sql 2000
    ... Or is that what you meant by getting MSDN Universal - includes ADE? ... You can set up an "imitation" of the entire deployment you plan, with different OS platforms and different versions of other software. ... You might also look at Windows Small Business Server bundled with SQL Server. ... SQL Server Developer Edition includess development tools, especially Enterprise Manager and Query Analyzer that are indispensable. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: access as frontend to backend sql 2000
    ... You can buy ADE separately, but without Access it would do you little good. ... Testing deployment can be a major part of a complete project. ... SQL Server Express may be just the thing for you. ... SQL Server Developer Edition includess development tools, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL SERVER 6.5 on XP Home
    ... that MSDE comes with an environment for developing stored procedures? ... I'm leaning toward the use of SQL SERVER ... 2000 Developer Edition at this point. ...
    (microsoft.public.sqlserver.setup)
  • Re: Can I Upgrade
    ... Developer Edition of SQL Server can not be used as a production server. ... technically you can (even though I don't really remember technically if you can upgrade from MSDE 2000 to Developer Edition 2000); however it's against the license agreement. ... And here I'm making a list from start to end to install and configure MSDE for remote connections: ...
    (microsoft.public.sqlserver.setup)
Loading