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 1770
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,556
Expert Mod 16PB - 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.
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...
|
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...
|
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...
|
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...
|
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,...
|
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
______________________
...
|
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...
|
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...
|
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...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |