Re: [MSAccessProfessionals] Search records slow, Access 2010 front end, SQL Server 2019 back end

Thanks very much, Duane!  You meant I should add a list screen to display the records and let user choose one for editing.  But if it still brings back 40k records, how can users easily locate the one record they want to edit?

BTW.  I accidentally made 2 topics here, is there anyway to merge them?

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115626) | Reply To Group | Reply To Sender | Mute This Topic | New Topic

Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_