Hello all,
I have a front and back end to my database. The back end holds only tables, while the front end holds all forms, reports, queries and modules, with links to all the tables in the BE. For some reason the FE is going really slow, it's been suggested that maybe I'm having my tables refreshed too often. I haven't explictly put in the code anywhere to refresh the tables, so I'm wondering if it happens automatically, and if so, at what frequency and how I can either disable it entirely, or set so that it only updates tables when the table has been edited.
3  3375   MMcCarthy 14,534
Recognized Expert Moderator MVP
Hello all,
I have a front and back end to my database. The back end holds only tables, while the front end holds all forms, reports, queries and modules, with links to all the tables in the BE. For some reason the FE is going really slow, it's been suggested that maybe I'm having my tables refreshed too often. I haven't explictly put in the code anywhere to refresh the tables, so I'm wondering if it happens automatically, and if so, at what frequency and how I can either disable it entirely, or set so that it only updates tables when the table has been edited.
Firstly, I have moved your post to the Access forum. You mistakenly posted in the articles area.
Secondly, I don't believe that the problem is your tables refreshing unless you have code explicitly doing so.
There are a number of other areas to be looked at.
Is the network connection between the frontend and backend database running slow. To test this try just opening a table in data view on the frontend and see if there is any delay.
If there isn't then try running one of your saved queries and see if there is any delay there.
If neither of those things is causing a problem then you will need to look at the code behind your forms. Are you using a lot of recordsets or preforming a lot of operations in the form load events.
As for the reports have you got some fields declared as memo fields? These are notorious for slowing down reports.
Sorry about the mistake in posting.
I checked my network connection, it is indeed slow. Even when I place the front and back ends into the same folder, performance barely increases.
The forms do indeed have quite a bit of onload, oncurrent and onopen operations, and they have multiple subforms on them (3-5). On top of that, the main form I have problems with is an unbound form that fills in all the fields based on where it is accessed from. I know that can be a slow operation. This at times created slowdowns before I split the database into front and back ends; since the split, it has become unbearable for users.
I don't want to go back to one database for data safety reasons and filesize, but it sounds like I may have to rebuild big parts of the DB in order to set it up to give me front end speed.
Firstly, I have moved your post to the Access forum. You mistakenly posted in the articles area.
Secondly, I don't believe that the problem is your tables refreshing unless you have code explicitly doing so.
There are a number of other areas to be looked at.
Is the network connection between the frontend and backend database running slow. To test this try just opening a table in data view on the frontend and see if there is any delay.
If there isn't then try running one of your saved queries and see if there is any delay there.
If neither of those things is causing a problem then you will need to look at the code behind your forms. Are you using a lot of recordsets or preforming a lot of operations in the form load events.
As for the reports have you got some fields declared as memo fields? These are notorious for slowing down reports.
MMcCarthy 14,534
Recognized Expert Moderator MVP
Try putting a copy of the frontend on the local machine and just leave the backend on the network. See if that helps any.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Andreas Lauffer |
last post by:
I changed from Access97 to AccessXP and I have immense performance
problems.
Details:
- Access XP MDB with Jet 4.0 ( no ADP-Project )
- Linked Tables to SQL-Server 2000 over ODBC
I used the SQL Profile to watch the T-SQL-Command which Access ( who
creates the commands?) creates and noticed:
|
by: Scott Tilton |
last post by:
I am having a terrible time getting this to work. I am hoping someone out
there can help me with very specific code examples. I am trying to get the
linked tables in my Access 97 database to be updated whenever the database
opens. I need to have them updated based on an INI file that resides in the
same directory as the current database.
I do not need or want the ability to open a dialog box to pick the location.
I simply want it to...
|
by: Robert McGregor |
last post by:
Hi all,
I've got a Front End / Back End database that was working just fine.
One day i opened the FE to find that if I tried to open one of the
linked tables from the database window, nothing happened (hourglass
for about 2 seconds then nothing).
I tried relinking the tables and got the same response. (Access even
completely bombed out once with a Dr Watson failure).
|
by: Joe |
last post by:
I am using Access 2003 and are linking to an Oracle 9i ODBC datasource
(using Oracle ODBC drivers). After linking the tables in Access, I inspect
the data contained in the linked tables. For tables that involve a number
field as the primary key, the data is returned successfully. For tables
that involve a character field (e.g. CHAR(3) or VARCHAR(10)) as the primary
key, I have the correct number of rows returned, but the data displayed...
|
by: Lewis Veale |
last post by:
I have an Access 2000 front-end pointing at a SQL Server backend, with
around 80 linked tables and views. I frequently need to point the
front-end at different versions of the back-end, and achieve this by
relinking the tables and views to use a different DSN.
I use the Linked Table Manager > Select All > and tick the 'always
prompt for a new location' box, then click OK. It correctly pops up
the 'select data source' box, from which I...
| | |
by: Jill Elaine |
last post by:
I am building an Access 2002 frontend with linked tables to an
encrypted Paradox 7 database. When I first create these linked tables,
I'm asked for the password to the encrypted Paradox database, and the
linked tables are successfully created. I use the data from these
linked tables in several forms.
All works great until I close the Access frontend and open it again.
When I try to use the forms, I get an error message: "Could not...
|
by: sean.hpr |
last post by:
Hi all-
I am a vb2005 newb so apologies in advance. Essentially I am having
some problems with data refreshing on some of my forms.
Background:
I have created a project containing a few forms. The main form is
linked to a data feed which is constantly refreshing data as it is
available (it checks automatically and is updating a few times per
second). The other forms are essentially taking this data and
|
by: jpatchak |
last post by:
Hello All,
Is there a way to refresh a linked table programatically through VBA (as part of an error handler). I have an Access database with several tables linked through ODBC. User forms are in a front end MDB file. Sometimes, I must make changes to the data model that don't necessarily affect the front end forms for most of my users. When this happens, I have to refresh the tables and send a new copy of the MDB file out to all my users...
|
by: sweeneysmsm |
last post by:
Working in Access 2003, Windows XP Pro - (client not faithful to updates:(.
I have succeeded in splitting a database. (I am actually
working on a "test run copy" to insure that I am safe. My back-end contains
my tables and my front-end forms etc have "linked" icons preceding them.
Regarding the relinking code:
1. In my Access 2003 Inside-Out book it gives Startup Code to Verify and
Correct Linked Table Connections (on p. 1206)....
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
