Access and SQL Server/Azure SQL Database (1 Viewer)

ekje

Registered User.
Local time
Today, 06:03
Joined
Jan 8, 2014
Messages
34
Hi,

I have developed small Access applications for a long time.
But today cloud-based databases are becoming more common and useful.
One alternative is to begin to develop Azure SQL Database applications.
The current Access applications would be front-ends.
What is the best way to study how to develop Azure SQL Database applications?
What tutorial courses are suitable?
Thank you for your replies!
 

strive4peace

AWF VIP
Local time
Today, 08:03
Joined
Apr 3, 2020
Messages
1,003
hi @ekje

most important to remember is that, because data takes time to bring down, only bring down what you need. On forms, RecordSource should be limited to show record you want to edit.

For populating RowSources, use pass-through queries

It took about a week to build an Access app -- then another MONTH to make it fast enough for the back-end in Azure to be fast enough to have good performance

> tutorial courses

I have an idea to write one, but haven't done it yet ~
 

Users who are viewing this thread

Top Bottom