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?
developingprogrammerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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)
0
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
0
Jeffrey CoachmanMIS 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...

JeffCoachman
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

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! = )
0
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.
0
developingprogrammerAuthor Commented:
hrmm it's almost as though the FE is relinking the tables to the BE
0
Scott McDaniel (Microsoft Access MVP - EE MVE )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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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! = )
0
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!!
0
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:

http://www.rickworld.com/products.html

It can replace your object names (among other things), and won't cause problems.
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Ditto about Rick Fisher's Find and Replace.
0
developingprogrammerAuthor Commented:
Gulp!! Omg guys!!!! Ok I will do that first thing tomorrow morning!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.