Compacting clears a 3021 error - why?
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
- From: "Alex Barrow" <a@xxxxx>
- Date: Fri, 12 Sep 2008 19:14:37 GMT
Hi All,
I just need to try and understand why this happens?
In my databases will 10000k records, it has worked perfectly, then the
other day i started to get a vb 3021 error - no current record. not
changed anything in the database or programming.
As the database was big, i thought i would just do a compact on it, and
this cleared the error.
Any ideas why the error happens in the first place, and why the compact
clears it ?
Many Thanks !
.
Relevant Pages
- RE: Compacting MDB help
... The autoexec macro opens a ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ... I'm quite certain that you can't Compact an open database from within itself ...
(microsoft.public.access.modulesdaovba) - RE: Compacting MDB help
... This will cause the database to grow so Compacting ... not split off the tables from your FrontEnd. ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ...
(microsoft.public.access.modulesdaovba) - RE: Compacting MDB help
... not practical to have staffpersons open another database in order to switch ... When the front end opens, it goes directly to the main switchboard. ... the only reason why you would need to Compact the ...
(microsoft.public.access.modulesdaovba) - Re: Access crashes when opening form
... Allen Browne - Microsoft MVP. ... You were correct in suspecting SP3. ... I've also had a problem with "compact on close" not working (it ... database works correctly there. ...
(microsoft.public.access.forms) - Re: Compacting Backend Access Databases
... when I ran the procedure to compact ... use of the back-end database. ... Dim strBackendPathAndName As String ...
(microsoft.public.access.modulesdaovba) |
|
