split network BE local FE is causing saving of code in VBE to be very slow

hey guys,

i've got a DB with the BE on the network and the FE on the local machine. when i change code in VBE and press ctrl + s, it takes a very, very, very long time to save. however when i move my BE to my local machine, it saves instantaneously. why is this so?

the FE is always on the local machine and the save is for the VBA code. i'm really unsure why the network BE is even affecting the local FE - if not what's the point of even splitting things right?
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
I always split the database, but do my development work with a local copy of both the FE and BE.

Do you have "Track Name AutoCorrect" turned OFF? That's been known to cause the issues you have. You can toggle that property in Access Options, on the Current Database tab.
Jeffrey CoachmanMIS LiasonCommented:
Do not try to edit a front end over the network...
Keep a "Developer" copy of the front end on your local machine and make your design changes to this database.
(Then distribute this db (as an mde/accde)
developingprogrammerAuthor Commented:
yup yup boag2000, the FE is on my local machine and that's why i'm not sure why this is happening. if the FE is on the network i can understand - but the FE is on my local machine ha
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
My mistake... This is a typical issue when the FE is on the server, ...sorry for the knee-jerk post...

Can I presume you are doing  the following:
Compacting the FE on a regular bases.
Have you tried creating a new FE and importing all the objects?

How are you linking the FE and BE?
Have you tried deleting the links, then relinking the tables.

I may be missing something simple that another expert might see, so lets stay tuned...

developingprogrammerAuthor Commented:
thanks Jeff for your help on all this = ) i really appreciate it = )

yes i'm compacting my database many many times ha, each time i restart it for development i C&R it - so perhaps 30 times a day? haha

i have not tried creating a new FE and importing all the objects recently. i can try doing that but i'd probably hold off for a bit cause i'm just unsure if there might be any problems doing that. hrmm.. probably not cause the relationships for the tables are in the BE so i won't lose the diagrams. i know there's a tool to port over the diagram but i haven't used it successfully yet. lack admin rights etc

yes i just recently relinked the tables = )

ok let's stay tuned! = )
developingprogrammerAuthor Commented:
ok Jeff just to feedback, i observed the BE file in the network and when i save my front end (i'm just making minor changes to the code), the BE keeps on opening and closing opening and closing. i've got no idea why ha.
developingprogrammerAuthor Commented:
hrmm it's almost as though the FE is relinking the tables to the BE
developingprogrammerAuthor Commented:
whao LSMConsulting, i think you may be right but i have yet to try it on the database. but i think you have a very good point about doing development work with local copy of both FE and BE.

it'll be interesting to see if autocorrect is the cause of it, but i think i will adopt what you're doing an work with both local FE and BE = ) thanks LSMConsulting! = )
developingprogrammerAuthor Commented:
hi LSMConsulting! i think you're probably right that the autocorrect is the culprit of the long save, but i have not tried to reproduce this yet because i've adopted your practice of working with a local BE as well.

i understand that Allen Browne "decimates" autocorrect, but for me it has helped me quite a few times change the references when i changed my query name and that has been quite invaluable to me frankly so i have opted to leave it on and accept any consequences that comes along with it - perhaps like this long save = )

but thanks so much for your help LSMConsulting! as always, i really appreciate it!!
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
it has helped me quite a few times change the references when i changed my query name and that has been quite invaluable to me frankly so i have opted to leave it on and accept any consequences that comes along with it - perhaps like this long save = )
Name AutoCorrect can also cause non-recoverable corruption in your database. If your only need for it is the ability to change the occasional object name, then invest the money in Rick Fisher's Find and Replace:


It can replace your object names (among other things), and won't cause problems.
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Ditto about Rick Fisher's Find and Replace.
developingprogrammerAuthor Commented:
Gulp!! Omg guys!!!! Ok I will do that first thing tomorrow morning!!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.