Re: There's a new Borland Delphi directions survey up
From: Dennis Landi ([none][at][none][dot][com])
Date: 03/26/04
- Next message: Craig Stuntz [TeamB]: "Re: Heavy weight companies and Linux."
- Previous message: Dave Nottage: "Re: Heavy weight companies and Linux."
- In reply to: Jeffrey Miller: "Re: There's a new Borland Delphi directions survey up"
- Next in thread: Serge Dosyukov \(Dragon Soft\): "Re: There's a new Borland Delphi directions survey up"
- Reply: Serge Dosyukov \(Dragon Soft\): "Re: There's a new Borland Delphi directions survey up"
- Reply: Jeffrey Miller: "Re: There's a new Borland Delphi directions survey up"
- Reply: David Clegg: "Re: There's a new Borland Delphi directions survey up"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 26 Mar 2004 15:22:47 -0500
"Jeffrey Miller" <jeffmillerSPAMNOT@advancedcomputerware.com> wrote in
message news:40648f27$1@newsgroups.borland.com...
> "Dennis Landi" <[none][at][none][dot][com]> wrote in message
> news:406487aa@newsgroups.borland.com...
> > ??? MSDE is essentially an API shared by Access and SQL Server. So if
you
>
> I dont think this is correct. IIR, MSDE is SQL server without the
utilities
> and a performance *governer*. The heart of Access the Jet Engine <> MSDE
>
>
There is an alternative to the Jet Engine when using Access and its Called
MSDE...
Choosing and Using MSDE 2000 as the Database Engine for Your Application
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msderoadmap.asp
<quote>
Use Microsoft Access With MSDE 2000
The Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is an alternative
to Microsoft Jet for data storage and data management. You can think of MSDE
2000 as a client/server alternative to the Microsoft Jet file server
database engine in Microsoft Access 2002 which enables software developers
to embed data storage within their custom applications. For more information
on using Microsoft Access 2002 with MSDE 2000 databases, please refer to the
technical article Using Microsoft Access 2002 with MSDE 2000, which
discusses creating and deploying an Access 2002 Project and MSDE 2000
Database.
The Microsoft Access Upsizing Wizard
The Upsizing Wizard is an add-on tool that can greatly simplify moving an
Access database into the SQL Server environment. It is available from a
variety of sources, including Microsoft Office 2000 or later and the
Microsoft Developer Network. For an introduction to and demonstration of
using the Microsoft Access Upsizing Wizard as well as information on what to
check prior to upsizing, design considerations, suggested troubleshooting
techniques for common upsizing issues and additional resources for
information, please refer to Q325017 How to Use the Microsoft Access
Upsizing Wizard.
Upsizing an Access 97 Database to MSDE 2000
The recommended manner in which to upsize an Access 97 database to MSDE2000
is to use Access 2002 to load your mdb file and then use the Access 2002
Upsizing Wizard to migrate to MSDE 2000.
Using Access Data Projects With MSDE 2000
With the release of Microsoft Access 2000, an exciting new technology has
been introduced: Access projects (.adp files), which allow you to develop
true client/server applications from within the Access environment. Creating
these project files differs from the traditional file-server development
that Access developers have typically used, such as developing a database
application with the Microsoft Jet database engine and saving all the
database objects in a single .mdb file. Like an .mdb file, an Access project
file also allows you to develop a database application in the Access
environment, but instead of using Jet, you're natively using either
Microsoft SQL Server or the new SQL Server 2000 Desktop Engine (MSDE 2000)
as the back-end database. For more information on Access Projects (ADP's),
refer to the following
MSDN and Knowledge Base articles:
Introduction to Microsoft Access 2000 Projects and the MSDE 2000
This document lists the best sources of detailed information about
Microsoft® Access projects (.adp files), which allow you to develop
client/server database applications in Access by using either Microsoft SQL
ServerĂ,ÂT or Microsoft Data Engine (MSDE) as the back-end database.
Developing Client/Server Solutions with Microsoft Access 2000 Projects
This document provides an introduction to Developing Client/Server Solutions
with Access 2000 Projects, an online book that explains in detail how to
create and work with Microsoft Access project (.adp) files.
Q308312: How to Use Application Roles with Access Projects and the SQL
Server 2000 Desktop Engine (MSDE 2000)
This article explains the capabilities, limitations and workarounds for
using Microsoft SQL Server Application roles in a Microsoft Access project.
Q299297: How to Deploy an ADP That Includes the MSDE 2000
This article provides the code that you must use to find the server, to
start the server if it is not started already, to attach the database to the
server, and to connect the project to the newly attached database. The code
is specific to use in a project. However, much of the code can be used by
any Visual Basic for Applications (VBA) application.
For additional reference material on Microsoft Access Data Projects, please
refer to the book Microsoft Access Projects with Microsoft SQL Server, which
can be obtained from Microsoft Press.
</quote>
- Next message: Craig Stuntz [TeamB]: "Re: Heavy weight companies and Linux."
- Previous message: Dave Nottage: "Re: Heavy weight companies and Linux."
- In reply to: Jeffrey Miller: "Re: There's a new Borland Delphi directions survey up"
- Next in thread: Serge Dosyukov \(Dragon Soft\): "Re: There's a new Borland Delphi directions survey up"
- Reply: Serge Dosyukov \(Dragon Soft\): "Re: There's a new Borland Delphi directions survey up"
- Reply: Jeffrey Miller: "Re: There's a new Borland Delphi directions survey up"
- Reply: David Clegg: "Re: There's a new Borland Delphi directions survey up"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
