General discussion

Locked

How to install/use MSDE on a server/clie

By Bob Sellman ·
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.)

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

How to install/use MSDE on a server/clie

by guy In reply to How to install/use MSDE o ...

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).

Collapse -

How to install/use MSDE on a server/clie

by Bob Sellman In reply to How to install/use MSDE o ...

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.

Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums