SQL Form Data Load - Access Developer Network


	Back to Access Developer Network Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

SQL Form Data Load

Halkawt Qadir

2 months ago

Hello everyone, may I ask what the fastest and easiest way is to load data into my form when my backend is in SQL Server? I want to read/write, plus I want to be able to apply filtering and sorting on my form as well. Currently, I use an embedded query with date Criteria to download data between two specific dates. It is fine, but not typical. I tried DAO by VBA, but I lost filtering & sorting capabilities. So I need your help, nice developers

	Alex Hedley @Reply 2 months ago
Locally or Remote? Access SQL Server Online

	Halkawt Qadir OP @Reply 2 months ago
Mr. Alex I mean, the loading data to my forms in front-end and Access SQL Server Online does not mention this part

	Alex Hedley @Reply 2 months ago
Have you got SQL Server setup? Have you connected it through Access yet?

	Halkawt Qadir OP @Reply 2 months ago
Mr Alex, Affirmative, we have connected our database to SQL Server, and we have been using it for 1 year so far, but as the data keeps growing, the forms are getting slower. That is why I want to know if there is any faster way than an embedded query to load data into my form. I will upload my embedded local access Query SQL for your review

	Halkawt Qadir OP @Reply 2 months ago

	Alex Hedley @Reply 2 months ago
Are you using a pass-thru query?

	Halkawt Qadir OP @Reply 2 months ago
Mr Alex Negative, as I mentioned, in need of Read/Write Form. this local access query

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Network.

Next Unseen

New Feature: Comment Live View