Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    8,730
    I have never experienced OnCurrent running more than once in all the testing I've ever done. Perhaps after a loaded form makes the first record current there was something that moved the focus to a new record right after? I could see that making it fire twice.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  2. #17
    keviny04 is offline Competent Performer
    Windows 7 64bit Office 365
    Join Date
    Apr 2015
    Posts
    114
    Quote Originally Posted by Micron View Post
    I have never experienced OnCurrent running more than once in all the testing I've ever done. Perhaps after a loaded form makes the first record current there was something that moved the focus to a new record right after? I could see that making it fire twice.
    It would only occur in a subform's OnCurrent event, according to my experience years ago (also see this old discussion). I just tested this on my latest Access projects and yes, this "issue" is still present. My understanding is that the code in the OnCurrent event may trigger the event more than once, in addition to being triggered by the user navigating through the subform's records. If the database resides locally, you may not even notice a difference. But boy, if this happens on remote data (the topic of this thread), the performance hit will be catastrophic if the OnCurrent event does a lot of data retrieval. And this is not exactly an obvious issue either. When I first got this problem, it certainly took me a while to figure it out, back when Internet speed was only 1 Mbps and online info was scarce.

  3. #18
    keviny04 is offline Competent Performer
    Windows 7 64bit Office 365
    Join Date
    Apr 2015
    Posts
    114
    I made a video showing Access applications before and after the move to cloud data with no change to the design or code in the Access front-ends. While using local data, every operation is nearly instantaneous as expected. After switching to cloud data, there are noticeable delays that vary in severity. One app is tolerable even with the delays, while the other isn't (of course, that's subjective depending on the user). Both apps use tables and queries that involve 2K, 10k, to 600k rows of data, so this is a good stress test for how things perform in a cloud environment. Users who consider moving to the cloud are well-advised to do a test like this on your app before going live or making any major purchase decisions. Which brings up this point: Azure is expensive. I use only a $48 a year ($4 a month) hosting site, Winhost.com, which can host Access and SQL Server databases. So one should consider that Azure may be overkill for many users. My test was done in single-user mode. If necessary, do your tests with multiple users as well. The only thing my tests didn't do was inserting data into tables. Internet speed matters in both download and upload because you send as well as receive data in database operations. A query that inserts thousands of rows of data is going to be slow if you only have 5 Mbps upload speed like I do. Hope this info will help someone.
    Last edited by keviny04; 04-25-2021 at 12:44 PM.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Moving Access to the Cloud
    By jeff@bennet-Tec.com in forum Access
    Replies: 3
    Last Post: 11-22-2018, 07:36 PM
  2. Replies: 5
    Last Post: 05-12-2017, 11:40 AM
  3. Replies: 8
    Last Post: 12-16-2016, 07:10 PM
  4. Access backend in the cloud - am I dreaming?
    By Gina Maylone in forum Access
    Replies: 5
    Last Post: 01-01-2016, 09:22 PM
  5. Cloud based Access?
    By Perceptus in forum Access
    Replies: 4
    Last Post: 12-30-2015, 05:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums