Joy, this is something you brought up a long while ago but am finding myself faced with this problem today. It's been a nuisance since our conversion of the underlying tables to SQL (it slows the searches downn considerably); when the tables were naitive to Access it didn't present much of an...
What I've learned of most value in this post is the difference between DRI and Triggers. Information that I should've spent more time researching BEFORE I relinked our application to the converted SQL tables. I say that because as of this morning our Access front-end links to SQL and users...
I'm experiencing a similiar problem today. Over the weekend I converted our AccessXP to SQL2000 (43 tables some with a hanful of records and some over 300,000 records). If we open the "Customers" form, linked to the "Customers" table, it opens all the customer records (less than 5,000...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.