Saphirah
Active member
- Local time
- Today, 05:17
- Joined
- Apr 5, 2020
- Messages
- 163
Hello everyone, i am currently developing an access application for a small company.
We are close to finishing the project and the database has quite the size. I am the only developer so i have full control over the whole application.
We split our database into a frontend and a backend, and i am providing the frontend as a "ACCDE" file, so the users can not edit the application at all.
Recently there were quite a lot of errors i have not encountered before, and that should not exist, knowing the logic of my code and forms.
For example we have a table showing all the current assignments.
Yesterday the continous form changed to a single form on one computer, but stayed the same on others. The user was therefore not able to access his current assignments.
Another thing that happened was queries disappearing on single machines. One user updated to the latest version (by drag and dropping the file) and worked for half a day when suddenly a query disappeared and threw an error.
Due to the file being "ACCDE" i can exclude user-fault, because they simply can not edit the frontend.
I am running "Compact and Repair" quite often, i am always compiling my code before distribution.
Did anyone else experience this behaviour? Is there a fix to this?
Thank you very much for your help...
We are close to finishing the project and the database has quite the size. I am the only developer so i have full control over the whole application.
We split our database into a frontend and a backend, and i am providing the frontend as a "ACCDE" file, so the users can not edit the application at all.
Recently there were quite a lot of errors i have not encountered before, and that should not exist, knowing the logic of my code and forms.
For example we have a table showing all the current assignments.
Yesterday the continous form changed to a single form on one computer, but stayed the same on others. The user was therefore not able to access his current assignments.
Another thing that happened was queries disappearing on single machines. One user updated to the latest version (by drag and dropping the file) and worked for half a day when suddenly a query disappeared and threw an error.
Due to the file being "ACCDE" i can exclude user-fault, because they simply can not edit the frontend.
I am running "Compact and Repair" quite often, i am always compiling my code before distribution.
Did anyone else experience this behaviour? Is there a fix to this?
Thank you very much for your help...