Page 1 of 2 12 LastLast
Results 1 to 15 of 27
  1. #1
    petes1505 is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Nov 2021
    Posts
    34

    Long Delay When Saving Changes to Form Design or CHanging from Form Design to Form View

    Hello Everyone,

    Iím new to this forum and appreciate any help others might be able to provide.



    I recently developed an Access database with a form that includes buttons which when clicked run queries and displays the results. Nothing special, just basic queries. However, any time I save a change to the form design (add a button, change the text of a label, etc.) or change from form design to form view, it takes anywhere from 7-10 minutes. If I modify or create a new query, saving those updates only take a few seconds. It is just when trying to save a form that takes a very long time.

    Some facts about the database:


    1. Using the latest version of MS Access provided with Office 365.
    2. Using a split database with the front-end on a local PC and the back-end on a network server.
    3. There are ten tables linked to ten .csv files on the network server.
    4. Total size of the front-end database is 1,444 kb
    5. Total size of the back-end database is 14,736 kb
    6. Perform Name AutoCorrect has been deselected.
    7. Track Name AutoCorrect is still selected.


    Iíll be happy to provide any additional information if it will help.


    Any thoughts on what may be causing the issue?

    Thanks in advance.
    Pete

  2. #2
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    2,804
    I suspect it's the linked csv files.
    Are they referenced on the forms in question as a record or row source?

    As an experiment, import them as local tables, save and compact and repair, and see if the issue disappears.

    If that's the issue, try creating queries that simply list all the fields in the linked tables and use those instead of the direct links.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    petes1505 is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Nov 2021
    Posts
    34
    Hello. Thank you for your response.

    The csv files are not mentioned anywhere on the form. There are ten tables in the database that are linked to those 10 csv files, but that's it. The csv files are not used or mentioned anywhere in the database itself.

    Also, all of the queries already use only the fields from the linked tables.

    Thanks,
    Pete

  4. #4
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,250
    If you create a new form and don't link it to any data and add a control it will take 7 to 10 minutes to save this new form? If yes, you do the same in a new db and get the same result? Then you must be on a very slow network or are using a vpn, or both?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #5
    petes1505 is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Nov 2021
    Posts
    34
    I work remote and use a VPN, but why would that cause such an issue? Everything else works perfectly well. Saving and running queries is not an issue. It's only when saving the MS Access form. There are no functionality issues with any other program including the entire MS Office suite.

  6. #6
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,250
    Very common complaint with vpn and Access. However, I suggested tests to see if the issue might be the form or the db itself?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  7. #7
    petes1505 is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Nov 2021
    Posts
    34
    Hello. I created a new database, created a table linked to one of the csv files, then created a query using the linked table. I then created a blank form, added a button that executes the query. When I saved the form it took a few seconds. So, I may be wrong but my gut tells me it's something with the database. I'm just not sure where to look or how to troubleshoot.

  8. #8
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    2,804
    In your new DB , What happens if you set the recordsource of the form to the linked table, and add one bound control.
    This is very different to running a query on the linked table.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  9. #9
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,250
    I then created a blank form, added a button that executes the query. When I saved the form it took a few seconds
    Then IMO it is either the original form or the db itself that is the problem. If you care to know which, create a new db and import all your objects into it and see what effect it has. If it is then OK it is likely the db itself. If not, it is likely the form. If you have imported it into the new db that means you have to create another new db but leave out that form and recreate it manually in the new db.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  10. #10
    petes1505 is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Nov 2021
    Posts
    34
    I don't follow. It is not a single table. The form includes multiple queries, and each query utilizes at least one of the 10 linked tables.

  11. #11
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,059
    presume you have done a compact/repair on the FE?

    and to be clear, when you say

    'Using a split database with the front-end on a local PC '

    by a local PC, you do mean your PC?

    IT depts often map the documents (and other) folders to a server, so you think you are running from your local machine when in fact you are running a file on a server - check the filepath (currentdb.name)

    And does it make a difference if you open the FE exclusively?
    https://www.quackit.com/microsoft_access/microsoft_access_2016/howto/how_to_open_a_database_in_exclusive_mode_in_micros oft_access_2016.cfm

  12. #12
    petes1505 is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Nov 2021
    Posts
    34
    OK. I created a new DB and started importing. I imported the tables first, then tried to make a design change and it saved quickly. I then imported the queries, and as soon as I did that the same issue happened. So it looks like it may have something to do with the queries. Any ideas on how to troubleshoot?

  13. #13
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,059
    you said the tables were linked - so how did you make design changes?

    Also appreciate an answer to my questions

  14. #14
    petes1505 is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Nov 2021
    Posts
    34
    Yep, already performed the compact/repair process. Yes, by local PC is my PC (laptop). I checked the paths and all are correct

  15. #15
    petes1505 is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Nov 2021
    Posts
    34
    Have not had to make any design changes to the tables. Only design changes are to the form.

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

Similar Threads

  1. Replies: 1
    Last Post: 01-24-2017, 09:50 AM
  2. Replies: 6
    Last Post: 12-15-2015, 04:11 PM
  3. Replies: 4
    Last Post: 10-29-2015, 01:46 PM
  4. Replies: 5
    Last Post: 04-24-2015, 11:58 PM
  5. Replies: 8
    Last Post: 04-29-2013, 11:23 AM

Tags for this Thread

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