Petr Danes
Registered User.
- Local time
- Tomorrow, 00:25
- Joined
- Aug 4, 2010
- Messages
- 150
I've crashed repeatedly on the following: when I issue an SQL command to empty a table, the command CurrentDB.TableDefs("tbl").RecordCount continues to show the count BEFORE the records were deleted. And they ARE deleted. Opening the table shows it empty, and functions like DCount give the proper count of zero. Only after a C&R does this syntax show the proper count. Does anyone know what is going on with this? Obviously something is cached somewhere, but what is the point of caching something as basic as a record count?