Access 2.0 | Applications |
General Information -
Microsoft Access 2.0 is a Microsoft Relational Database.
Problems and Solutions
Frequent lock-ups (system hangs)
MS-Access 2.0 can cause lots of problems on networked computers when the Jet 2.0 version database engine is used. This version can be upgraded by obtaining and installing the ACCSVC.exe file. This file updates the access 2.0 Jet Database query engine to the 2.5 version.
This upgrade also fixes problems with database lockups while on the network. Highly recommended.
Cannot Automatically Establish Table Relationship
Two tables have identical field names.
- The first table has a counter for a field
- The second has a number for a field
When adding two tables to an access query, the table relationship is not established automatically.
The second table field must be a long integer in order for the link to be established automatically during the generation of a query.
Switch Function -
The equivalent to "Select Case" in Access is the Switch function
|You are at the www.techadvice.com site which is not associated with the company or products shown on this page.|