I just read an earlier post on this subject and Hans suggested to delete fields one by one. However, I can't even open the form in form view or design view.
It's suppose to be a simple database with only 3 tables and the bother it is giving me !!
Is the best option just to start again ??
Results 1 to 2 of 2
Thread: Mismatch of expression (2000)
-
2 Star Lounger
- Join Date
- Feb 2002
- Location
- Taranaki, New Zealand
- Posts
- 179
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2006-06-16 02:45Mismatch of expression (2000)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Plutonium Lounger
- Join Date
- Mar 2002
- Posts
- 84,353
- Thanks
- 0
- Thanked 10 Times in 10 Posts
2006-06-16 05:15Re: Mismatch of expression (2000)
If you cannot open a form, your database is probably corrupt. Depending on hpw much you have changed since the last backup, you can:
- go back to a non-corrupt backup and take it from there, or
- create a blank new database and import all database objects (tables, queries, forms, ...) except the corrupt form from the problem database into the new one. then either import the form from a non-corrupt backup or create it anew.
