I am moving my education company’s database to a Microsoft 365 backend with a Access frontend at each of our six locations. (Until now I’ve used a VPN with the backend on a company server, but this was slow and unreliable.) It is working well so far, but there are performance issues, as I believe Crystal has noted in the past on this forum. Building all of my queries on the Azure SQL backend has helped significantly, however.
I am creating a routine to make invoices for our approximately 600 students, but I believe it will be too complicated to run smoothly via the Azure SQL backend so am thinking I will need to bring the data to the local frontend, manipulate it there, and then append entries to the invoices table on the Azure SQL backend when finished. I’m not sure what would be the most efficient way to do this, however. The two thoughts I’ve had are to create (a) table(s) on the local frontend that are then deleted when the process is complete or to create and manipulate a class module. I’ve been doing a lot of reading on class modules, but have never used them before. I would appreciate any advice or ideas on what the most efficient way to handle this would be. Thank you for all your help and consideration.
Ryan Hagglund
MY English School
Yamagata, Japan
Posted by: "Ryan Hagglund" <rhagglund@myeigo.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar