NeoDBPro suddenly not compacting Access DB file.
Quote from mark Lonardo on August 30, 2021, 4:14 pmMy version v18.10.10 - Advanced Database plug-in for VisualNeo.
All database functions working good and so was Access db compaction, but then it suddenly stopped working.
I have tried compacting before opening the database and after closing the database. I have explicitly and implicitly set the path to the file. there is no error generated.
App > Startup
" .GoSub "Installation Setup"
+ GoSub "OpenConnectionsstart"Subroutines > OpenConnectionsstart
+ fmConnectLocal "localhost" "InitialPath=c:\"
+ Return
+ GoSub "OpenDatabseMaintenance"Subroutines > OpenDatabseMaintenance
+ dbpCompactAccessDatabase "C:\Program Files (x86)\DocGuiS\ddb\docdb.mdb" "Password=password;Encrypted=No"
+ dbpOpenAccessDatabase "DocDB" "C:\Program Files (x86)\DocGuiS\ddb\docdb.mdb" "Password=password"+ Return
" .GoSub "ModifyAdobeonStart"
" ...
" ..
" .GoSub "ResizeBarsToPdf"
My version v18.10.10 - Advanced Database plug-in for VisualNeo.
All database functions working good and so was Access db compaction, but then it suddenly stopped working.
I have tried compacting before opening the database and after closing the database. I have explicitly and implicitly set the path to the file. there is no error generated.
App > Startup
" .GoSub "Installation Setup"
+ GoSub "OpenConnectionsstart"
Subroutines > OpenConnectionsstart
+ fmConnectLocal "localhost" "InitialPath=c:\"
+ Return
+ GoSub "OpenDatabseMaintenance"
Subroutines > OpenDatabseMaintenance
+ dbpCompactAccessDatabase "C:\Program Files (x86)\DocGuiS\ddb\docdb.mdb" "Password=password;Encrypted=No"
+ dbpOpenAccessDatabase "DocDB" "C:\Program Files (x86)\DocGuiS\ddb\docdb.mdb" "Password=password"
+ Return
" .GoSub "ModifyAdobeonStart"
" ...
" ..
" .GoSub "ResizeBarsToPdf"
Quote from HPW on August 30, 2021, 6:00 pmHello,
With which VisualNeoWin version do you use the plugin?
Did you change anything related to the MS database drivers?
Regards
Hans-Peter
Hello,
With which VisualNeoWin version do you use the plugin?
Did you change anything related to the MS database drivers?
Regards
Hans-Peter
Quote from mark Lonardo on August 30, 2021, 6:45 pmI am using a release from July 2021 and also tried 21.8.10.
I also reinstalled the db plugins and regenerated the MDB file fresh. I compiled an executable and ran as administrator. I added database entrys then deleted some using dbpDeleteRecord . All database functionality is good but it will not compact the MDB to remove deleted database entries. There are no errors generated when it runs ...is there some way to retrieve the status of the compact function via a variable or error trap?
I am going to view the MDB file in access to see if they match.
I am using a release from July 2021 and also tried 21.8.10.
I also reinstalled the db plugins and regenerated the MDB file fresh. I compiled an executable and ran as administrator. I added database entrys then deleted some using dbpDeleteRecord . All database functionality is good but it will not compact the MDB to remove deleted database entries. There are no errors generated when it runs ...is there some way to retrieve the status of the compact function via a variable or error trap?
I am going to view the MDB file in access to see if they match.
Quote from HPW on August 30, 2021, 8:54 pmHello,
I am not an expert for the DbPro plugin, but from your description I would guess that something in the access driver must have changed. Since your plugin did not change, this seems logical to me. Maybe someone can help.
Regards
Hans-Peter
Hello,
I am not an expert for the DbPro plugin, but from your description I would guess that something in the access driver must have changed. Since your plugin did not change, this seems logical to me. Maybe someone can help.
Regards
Hans-Peter