MSDE and Access Project Issue

I installed MSDE SP3a on my XP Pro laptop using the following options:
SAPWD=abc456
instancename=MSDE01
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
DATADIR="C:\MSDE"
TARGETDIR="C:\MSDE"
I went to services and started MSSQL$MSDE01 and SQLAgent$MSDE01.
I opened up MSACCESS 2003 and created a new project with new data. The SQL Server Database Wizard popped up and I entered (local)MSDE01 for the SQL server and clicked the Use Trusted Connection.
After several seconds, I receive an error message:
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied.
I can connect to this instance of MSDE using ASP.NET and the Server Explorer. So I'm pretty sure that I have a good install of MSDE.
Does anyone have a clue as to what I am doing wrong when I try to connect via Access?
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Hi,
Try (local)\MSDE01 instead.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uv46MJeIEHA.3968@.TK2MSFTNGP12.phx.gbl...
> I installed MSDE SP3a on my XP Pro laptop using the following options:
> SAPWD=abc456
> instancename=MSDE01
> DISABLENETWORKPROTOCOLS=0
> SECURITYMODE=SQL
> DATADIR="C:\MSDE"
> TARGETDIR="C:\MSDE"
> I went to services and started MSSQL$MSDE01 and SQLAgent$MSDE01.
> I opened up MSACCESS 2003 and created a new project with new data. The
SQL Server Database Wizard popped up and I entered (local)MSDE01 for the SQL
server and clicked the Use Trusted Connection.
> After several seconds, I receive an error message:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 53
> [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen(Connect()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 17
> [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or
access denied.
> I can connect to this instance of MSDE using ASP.NET and the Server
Explorer. So I'm pretty sure that I have a good install of MSDE.
> Does anyone have a clue as to what I am doing wrong when I try to connect
via Access?
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
|||or .\MSDE01
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uv46MJeIEHA.3968@.TK2MSFTNGP12.phx.gbl...
> I installed MSDE SP3a on my XP Pro laptop using the following options:
> SAPWD=abc456
> instancename=MSDE01
> DISABLENETWORKPROTOCOLS=0
> SECURITYMODE=SQL
> DATADIR="C:\MSDE"
> TARGETDIR="C:\MSDE"
> I went to services and started MSSQL$MSDE01 and SQLAgent$MSDE01.
> I opened up MSACCESS 2003 and created a new project with new data. The
SQL Server Database Wizard popped up and I entered (local)MSDE01 for the SQL
server and clicked the Use Trusted Connection.
> After several seconds, I receive an error message:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 53
> [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen(Connect()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 17
> [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or
access denied.
> I can connect to this instance of MSDE using ASP.NET and the Server
Explorer. So I'm pretty sure that I have a good install of MSDE.
> Does anyone have a clue as to what I am doing wrong when I try to connect
via Access?
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.

MSDE and Access 2000

Hi everyone,

In using the SQL Server Database Wizard in Access 2000 to create a new
access project, I get two consecutive error messages and then the wizard
shuts down. The first, which apprears immediately after starting the wizard
is a message box stating something like "the property value is too large".
After clicking through and filling out the values in the connection and
database dialog, I get a second dialog box with the message "Overflow" and
the wizard terminates.

My operating system is Windows 2000 Professional with Access 2000 and MSDE
2000.

Does anyone have any thoughts about what might be causing these errors?

Thanks in advance.Hi Stephen

Have a look at Microsoft Knowledge Base Article Q272384
http://support.microsoft.com/defaul...kb;EN-US;272384

It describes the overflow error when creating a MS Access project on MSDE
2000.
Apparently, installing MS Office Service Pack 3 should fix the problem.

Hope this helps!

Martin

"Stephen Bishop" <sbishop33@.comcast.net> wrote in message
news:5KednfNSnerNM-vdRVn-tw@.comcast.com...
> Hi everyone,
> In using the SQL Server Database Wizard in Access 2000 to create a new
> access project, I get two consecutive error messages and then the wizard
> shuts down. The first, which apprears immediately after starting the
wizard
> is a message box stating something like "the property value is too large".
> After clicking through and filling out the values in the connection and
> database dialog, I get a second dialog box with the message "Overflow" and
> the wizard terminates.
> My operating system is Windows 2000 Professional with Access 2000 and MSDE
> 2000.
> Does anyone have any thoughts about what might be causing these errors?
> Thanks in advance.|||Thanks, Martin. I'll take a look at the article and see if it helps. As
far as the office version, I'm using Access 2000 (9.0.2720) and Office
2000, but I don't know the service pack status.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||Open Access -> Help -> About Microsoft Access

At the end of first line it should say e.g. SP-1, SP-2 etc depending
on what service pack is installed.

Stephen Bishop <sbishop33@.comcast.net> wrote in message news:<40784f48$0$206$75868355@.news.frii.net>...
> Thanks, Martin. I'll take a look at the article and see if it helps. As
> far as the office version, I'm using Access 2000 (9.0.2720) and Office
> 2000, but I don't know the service pack status.

MSDE 2005 encryption

I have been given my first database project that requires data encryption.
[We'll be storing SSN's, CCN's, etc.] I have SQL Server 2000 and MSDE 2
005
as my choice of databases. The project is small enough that MSDE would work
.
My question is does MSDE 2005 have the encryption capabilities of SQL Server
2005 and are those capabilities sufficient to meet Federal regulations for
data security?
Since the project is a small one, is MSDE 2005 a better choice than SQL
Server 2000 with a third party encryption tool, since the SQL Server 2000
that I'd use is hosted by my Hosting company on a shared SQL Server?
Thank you
--
Johnhi,
jhcope wrote:
> I have been given my first database project that requires data
> encryption. [We'll be storing SSN's, CCN's, etc.] I have SQL Server
> 2000 and MSDE 2005 as my choice of databases. The project is small
> enough that MSDE would work. My question is does MSDE 2005 have the
> encryption capabilities of SQL Server 2005 and are those capabilities
> sufficient to meet Federal regulations for data security?
SQLExpress supports the full set of encryption as the full SQL Server 2005
editions..

> Since the project is a small one, is MSDE 2005 a better choice than
> SQL Server 2000 with a third party encryption tool, since the SQL
> Server 2000 that I'd use is hosted by my Hosting company on a shared
> SQL Server?
...
unfortunately I'm not able to solve this dilemma...
your policies and/or standards should be evaluated... SQLExpress can be an
optimal solution, but lacks some features that could be required, such as
SQL Server Agent, Database Mail, DTS/SISS features and the like... or the
new Service Broker related features as well... you have to balance all your
requirements and the supported features...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply|||SQL Server Express does include Service Broker, but there are some licensing
limitations to its use.
Dan

> hi,
> jhcope wrote:
> SQLExpress supports the full set of encryption as the full SQL Server
> 2005 editions..
>
> ...
> unfortunately I'm not able to solve this dilemma...
> your policies and/or standards should be evaluated... SQLExpress can
> be an
> optimal solution, but lacks some features that could be required, such
> as
> SQL Server Agent, Database Mail, DTS/SISS features and the like... or
> the
> new Service Broker related features as well... you have to balance all
> your
> requirements and the supported features...|||hi Dan,
Dan Sullivan wrote:
> SQL Server Express does include Service Broker, but there are some
> licensing limitations to its use.
yes, the limitations make the Service Broker quite "useless" for inter-SQLX
scenarios as a full SQL Server licensed edition is normally required...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply

MSDE 2000 or SQL Server 2005 Express (Beta) for new project?

Hello guys! I have to develop a new web based project. It's a webportal for events. At the moment it's runnung on an Access database.The new version should be running on a SQL server - the desicion is:MSDE 2000 or SQL Server 2005 Express (Beta). What do you recommend? Thewebpages are developed under .NET 1.1.
SQL Server 2005 Express is not going to be as stable and is not aproven technology as is MSDE. But if your release date somewhatdistant (several months), you may want to use it (hopefully the RTMversion will be relased before you finish.) You'll still be anearly adopter, though, and may have to deal with bugs. In theend, it's a question of: What features do you need in Express that MSDEdoesn't provide? And do these features counter-balance the issuesof working with a beta?
|||Well ... it's a company philosophy to work always on the newsestplattform. If you are common with the MSDE and the SQL Express 2005edition you can surly say if there are some performance improvements.The project leaders think that the MSDE version is not so fast. Specialfeatures are not requested, only SQL querys and stored procedures (...and performance ). Is a change of database engine (from MSDEto SQL 2005) a problem in the future?
Thanks a lot!!!
|||

Here my first look at SQL Server 2005, an events web site needs Time Interval, it is built in SQL server 2005 and index Column include without Composite index. It also schreds and decomposes XML native. Hope this helps.

SQL SERVER 2005 Development

What is new for ASP.NET

The most important is CLR integration write your stored procedures in C#.NET and VB.NET.

INDEX COLUMN INCLUDE, NEW DRI(Declarative Referential Integrity) CASCADE DELETE SET NULL AND CASCADE UPDATE SET NULL, When used with Portal Templates allow the user to browse before login. This is almost like Denormalization with Composite index without the Primary Key restriction of NOT NULL. ANSI NULL enabling on index columns.

Varchar (max), Nvarchar(max) Varbinary(max) Variable length data that may exceed 8000 and 4000 with 2gig limit, in the past these are stored in Text and Image, SQL Server creates an

Arithmetic pointer to the data because it is not table row based.

DTS is now Integration Service with pipeline.

Service Broker can be used to Queue shipping data while SQL Server will process sales Transactions.

XML DATATYPE

XML native Datatypes including XML indexes and XML decomposition.

XML QUERY EXAMPLE using XML PATH

SELECT CustomerID as "@.CustomerID",

(SELECT OrderID as "@.OrderID"

FROM Orders

WHERE Orders.CustomerID = Customers.CustomerID

FOR XML PATH('Order'), TYPE),

(SELECT DISTINCT LastName as "@.LastName"

FROM Employees

JOIN Orders ON Orders.EmployeeID = Employees.EmployeeID

WHERE Customers.CustomerID = Orders.CustomerID

FOR XML PATH('Employee'), TYPE)

FROM Customers

FOR XML PATH('Customer')

COMMON TABLE EXPRESSIONS CTE VIRTIUAL VIEWS

VIEWS are Query Rewrites in ANSI SQL

ANSI SQL 99 with Recursive QUERY Implementation some restrictions.

Tables must be equal INNER JOIN

CONVERT clause can be used to meet the UNION operator requirement.

But multiple Recursive members can only be connected by UNION ALL not UNION because UNION removes duplicates just like SELECT DISTINCT .

Recursion Control

Default server wide - 100

Configurable maximum iterations

OPTION MAXRECURSION <value>

1-32767

Recursive Member Restrictions

No operations leading to DISTINCT

Only UNION ALL allowed between anchor and recursive

SELECT DISTINCT

GROUP BY

HAVING

Scalar Aggregation

TOP

Outer Joins

1 CTE reference per recursive member

The example below in the executing statement, the CTE is referenced twice; that is the reason for the OUTER JOIN, the OUTER JOIN is not allowed with Recursive CTE because in ANSI SQL OUTER JOIN has a default NULL condition and is limited to four iterations while a Recursive CTE can run to 100.

USE AdventureWorks;

GO

WITH Sales_CTE (SalesPersonID, NumberOfOrders, MaxDate)

AS

(

SELECT SalesPersonID, COUNT(*), MAX(OrderDate)

FROM Sales.SalesOrderHeader

GROUP BY SalesPersonID

)

SELECT E.EmployeeID, OS.NumberOfOrders, OS.MaxDate,

E.ManagerID, OM.NumberOfOrders, OM.MaxDate

FROM HumanResources.Employee AS E

JOIN Sales_CTE AS OS

ON E.EmployeeID = OS.SalesPersonID

LEFT OUTER JOIN Sales_CTE AS OM

ON E.ManagerID = OM.SalesPersonID

ORDER BY E.EmployeeID;

GO

Recursive CTE using CONVERT clause to satisfy the UNION ALL operator requirement.

USE AdventureWorks ;

Go

WITH DirectReports(Name, Title, EmployeeID, EmployeeLevel, Sort)

AS (SELECT CONVERT(Varchar(255), c.FirstName + ' ' + c.LastName),

e.Title,

e.EmployeeID,

1,

CONVERT(Varchar(255), c.FirstName + ' ' + c.LastName)

FROM HumanResources.Employee AS e

JOIN Person.Contact AS c ON e.ContactID = c.ContactID

WHERE e.ManagerID IS NULL

UNION ALL

SELECT CONVERT(Varchar(255), REPLICATE ('| ' , EmployeeLevel) +

c.FirstName + ' ' + c.LastName),

e.Title,

e.EmployeeID,

EmployeeLevel + 1,

CONVERT (Varchar(255), RTRIM(Sort) + '| ' + FirstName + ' ' +

LastName)

FROM HumanResources.Employee as e

JOIN Person.Contact AS c ON e.ContactID = c.ContactID

JOIN DirectReports AS d ON e.ManagerID = d.EmployeeID

)

SELECT EmployeeID, Name, Title, EmployeeLevel

FROM DirectReports

ORDER BY Sort ;

GO

The following example is using MAXRECURSION to cancel a statement.

USE AdventureWorks ;

GO

WITH DirectReports(ManagerID, EmployeeID, EmployeeLevel) AS

(

SELECT ManagerID, EmployeeID, 0 AS EmployeeLevel

FROM HumanResources.Employee

WHERE ManagerID IS NULL

UNION ALL

SELECT e.ManagerID, e.EmployeeID, EmployeeLevel + 1

FROM HumanResources.Employee e

INNER JOIN DirectReports d

ON e.ManagerID = d.EmployeeID

)

SELECT *

FROM DirectReports

OPTION (MAXRECURSION 4) ;

GO

First look at SQL Server 2005 development. Comments appreciated.

MSDE 2000

Hi, I have been working with SQL 2000. I recently have a small project to d
o
and it requires getting data from the Access database. I tried using the
Access as my database but found it very difficult to use, maybe it's becuase
I'm more used to SQL server. The customers mostly won't have SQL server so
I
thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
download center. One's title says MSDE for Visual Studio.net devloper (I us
e
C# for the application development), Publish date of 8/21/2003. The other
one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
Can someone tell me which one I should down load? Should I down load the
first one to my PC for development purpose and then the 2nd to the customer
pC ? Or should I just download the 2nd one which has the latest publish dat
e?
Thanks,
Alpha"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:0034163A-0ABE-44DA-BE3F-197C4371127C@.microsoft.com...
> Hi, I have been working with SQL 2000. I recently have a small project to
> do
> and it requires getting data from the Access database. I tried using the
> Access as my database but found it very difficult to use, maybe it's
> becuase
> I'm more used to SQL server. The customers mostly won't have SQL server
> so I
> thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
> download center. One's title says MSDE for Visual Studio.net devloper (I
> use
> C# for the application development), Publish date of 8/21/2003. The other
> one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
> Can someone tell me which one I should down load? Should I down load the
> first one to my PC for development purpose and then the 2nd to the
> customer
> pC ? Or should I just download the 2nd one which has the latest publish
> date?
>
MSDE 2000 relase A
David|||Thank you.
"David Browne" wrote:

> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:0034163A-0ABE-44DA-BE3F-197C4371127C@.microsoft.com...
> MSDE 2000 relase A
> David
>
>

MSDE 2000

Hi, I have been working with SQL 2000. I recently have a small project to do
and it requires getting data from the Access database. I tried using the
Access as my database but found it very difficult to use, maybe it's becuase
I'm more used to SQL server. The customers mostly won't have SQL server so I
thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
download center. One's title says MSDE for Visual Studio.net devloper (I use
C# for the application development), Publish date of 8/21/2003. The other
one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
Can someone tell me which one I should down load? Should I down load the
first one to my PC for development purpose and then the 2nd to the customer
pC ? Or should I just download the 2nd one which has the latest publish date?
Thanks,
Alpha
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:0034163A-0ABE-44DA-BE3F-197C4371127C@.microsoft.com...
> Hi, I have been working with SQL 2000. I recently have a small project to
> do
> and it requires getting data from the Access database. I tried using the
> Access as my database but found it very difficult to use, maybe it's
> becuase
> I'm more used to SQL server. The customers mostly won't have SQL server
> so I
> thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
> download center. One's title says MSDE for Visual Studio.net devloper (I
> use
> C# for the application development), Publish date of 8/21/2003. The other
> one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
> Can someone tell me which one I should down load? Should I down load the
> first one to my PC for development purpose and then the 2nd to the
> customer
> pC ? Or should I just download the 2nd one which has the latest publish
> date?
>
MSDE 2000 relase A
David
|||Thank you.
"David Browne" wrote:

> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:0034163A-0ABE-44DA-BE3F-197C4371127C@.microsoft.com...
> MSDE 2000 relase A
> David
>
>

MSDE 2000

Hi, I have been working with SQL 2000. I recently have a small project to do
and it requires getting data from the Access database. I tried using the
Access as my database but found it very difficult to use, maybe it's becuase
I'm more used to SQL server. The customers mostly won't have SQL server so I
thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
download center. One's title says MSDE for Visual Studio.net devloper (I use
C# for the application development), Publish date of 8/21/2003. The other
one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
Can someone tell me which one I should down load? Should I down load the
first one to my PC for development purpose and then the 2nd to the customer
pC ? Or should I just download the 2nd one which has the latest publish date?
Thanks,
Alpha"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:0034163A-0ABE-44DA-BE3F-197C4371127C@.microsoft.com...
> Hi, I have been working with SQL 2000. I recently have a small project to
> do
> and it requires getting data from the Access database. I tried using the
> Access as my database but found it very difficult to use, maybe it's
> becuase
> I'm more used to SQL server. The customers mostly won't have SQL server
> so I
> thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
> download center. One's title says MSDE for Visual Studio.net devloper (I
> use
> C# for the application development), Publish date of 8/21/2003. The other
> one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
> Can someone tell me which one I should down load? Should I down load the
> first one to my PC for development purpose and then the 2nd to the
> customer
> pC ? Or should I just download the 2nd one which has the latest publish
> date?
>
MSDE 2000 relase A
David|||Thank you.
"David Browne" wrote:
> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:0034163A-0ABE-44DA-BE3F-197C4371127C@.microsoft.com...
> > Hi, I have been working with SQL 2000. I recently have a small project to
> > do
> > and it requires getting data from the Access database. I tried using the
> > Access as my database but found it very difficult to use, maybe it's
> > becuase
> > I'm more used to SQL server. The customers mostly won't have SQL server
> > so I
> > thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
> > download center. One's title says MSDE for Visual Studio.net devloper (I
> > use
> > C# for the application development), Publish date of 8/21/2003. The other
> > one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
> >
> > Can someone tell me which one I should down load? Should I down load the
> > first one to my PC for development purpose and then the 2nd to the
> > customer
> > pC ? Or should I just download the 2nd one which has the latest publish
> > date?
> >
> MSDE 2000 relase A
> David
>
>sql

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 a
s a solution since "Office 2000 Professional/Standard Edition" installations 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 concurrent users is between 2 and 4 people.
Is it legal for me to write write an Access 2000/VBA front end, have it used by a few users with Access 2000 on their machines, and have MSDE 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?
I read that "Office 2000 Developer Edition" (which is not available to me) is needed in order to redistribute MSDE 1.0. I don't understand what "redistribute" means in this case. I also read that MSDE 1.0 can be used by any owner of an Office 2000 licen
se that includes it. The information I've read on various websites about the licensing is sometimes contradictory, and I don't understand the wording on Microsoft's site.
Somebody, please give me the benefit of your knowledge.
- Sinh
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Hi,
It IS legal for you to write an Access 2000/VBA front end, have it used by
a few users with Access 2000 on their machines (Provided they have ms
access), and have MSDE as the database server on a single machine without
paying for any further licenses and fees
You can download MSDE 2000 for free from the SQL Server Website and
redistribute it.
Download it from http://www.microsoft.com/sql/msde/do...s/download.asp
For redistribution rights, register for free @.
http://www.microsoft.com/sql/msde/ho...stregister.asp
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

MSDE 1.0 licensing

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 a
s a solution since "Office 2000 Professional/Standard Edition" installations 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 concurrent users is between 2 and 4 people.
Is it legal for me to write write an Access 2000/VBA front end, have it used by a few users with Access 2000 on their machines, and have MSDE 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?
I read that "Office 2000 Developer Edition" (which is not available to me) is needed in order to redistribute MSDE 1.0. I don't understand what "redistribute" means in this case. I also read that MSDE 1.0 can be used by any owner of an Office 2000 licen
se that includes it. The information I've read on various websites about the licensing is sometimes contradictory, and I don't understand the wording on Microsoft's site.
Somebody, please give me the benefit of your knowledge.
- Sinh
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
If you don't wish to get stuck with older technology, don't install MSDE
1.0. MSDE 2.0 is now "free" and is a significant upgrade from 1.0. It would
make a fine "server" for your 2 to 4 people.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23nnk9kfPEHA.3660@.TK2MSFTNGP11.phx.gbl...
> 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 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 concurrent users is between 2
and 4 people.
> Is it legal for me to write write an Access 2000/VBA front end, have it
used by a few users with Access 2000 on their machines, and have MSDE 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?
> I read that "Office 2000 Developer Edition" (which is not available to me)
is needed in order to redistribute MSDE 1.0. I don't understand what
"redistribute" means in this case. 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, and
I don't understand the wording on Microsoft's site.
> Somebody, please give me the benefit of your knowledge.
> - Sinh
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
sql