By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,660 Members | 1,953 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,660 IT Pros & Developers. It's quick & easy.

DB Slows to a crawl when editing FE

P: n/a
I have a FE / BE setup on my database. One of the main reasons that
I
did this was so that I could edit the front end and upload it without
causing problems with day to day activities.

I have it sat up with user group security so everyone has to log in.
I have a seperate FE that i edit changes in, but it is still pointed
at the BE data. My problem is that when i log into the database to
edit it, even though i'm using a seperate FE than active users, the
database slows to a crawl unless everyone logs out. It takes minutes
between actions
when editing anything.

I've tried making a copy of the DB and stripping all of the tables
out, however when i import forms from it and restart the DB it
crashes. I've also tried importing the tables back into the FE that
i'm editing so the tables are actually there, but i have the same
results; when i import the forms into the working DB it crashes.

Am I doing something wrong? Is this a common
problem? Does anyone know of a work around or solution to this?

I apologize cross posting. I did post this problem in c.d.ma.Forms
last friday but only got one response and it didn't help.

Any suggestions would be greatly appreciated.

Jan 8 '08 #1
Share this Question
Share on Google+
12 Replies


P: n/a
On Jan 8, 12:08 pm, Snoopy33 <holland...@hotmail.comwrote:
I have it sat up with user group security so everyone has to log in.
I have a seperate FE that i edit changes in, but it is still pointed
at the BE data. My problem is that when i log into the database to
edit it, even though i'm using a seperate FE than active users, the
database slows to a crawl unless everyone logs out. It takes minutes
between actions
when editing anything.
make sure your FE link is to the one on the C drive.

I've tried making a copy of the DB and stripping all of the tables
out, however when i import forms from it and restart the DB it
crashes. I've also tried importing the tables back into the FE that
i'm editing so the tables are actually there, but i have the same
results; when i import the forms into the working DB it crashes.

all of your tables are in the BE and all your forms are in the FE?
Jan 8 '08 #2

P: n/a
Snoopy33 wrote:
I have a FE / BE setup on my database. One of the main reasons that
I
did this was so that I could edit the front end and upload it without
causing problems with day to day activities.

I have it sat up with user group security so everyone has to log in.
I have a seperate FE that i edit changes in, but it is still pointed
at the BE data. My problem is that when i log into the database to
edit it, even though i'm using a seperate FE than active users, the
database slows to a crawl unless everyone logs out. It takes minutes
between actions
when editing anything.

I've tried making a copy of the DB and stripping all of the tables
out, however when i import forms from it and restart the DB it
crashes. I've also tried importing the tables back into the FE that
i'm editing so the tables are actually there, but i have the same
results; when i import the forms into the working DB it crashes.

Am I doing something wrong? Is this a common
problem? Does anyone know of a work around or solution to this?

I apologize cross posting. I did post this problem in c.d.ma.Forms
last friday but only got one response and it didn't help.

Any suggestions would be greatly appreciated.
Check out Tony Toew's site.
http://www.granite.ab.ca/access/splitapp/index.htm

The one that made my app slow was long file names. Ex:
\TestApplication\Junk.mdb. Better if it were \Test\Junk.mdb.
Jan 8 '08 #3

P: n/a
As others have recommended, keep a development copy of the FE and BE
in a Development directory on your local hard drive. Then link the
local FE to that local BE to do your edits. Once yoru are ready to
publish the new FE relink to the live data and send it out to each
user. I assume you are not making the mistake of allowing all users
to work with a single copy of the FE. If you are, do yourself a big
favor now and search the NG as to why you should not do so. Basically
it is not a matter of IF your data gets corrupted but WHEN.
Jan 8 '08 #4

P: n/a
Thanks for all the responses.

Yes, All 61 tables are in the BE and all forms are on the FE.

I'm using the autoFEupdater that I downloaded at Tony Toew's site.
It's excellent. It allows everyone to store a copy of the FE on their
local computer and download the updated copy only if it's been
updated.

the path to my db is r:\rma\system\edit ' Storage for copy i'm
working on
\Save ' storage
for saved copy before updating to new FE
\BE ' Storage
for BE
\rev ' Storage
for current revision

the database name is RMA.mdb. I don't think the problem is too long a
path or Dir names.

I'll try what you suggested as far as keeping a local BE directory and
then relinking to the working BE when updating.

The only problem that I see is in relinking all 61 tables while
everyone is logged in, although I can make changes and stay after
everyone leaves or get there early in the morning to upload the
changed copy. This would at least allow me to freely make changes
during the work day.

Jan 8 '08 #5

P: n/a
fr********@yahoo.com wrote:
As others have recommended, keep a development copy of the FE and BE
in a Development directory on your local hard drive. Then link the
local FE to that local BE to do your edits. Once yoru are ready to
publish the new FE relink to the live data and send it out to each
user. I assume you are not making the mistake of allowing all users
to work with a single copy of the FE. If you are, do yourself a big
favor now and search the NG as to why you should not do so. Basically
it is not a matter of IF your data gets corrupted but WHEN.
Additionally,
Tools/Addins/Linked Table Manager (A97)
Tools/DatabaseUtilities/Linked Table Manager (2000+)

Use File/GetExternalData/Link when you add a new table to the BE.
Jan 8 '08 #6

P: n/a
I've created local FE and BE directories and changed the links on my
FE to point to the local one. as an experiment, I tried to relink the
DB while i had about half a dozen people logged in. I thought it
locked up and had to cancel the operation and do an end task, however
when i brought it back up, it appeared to have relinked several of the
tables to the Live BE. I guess patience would have been the
rule :D .

I still believe it will be more prudent to wait until the evening when
everyone leaves or morning before anyone logs on to relink and upload
changes, but this does give me a work around to my original problem of
not being able to edit during the day.

Thanks to everyone who responded. All responses were useful.

Ben
Jan 8 '08 #7

P: n/a
User level security? Make sure you use a separate copy of
the MDW while doing design work. Design work sometimes
locks up the the network copy of the workgroup.

(david)

"Snoopy33" <ho********@hotmail.comwrote in message
news:4b**********************************@h11g2000 prf.googlegroups.com...
>I have a FE / BE setup on my database. One of the main reasons that
I
did this was so that I could edit the front end and upload it without
causing problems with day to day activities.

I have it sat up with user group security so everyone has to log in.
I have a seperate FE that i edit changes in, but it is still pointed
at the BE data. My problem is that when i log into the database to
edit it, even though i'm using a seperate FE than active users, the
database slows to a crawl unless everyone logs out. It takes minutes
between actions
when editing anything.

I've tried making a copy of the DB and stripping all of the tables
out, however when i import forms from it and restart the DB it
crashes. I've also tried importing the tables back into the FE that
i'm editing so the tables are actually there, but i have the same
results; when i import the forms into the working DB it crashes.

Am I doing something wrong? Is this a common
problem? Does anyone know of a work around or solution to this?

I apologize cross posting. I did post this problem in c.d.ma.Forms
last friday but only got one response and it didn't help.

Any suggestions would be greatly appreciated.

Jan 10 '08 #8

P: n/a
Snoopy33 <ho********@hotmail.comwrote:
>I've created local FE and BE directories and changed the links on my
FE to point to the local one. as an experiment, I tried to relink the
DB while i had about half a dozen people logged in. I thought it
locked up and had to cancel the operation and do an end task, however
when i brought it back up, it appeared to have relinked several of the
tables to the Live BE. I guess patience would have been the
rule :D .
If you are running your own relinking code then once you've relinked the first table
open a recordset against that table. Relinking the subsequent tables will go much,
much faster.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Jan 12 '08 #9

P: n/a
Snoopy33 <ho********@hotmail.comwrote:
>
I have it sat up with user group security so everyone has to log in.
I have a seperate FE that i edit changes in, but it is still pointed
at the BE data. My problem is that when i log into the database to
edit it, even though i'm using a seperate FE than active users, the
database slows to a crawl unless everyone logs out. It takes minutes
between actions
when editing anything.
Do you have a table, recordset or bound form open against the database while you are
editing the FE linked to the BE on a network share? This is extemely important.

Although even there I find it to be too sluggish to allow me my full productivity.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Jan 12 '08 #10

P: n/a
"Tony Toews [MVP]" <tt****@telusplanet.netwrote in
news:jd********************************@4ax.com:
A lot of people do that. So open up a form, any bound form, such as
that hidden one, and leave it open while you are editing.
Never did nothing for me, notimes.
Jan 23 '08 #11

P: n/a
Snoopy33 <ho********@hotmail.comwrote:
>IT WORKS!!!!!!!!!!!!!!!

Not sure why, but having a form open / minimized linked to data on BE
makes editing a breeze....
Same reason it helps with the users performance.
>Thanks a Million!!!
You're welcome.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Jan 24 '08 #12

P: n/a
lyle fairfield <ly******@yah00.cawrote:
>A lot of people do that. So open up a form, any bound form, such as
that hidden one, and leave it open while you are editing.

Never did nothing for me, notimes.
You've stated that in the past once or twice as I recall. And I have no idea as to
why.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Jan 24 '08 #13

This discussion thread is closed

Replies have been disabled for this discussion.