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

hi Wes,

" But if it still brings back 40k records, how can users easily locate the one record they want to edit?"

bringing back that many records to the desktop will result in slow performance. Better would be to do as Duane suggested to show the records that are possible to edit using a pass-through query -- and then a command button or some other way to trigger a particular record to be edited.

I'm making this reply using the web interface to see if I can find the "small icon that looks like a speech bubble" that Duane mentioned to include past messages. So far, I don't see anything ... maybe it depends on the browser or application being used to view messages ...

kind regards,
crystal

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

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

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

_._,_._,_