Why is saving a file so slow?

jglassner

New Member
Joined
Apr 28, 2016
Messages
31
Office Version
365
Platform
Windows, MacOS
Aloha

I split my database and overall I am happy. My one issue is when I save the file it takes forever when I am on the VPN network,. I understand that a VPN will be slower but I thought that splitting the database would speed that up as I am saving a local file. What could be making it slow down? A simple save can take a few minutes.

Thanks,
Jason
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,121
Office Version
365
Platform
Windows
Are you running regular Compact & Repair on your databases to keep them as "lean" as possible?
 

jglassner

New Member
Joined
Apr 28, 2016
Messages
31
Office Version
365
Platform
Windows, MacOS
I do with every close. I think I am confused as to why saving the front end takes so long? I assumed the local file would save quickly, does the FE access the back end when it closes. Can that be changed or should it be?
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,121
Office Version
365
Platform
Windows
I do with every close. I think I am confused as to why saving the front end takes so long? I assumed the local file would save quickly, does the FE access the back end when it closes. Can that be changed or should it be?
How many people are using the database?
Does each person have their own copy of the front-end?

If you have the front-end dataabase running a Compact/Repair evert time it closes, that could be part of the problem. You really shouldn't "Compact/Repair" on every close. I believe it can even cause corruption if you have multiple people attempting to compact the back-end at the same time. Typically, the back-end should be Compacted and Repaired right from the placed it is located on the Network (and note remotely via VPN). You might schedule a job to do it off hours.

There shouldn't be a huge need to Compact/Repair the front-end that often, as it shouldn't contain any data, only the queries, forms, reports, and VBA code. So people shouldn't be adding much to it. Compacting it before distributing new copies of the front-end (when changes are made) may even be sufficient.
 

jglassner

New Member
Joined
Apr 28, 2016
Messages
31
Office Version
365
Platform
Windows, MacOS

ADVERTISEMENT

Yes, each person has their own FE, but that shouldn't be the issue. A simple update to a form or report takes minutes to save and it is a local file, not saving over a network. A local file should save quickly, it seems that at close Access is doing something with the BE I just don't understand what it would be.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,121
Office Version
365
Platform
Windows
You said that your run a Compact & Repair "with every close".
Where exactly does that happen? Is that on thr front-end?
If you temporarily disable it, and try again, does that improve the speed?
 

Micron

Well-known Member
Joined
Jun 3, 2015
Messages
1,882
Office Version
365
Platform
Windows
I would not c&r on every close and would suggest saving a backup before doing so, assuming backups are not routine anyway.
There is no "save" to an Access file unless you're talking about design changes, and that should only be on the fe. If you mean a record save, that is a different matter. If you're talking about opening and closing forms/reports and all of them are super slow, then try opening an editable queyry directly and making one small change to any non-indexed field (e.g. add a period to a text field but remove it upon successful edit). If you make this edit and move off of the record and it chugs forever, then I don't know, except to say that I don't see how you can start a vpn session on your local machine and imply that because the db is local on that machine, you're not running through the vpn. Accessing any records would automatically be channeled through the vpn if the be is remote. Then again, vpn's are not my forte. I think you might have the wrong impression about "saving" data in Access. It is not like Word, where any changes to text need to be manually saved.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,258
Messages
5,510,126
Members
408,777
Latest member
LSlisher11

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top