I checked the Access Forever page for bugs causing slow-ness. I didn't really find anything.
I copied the database from the network folder and pasted to my desktop. Tried running it from there. No noticeable speed difference. I also am still getting the same error when trying to compact and...
I decompiled with no errors.
I recompiled with no errors
After clicking compact and repair, it hangs for 30 seconds, then I get an error saying "Could not use 'database.accdb', file already in use"
This is not possible because this db is a copy of a different db that no one else in is using...
Yes, there is a version checker that runs immediately and triggers an auto update if the version numbers don't match.
Yes, I have a default printer on my machine.
Why would those things cause a 64 bit version of the db to run poorly compared to the 32 bit version?
Yes, the application is split. I made a copy of the front end. I have gone through and either corrected all errors, or commented out code with errors that were on forms no longer used.
The database is still taking approximately the same amount of time to load.
No. There are several modules that are very, very old, built long before I started. I have avoided correcting errors to the old sections because the program has usually run well. In the past, when I have tried correcting old code, it tends to break the rest of the program.
For example, the...
Currently I have users that are using Microsoft Office versions 2013 - 2021. All are 32 bit because our ancient access database requires 32 bit.
Now, I am migrating all users to Microsoft Business 365; so I need to convert the database to 64 bit. I updated all the Declare statements to include...
Other databases appear to be working fine.
I'm having reports from users saying the errors they were encountering have gone away. But I haven't changed anything.
I tried compact and repair on my copy. Some issues went away, but I'm still having lock error messages all over.
There are multiple users in the database every day. I have my own dev/test version that I use. The problem is happening on both my version and the live version. I even went to...
I have not made an update to my database since 7/24. However, I do see that there was a Windows Update between Friday and today.
Forms that have been working fine for years are suddenly breaking at random places. Often it happens when a field has a drop down with a selection that resides in...
Okay, I made a new module in a new database and copied both functions to it. Then I made a new button on one of the forms calling the Test function. After clicking the button, I got no errors, but I got no message either showing the results of the list of controls.
I do not have this code in a module. For testing, I have the code in the VBA of the form (QuoteFrm01).
When I have tried compiling in the past, the database usually locks up. Likely this is due to its age and size.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.