Will Access 97 run on Server 2003?

[sam]

We have an old app that is in based on Access 97.
We need to replace the server ASAP. Will Access 97 run on
Server 2003?
Thanks.

 

[suda45]

can

 

[david epsom dot com dot au]

NetBIOS and Windows file systems include native support
for the MSDOS database semantics used by Access/Jet.
There is no need to install Access 97 on the server,
only on the client workstations.

(david)

 

[Arvin Meyer]

Access is a file server/desktop database. Unless you are using Terminal
Services, Access does not run on the server. Therefore the server is
irrelevant. Make sure the database is split, with only the data tables file
being shared from the server. Have the rest (code, forms, reports, etc.) as
a separate file running on EACH workstation and linked to the data on the
server. To do otherwise is begging for corruption.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Tony Toews]

We have an old app that is in based on Access 97.
We need to replace the server ASAP. Will Access 97 run on
Server 2003?

Assuming you really mean place the backend MDB on the server and not
install A97 on the server consider the following.

If you start having corruptions as soon as you move to the new server
it's likely the OpLocks problem. Corrupt Microsoft Access MDB Causes
- OpLocks http://www.granite.ab.ca/access/corruption/causesoplocks.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm