Techadvice.com

Main,
Tech Info,
Glossary,
Companies,
Hardware
.
Software.
Windows 95, 98, ME, XP,
NT4, 2000, Errors,
Applications
,
Search products ,
Search FAQs.
Shop
Companies,
Products
,


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

Problem:
When adding two tables to an access query, the table relationship is not established automatically.

Solution:
The second table field must be a long integer in order for the link to be established automatically during the generation of a query.

Tips

Switch Function -
The equivalent to "Select Case" in Access is the Switch function

Issues :

 


 

You are at the www.techadvice.com site which is not associated with the company or products shown on this page.
Contact Us,
Disclaimer
Advertisers
, ExoticRecipes
 

---