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

FE/BE Question

P: n/a
ALV
Hi,

I have a database in our company Intranet that is being used by a small
group of about 8 to 10 employees. I left the database intact - no split
- but in reading through some of the postings here the concensus is
that such a setup could eventually cause data corruption. I'm using
Access 2000.

I did try splitting the database into a FE/BE setup to test it, but
when I use the FE to access the linked table data via the forms, it
takes upwards of 45 seconds to over a minute before the form opens.
When the database is intact, the forms take only a few seconds to open.

Any ideas as to how this can be corrected? I've done some search in the
Web, but I haven't found much in the way of helpful details, other than
getting some understanding as to what the cause may be.

Thanks for your input, suggestions and time!

ALV
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
There are several things you may need to adjust to get the performance right
on a split database. Tony Toews has a good list at:
http://www.granite.ab.ca/access/performancefaq.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ALV" <me@spamfree.com> wrote in message
news:IN********************@comcast.com...

I have a database in our company Intranet that is being used by a small
group of about 8 to 10 employees. I left the database intact - no split
- but in reading through some of the postings here the concensus is
that such a setup could eventually cause data corruption. I'm using
Access 2000.

I did try splitting the database into a FE/BE setup to test it, but
when I use the FE to access the linked table data via the forms, it
takes upwards of 45 seconds to over a minute before the form opens.
When the database is intact, the forms take only a few seconds to open.

Any ideas as to how this can be corrected? I've done some search in the
Web, but I haven't found much in the way of helpful details, other than
getting some understanding as to what the cause may be.

Thanks for your input, suggestions and time!

ALV

Nov 12 '05 #2

P: n/a
ALV
Allen Browne wrote:
There are several things you may need to adjust to get the
performance right on a split database. Tony Toews has a good list at:
http://www.granite.ab.ca/access/performancefaq.htm


Thank you, Allen! Great suggestions found here. I'll try them out.

ALV
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.