CPGDeveloper
Board Regular
- Joined
- Oct 8, 2008
- Messages
- 190
So I created and administer an MS Access DB -- approximately 20 end users -- they each have an .accde FE on their desktops, while the back end sits on a network drive.
The primary data entry form has approximately 70+ fields, with currently 50k plus records. There is a subform on this form as well, showing multiple 'status' for each 'id' in the primary form. End users add new records, and search through the existing records, as well as occasionally making edits to the existing records.
Currently the form is bound to a query, based on a table sitting on the back end. I maintain a persistent connection when the application opens, and currently performance is fine. I'm wondering, however, as this application grows, and in a few months when we have 100k records, how it will start to behave.
Should I consider creating an unbound form instead? I'm not sure how that would work in this scenario -- any ideas or direction would be greatly appreciated. Thanks.
The primary data entry form has approximately 70+ fields, with currently 50k plus records. There is a subform on this form as well, showing multiple 'status' for each 'id' in the primary form. End users add new records, and search through the existing records, as well as occasionally making edits to the existing records.
Currently the form is bound to a query, based on a table sitting on the back end. I maintain a persistent connection when the application opens, and currently performance is fine. I'm wondering, however, as this application grows, and in a few months when we have 100k records, how it will start to behave.
Should I consider creating an unbound form instead? I'm not sure how that would work in this scenario -- any ideas or direction would be greatly appreciated. Thanks.