Bound vs. UnBound Forms

CPGDeveloper

Board Regular
Joined
Oct 8, 2008
Messages
157
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.
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Micron

Well-known Member
Joined
Jun 3, 2015
Messages
2,058
Office Version
  1. 365
Platform
  1. Windows
Unless you have a pressing reason to use unbound forms for data, I would not. I see no performance gain; in fact, given that everything would have to be handled by code you'll likely introduce issues that you don't currently have. Validation would be one of them. Then there is the fact that Access optimizes queries, often resulting in better performance than what you would experience if it did not. AFAIK, vba written sql is not optimized. For 20 users of a split Access db (where each user has their own FE) and especially since you mention that subforms are involved that just makes unbound relationships more of a problem.
 
Last edited:

CPGDeveloper

Board Regular
Joined
Oct 8, 2008
Messages
157
Thanks For that Perspective -- Unbound Forms seems like far more trouble than it's worth.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,616
Messages
5,625,876
Members
416,141
Latest member
Bartek9q

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top