Maybe I’m missing something here, I have been following the rules listed below to implement my cloud-based database SQL Server, I can confirm the rules listed below have sorted out all my reports, they pull data almost instantly BUT not data entry forms, the parent and child forms have these characteristics:
Rules to be implemented with MS Access against SQL Server Cloud
When using MS Access and SQL Server you could obey the rules listed below:
(1) open a form with only ONE record (e.g., with Open Form "xx", Where: ="ID = 100"
(2) Use first a form for filtering the data and then open an Edit-Form with only the selected record
(3) don't use complex queries as data source for a form
(4) don't use a whole table as data source for a form (when the table contains more than a dozen records)
(5) All complex queries must be converted into views
Questions
The worry here is the point of sales only which require speed as the items are being scanned the data entry must be instant like in MS Access.
- Opening or loading they take something like 15 seconds.
- Cursor movement from parent form to child the cursor takes 12 seconds.
- Combo selection takes 3 seconds (which is fine)
- Cursor movement in the data sheet or sub form from one line to create the new (Send Line) line it takes 10 seconds.
Rules to be implemented with MS Access against SQL Server Cloud
When using MS Access and SQL Server you could obey the rules listed below:
(1) open a form with only ONE record (e.g., with Open Form "xx", Where: ="ID = 100"
(2) Use first a form for filtering the data and then open an Edit-Form with only the selected record
(3) don't use complex queries as data source for a form
(4) don't use a whole table as data source for a form (when the table contains more than a dozen records)
(5) All complex queries must be converted into views
Questions
- I very sure most of the experts went through this, my question is how possible you can filter a data entry form which essentially load empty as per rule number one on top? If we were editing record only it's okay that filter will work, now here I’m talking about entering data into a table, new data for the first time which never existed before.
- Linking forms to views sometimes the forms create duplicate data when capturing and so this is not an option here. Is linking the forms to linked tables to bad or not?
- Currently all the shops are using Wi-Fi as the method of connecting to the cloud database and most of the laptops like Lenovo they come without the provision for ethernet cable, could it be the cause of this slowness? I need to be clear here also before advising clients to invest on wired internet.
The worry here is the point of sales only which require speed as the items are being scanned the data entry must be instant like in MS Access.
Last edited: