Web Development·12,097 discussions

How to install/use MSDE on a server/clie

Locked

MSDE (supplied with Access 2000) comes with no instructions for set up and use on a client/server application environment. How should it be installed so the database engine runs on the server, but is called by various client workstations? How is the installation performed at the workstations. (I am working with a Netware server envirnoment.)

Topic

How to install/use MSDE on a server/clie

In reply to How to install/use MSDE on a server/clie

Technet article Q218812 should help you.
To install the MSDE, follow these steps:

1. Insert the Office 2000 CD number 1 into the CD-ROM or DVD-ROM drive.

2. In Windows Explorer, locate the following folder:

\SQL\x86\Setup

3. In the Setup folder, double-click the Setupsql.exe file.

The Microsoft Data Engine (MSDE) is a new technology that provides local data
storage that is compatible with Microsoft SQL Server 7.0. Because the MSDE
shares the same data engine as SQL Server, most Microsoft Access projects or
client/server applications run on either version unchanged.

NOTE: Unlike SQL Server 7.0, the MSDE has a 2-gigabyte database size limit,
doesn’t support Symmetrical Multiprocessing (SMP) on Windows 95 or later, and
when using Transactional replication, can’t be a replication publisher (although
it can act as a replication subscriber).

How to install/use MSDE on a server/clie

In reply to How to install/use MSDE on a server/clie

I am looking for information about installing so the database engine (MSDE) runs on the server (like MSSQL) and how to install so it runs on the server. As a part of this I need to know how/what to install on clients/workstations so they will use the MSDE located on the server.

[Author]

Replies