Onno
It sounds like you are approaching Access's limits. It might be time to start using SQL Server for your back end. You will be amazed at how much faster it is when compared to Access. SQL Server Express is free and should work just fine for you. This might be a bit of a learning curve for you, but it is well worth the effort. And there is also the bonus of SQL doing its own backups.
If you import directly into SQL you can use a scheduled job to to the work or fire it off manually from your Access application by calling a stored procedure. And your Access front end won't bloat the way it is now. You are right in thinking you cannot compact from the VBA procedure. You have to either run code from outside the database or do it manually.
Bill Mosca
__._,_.___
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar