Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Password Reminder
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old May 20th, 2004, 01:46 AM
Registered User
Join Date: May 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default MSDE 1.0 licensing confusion

Hi all. I'm working on my first database project. I could use someone's knowledge and help on the specifics of using MSDE 1.0 legally. I've been reading up on this subject extensively, and I still can't figure out a clear answer.

I volunteer at a hospital and am writing a patient/physical therapist appointment scheduling program for a department. The department doesn't want to spend anything in terms of licensing for this project. I'm thinking of using Access 2000 and MSDE 1.0 as a solution since "Office 2000 Professional/Standard Edition" installations (Access 2000 and MSDE 1.0 are on the installation CD's) are already available on a few machines in the department and I don't want to get stuck with an older technology like Jet and/or DAO (want this program to be scalable in case SQL Server is an option in the future). Estimated number of concurrent users is between 2 and 4 people.

Is it legal for me to write an Access 2000/VBA front end, have it used by users with Access 2000 on their machines, and have MSDE 1.0 as the database server on a single machine without paying for any further licenses and fees? Or am I stuck using Jet if I want a free solution? What other restrictions/rules are there, ie. is there a limit on the number of users, does Access 2000 need to be installed on the machine with MSDE 1.0 as well, can the same scenario be done with MSDE 2000 instead of MSDE 1.0, etc.?

I read that "Office 2000 Developer Edition" (which is not available to me) is needed in order to redistribute MSDE 1.0. Does the database project I'm proposing qualify as redistributing (I do not have a good definition of this term)? I also read that MSDE 1.0 can be used by any owner of an Office 2000 license that includes it. The information I've read on various websites about the licensing is sometimes contradictory (about how "free" MSDE is), and I don't understand the wording on Microsoft's site.

Somebody, please give me the benefit of your knowledge.

- Sinh
Reply With Quote
  #2 (permalink)  
Old May 20th, 2004, 09:43 PM
sal sal is offline
Friend of Wrox
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts

MSDE comes with office. If you have an office license, you can use MSDE. You do not need to own Office Developer to re-distribute MSDE based databases. In fact, you can download a free tool from MS called "SQL Web Data Administrator" or something very close to that. This allows you to manage your MSDE databases as well as full blown SQL Server databases.

MSDE is really free, but it limits you to 5 concurrent users after that it slows down. It also limits the size of the database to 2GB. It has full SQL Server functionality, but lacks the front end for administration.

Download the tool i just mentioned for administering the database, and make it available to users whe you re-distribute.

Reply With Quote
  #3 (permalink)  
Old January 18th, 2005, 01:53 AM
Registered User
Join Date: Jan 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts

Hello Experts,

I am very new to any database application development. I am trying to create a solution using MS-Access 2000, which I recently bought. Now if I create a solution using my Access 2000 license and MFC, and want to 'sell' it to my clients, then:
- Do they require having MS-Access installed on their system?
- Do they require MS-Access db license?

Any comments/suggestions are welcome! :)

Many Thanks for reading,

Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Licensing SQLScott SQL Server 2005 2 October 12th, 2006 12:03 PM
Licensing in Windows Apps ashu_from_india General .NET 0 January 29th, 2006 08:00 AM
Licensing Issues lucid Oracle 3 April 20th, 2004 08:25 PM
Licensing problem Nicky VS.NET 2002/2003 1 June 5th, 2003 11:13 PM
Licensing problem Nicky C# 0 June 4th, 2003 12:51 AM

All times are GMT -4. The time now is 05:14 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.