Hi guys,
Thanks to a lot of luck and help from you great people, I am on the verge of completing my first Database/Application.
but at the moment the Jet Engine back end is not able to handle the load
here are some specs re my database:
Back End: Access -> Jet Engine
Front Ends: Access -> Jet Engine
usually not more than 2 users accessing the database and the back end is stored on one of the users computers which is quite a new computer.
Here are some structural mistakes I believe that could be causing the problem:
1. Whenever I add a new record, I use ADO to connect to an entire table as a recordset, I would think that would be putting unnecessary load on the Jet back end, what is the most streamlined way to add a new record to a recordset.
2. I have external query objects (in the front ends), will external query objects put more load on my front end then SQL strings in VBA would?
Thank You Very Much
4 1790 dima69 181
Recognized Expert New Member
Hi guys,
Thanks to a lot of luck and help from you great people, I am on the verge of completing my first Database/Application.
but at the moment the Jet Engine back end is not able to handle the load
here are some specs re my database:
Back End: Access -> Jet Engine
Front Ends: Access -> Jet Engine
usually not more than 2 users accessing the database and the back end is stored on one of the users computers which is quite a new computer.
Here are some structural mistakes I believe that could be causing the problem:
1. Whenever I add a new record, I use ADO to connect to an entire table as a recordset, I would think that would be putting unnecessary load on the Jet back end, what is the most streamlined way to add a new record to a recordset.
2. I have external query objects (in the front ends), will external query objects put more load on my front end then SQL strings in VBA would?
Thank You Very Much
I am not sure what the problem is, however I think you do take one thing wrong.
Access database Back End never uses Jet Engine or anything else - it's just a file server. All data is processed at the Front End. So when you have a big table and you run a query to select a few records, the whole table must be transfered to the Front End anyway.
NeoPa 32,572
Recognized Expert Moderator MVP - Opening a table will generally not load all the data. This is a non-issue. Let Access handle it.
- If you mean QueryDefs in your front end, then it's actually better to use them than a VBA SQL string. The former are 'optimised' on first use. A SQL string needs to have optimisation guesses done every time it's run. The Jet Engine will work quite happily on the Back End database.
PS. I don't like to contradict other Experts (so apologies for that Dima) but I think I'm right on this occasion. I would be happy to be proved wrong if there's something I need to learn. I may ask some other Experts to have a look in to check.
NeoPa 32,572
Recognized Expert Moderator MVP
The Back End Access DB & Jet Engine discussion is continuing, but not in here please.
This thread is now dedicated only to the original topic.
Denburt 1,356
Recognized Expert Top Contributor
Hi guys,
Thanks to a lot of luck and help from you great people, I am on the verge of completing my first Database/Application.
but at the moment the Jet Engine back end is not able to handle the load
here are some specs re my database:
Back End: Access -> Jet Engine
Front Ends: Access -> Jet Engine
usually not more than 2 users accessing the database and the back end is stored on one of the users computers which is quite a new computer.
Here are some structural mistakes I believe that could be causing the problem:
1. Whenever I add a new record, I use ADO to connect to an entire table as a recordset, I would think that would be putting unnecessary load on the Jet back end, what is the most streamlined way to add a new record to a recordset.
2. I have external query objects (in the front ends), will external query objects put more load on my front end then SQL strings in VBA would?
Thank You Very Much
I think the guys got a little off the beaten path here (no offense).
1. noneed to use a an ado recordset when a simple insert statement or an append query would do the job. This would be much more efficient for adding a record to a table. This would also lead us to question 2.
2. Very good question, I would think a saved query would be the best bet for most circumstances, although this is something I would prefer to back up with documentation or a test with some Extremely large additions.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Mike Y |
last post by:
i am new to this group, yet i come here from advice. I want to start a
career in the webmaster industry. I have a computer science degree, I know
HTML, java, php, and databases well. I also know dreamweaver well.
I want to know if webmaster is a solid career in terms of working as
consultant (independent)? What about working in a company?
Is it a sociable career, meaning is there interaction with people all the
time instead of just...
|
by: pbbriggs |
last post by:
I will try to be as descriptive as possible, but this error has me
stumped and I am not sure what relevant info to include....
I am running Access XP on a Windows XP machine. I initially began
developing an app in Access 2000 but converted it several months ago
to XP. So the app is now Access XP format also.
My app is crashing on a regular basis, with the totally non-descript
Microsoft error (Microsoft Access has encountered a...
|
by: Siobhan Perricone |
last post by:
I have a user who is having a problem with an access database that I
didn't build and haven't had anything to do with in the past.
The database opens up to the switchboard, and she clicks through to
the "look up by facility name" form, and opens it up. So far so good.
She is able to click on and view every single thing on this pretty
complicated form, including opening a variety of secondary forms.
However, whenever she clicks on the...
|
by: trond |
last post by:
Hello all,
Before I start I'd like to point out that I am a complete novice when
it comes to asp.net - My background is in network and operating
systems, and although I have been doing a bit of hobby programming in
vb.net and web programming in asp/vbscript in the past, I am pretty
much a beginner at asp.net.
What I'm trying to do, is to take the "PersonalHomePage" starter kit
that MS supplies with VS2005 and tweak it a bit, to make it...
|
by: The Confessor |
last post by:
For my previous project, I stored persistent data from Structures in three
different Random Access files between sessions, but that's not likely to be
an option with this one...
For starters, I'm trying to become more 'class-aware' with my code in this
project. I've declared those global variables which will be written to and
read from files in their own class, named VariableTemplate, and
instantiated it globally with 'Friend Variable as...
| |
by: Knut Olsen-Solberg |
last post by:
I try to change the text in a <p> using getElementById(). I wonder what properties exists, and which one to use here. (The following does not work.)
Regards Knut
______________________
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<TITLE>JavaScript</TITLE>
|
by: BillE |
last post by:
When a user opens a new IE browser window using File-New-Window the
integrity of an application which relies on session state is COMPLETELY
undermined. Anyone who overlooks the fact that File-New-Window creates an
instance of IE in the same process with the same SessionID as the parent
window is in big trouble. This fundamentally restricts the usefullness of
using session state management.
I probably missed it somewhere - can...
|
by: aaron |
last post by:
Hello folks,
Has anyone ever experienced the Access 2002 runtime crashing when the
"Compact on Close" option is set for an MDE file?
We are currently having this problem on a number of internal machines,
and have been struggling to find a lead for several days now, to no
avail.
MSAccess.exe is consistently crashing with Vbe6.dll (DLL version
|
by: juliancasa |
last post by:
My form is used for entering records in Access 2007.
When a user clicks a button to submit one, I want a pop-up box to load up
saying "Would you like to enter another record?" with Yes or No options
listed below. If yes, a new blank record loads up, if no, the form closes. My form and table are both called Hospitals.
How can I do this? (I am a bit of an Access novice so if you could be basic
in your answer - i.e. where to place...
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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...
| |