| Title: | MSACCESS |
| Moderator: | BUMP::HONER |
| Created: | Tue Dec 01 1992 |
| Last Modified: | Mon Jun 02 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1661 |
| Total number of notes: | 6339 |
I've a very strange problem that has me stumped. All querydefs that use string functions (Instr, Mid, Left etc) now refuse to compile in my Access (V7) database. Repairing the database doesn't help. Creating a blank database and importing all the tables/queries into it doesn't help. Looks like a VBA installation problem, I thought. However I've another (older) database with the same queries in it that seems to be working without any problems. Whats going on here? Any ideas? Dave
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 1631.1 | Mystery solved | XSTACY::PATTISON | A rolling stone gets the worm | Fri Feb 07 1997 06:18 | 15 |
Ok, I've found the answer I'll explain in case anyone else has this problem. Unknown to me there was some Access Basic in the database, in a module with compilation errors. For some odd reason, if you have any VBA code with errors, no queries that call VBA functions will execute (in the Access environment). However if you are using the Querydefs from Visual Basic, as I normally do they all work. Dave | |||||
| 1631.2 | In case new conversions are in order... | NSIC00::KLERK | Thunderbirds are Go | Fri Feb 07 1997 11:44 | 15 |
The Access 95 conversion process strongly suggests that one:
1. Open all forms and modules
2. Compile all
3. Compact database
4. Make a copy (so nothing is lost if something goes wrong now...)
5. Convert copy Database
6. Compact new database again
This should reasonably give you a proper working database. However, if
the Access 2 database has used names that for Access 95 are reserved words,
then you would still find problems during conversion.
Theo
| |||||