Major Performance Issues
Apr 8, 2008
Hi there,
I am having huge performance issues with a FE/BE split. As a background, I have the following Table layout.
http://img357.imageshack.us/img357/7374/diagramjv9.th.gif (http://img357.imageshack.us/my.php?image=diagramjv9.gif)
In basic terms, the contract table has basic contract info, resources can be assigned to a contract (via the Assign table) and we feed in exchange rate info also from another table.
Everything is so slow as soon as I put the BE on a share drive. I have done everything I can think of, I have changed to tlookups, I have changed the Auto options as recommended, analyse shows no issues, compacted the DB. It is unusable!
I notice on one form that it takes 1 second to calculate a field. The field basically uses a tSum to find the total cost of a contract (looks up assign to sum up all the attached resources). This seems to slow it down, but it does not explain the huge time it takes to load up.
I am considering that the issue may be down to the share where it is being located has too high latency (it is in another country, and it feels slow browsing through it)
Any other general ideas, or do you need more info?
Thank you.
View Replies
ADVERTISEMENT
Oct 3, 2006
I've just made a major mistake....
On messing about with my start up settings i have managed to lock myself out...!!! what a ****!!
how do I / where do I look to reverse these??
Please help
View 7 Replies
View Related
Aug 14, 2005
Platform: Windows XP - government network
The government recently went through a migration of all networked directories to a central repository -- that was in June. I recently discovered that one of my database users, who happened to be working from home that past month, was not migrated properly.
Problem. The home user was still entering projects into the non-migrated location, while the users at the office, are entering data into the new location. Therefore major information is not showing up.
Need to urgently pull the project data into the current database.
But, I cannot simply import this data because it will wipe out the data I've entered into this table.
Any ideas would be greatly appreciated. Thanks in advance. Barb
View 4 Replies
View Related
Jun 14, 2006
Hi all,
Yesterday my database crashed. It is the 'DEV' version for my application - so all of the current fixes/changes are in there and I have forgotten to backup!
It crashes when ever I try to enter the VBA editor, or build code. This occurred after a minor problem running some code (I forget which code).
Here is the error signature -
AppName: msaccess.exe AppVer: 11.0.6566.0 AppStamp:42cdb33e
ModName: vbe6.dll ModVer: 6.4.99.72 ModStamp:40b29ba6
fDebug: 0 Offset: 0008baa8
The same occurs when I try to get into the code builder in the repaired version access generates...I have also tried using compact & repair to get in - but still no joy.
Can anyone offer any advice workaround to get this up and running again?
Cheers
Robert
View 1 Replies
View Related
Aug 28, 2004
I'm trying to write a database for work (accounting firm).
I would like to start out with about 5 tables.
1) Client Information: Would include name, phone, etc and a
field that stated what kind of client (F/S or Tax).
2) F/S Tracking: Would include name and date in, date started,etc.
3) Tax Tracking: Would include name and date in, completed, submitted to gov.
4) Employees: the names of the firms employees.
5) Job Jar: Would include employee name, and which client(s) they should work on.
What I need help with is the data entry form for the Client information.
I would like to have it so I only enter the Client Name once, and only once, and not only
will it update the client name field in the Client Information table, but the corresponding field in
the F/S Tracking table (if the client type in the Client information table = "F/S") and the Tax Tracking
table (if the client type in the Client information table = "tax").
I have tried to use an update query that runs when the Client information form is closed but I think I might be doing it wrong, because I always get the message that 0 (ZERO) records will be updated.
Any help would be appreciated.
Thanks
Mitch Miller
View 3 Replies
View Related
Sep 30, 2005
Hey guys,
This is my problem!! I have created a Macro, using sendobject to send an email once the database has been opened. The email is to contain a copy of a report which i have specified in the macro.
On opening the database, a box appears with "Microsoft Office Outlook" on the top. The box says:
" A program is trying to automatically send email on your behalf.
Do you want to allow this?
If this is unexpected, it may be a virus and you should choose no."
Then there are three buttons with yes, no or cancel on the bottom.
First question is why is this appearing and is there a way around it, and secondly, when i click on yes, i dont recieve an email and no buttons appear on my switchboard!!!
Any ideas guys??
View 1 Replies
View Related
Oct 7, 2006
I use MS Access a lot for my work but a few days ago when I opened Access it asked for a username and password. I didn't set anyway passwords so tried to log on using the username: admin and a blank password which didn't work. I have tried every username and password combination that I could have used but nothing seems to work.
Is there anyway for sorting this out so that I can use Access again?
View 1 Replies
View Related
Mar 6, 2007
Hello Forum,
I have a problem with duplicate records in my query. I know why the duplicate records are occuring and I have spent a ridiculous amount of time trying to fix the problem, but I'm really at a lost and am quite desperate for some help.
Here's some background info that shows the cause of the problem:
I have two tables. In the first table (tblMainData), there are three columns of interest (P1, P2, & P3). The second table (tblGroupList) has two columns (PN & GroupList). A relationship exists such that the data in "PN" is parital-text values of the data in columns "P1", "P2" and "P3".
For example, "P1" in tblMainData may contain "A1235XX". The "A1235" is what's important, so that's one of the values that I have in "PN".
Continuing, I have a user form that uses the "GroupList" field as the RowSource for one of my combo boxes (cboGroup), and this field contains an (ALL) option. So, when a value is selected from cboGroup, I use the following Criteria filter
Like [PN] & "*"
in my query (qryFilterGroup) to look for those partial text fields that match what's in fields P1, P2 and P3. The results are then shown in a subform.
Here-in, I believe, lies the source of the duplicate records. In my userform, if "(ALL)" is selected under the cboGroup combo box, a new record is created for each field P1, P2 and P3 in tblMainData that contains data and that is related to the partial text matching Criteria. A new field is created because each field corresponds to one of the values in the "GroupList" field.
This is really difficult to explain, and I don't really know if I should continue without writing a book. If someone or someone(s) could be so kind, please have a quick look at my attached database as it's obvious to see my problem. Any help is greatly appreciated!!
View 3 Replies
View Related
Jul 12, 2006
I recently found a need to pass a message on to everyone that opened a certain access database. So in I thought the easiest way of doing this would be to use the startup page & macro on the Northwinds Sample Database that comes with access.
However, I kept getting an error because the ok button was pointing the main switchboard which doesnt exist on my database, so I tried deleting the following to see if it would sort the problem: -
' Closes Startup form.
' Used in OnClick property of OK command button on Startup form.
DoCmd.Close
DoCmd.OpenForm ("Main Switchboard")
Now I think I've made things a whole lot worse. When I opne the database I get that first startup form and of course the button doesnt work and everything else is disabled.
I could really do with some help on this one.
Thanks,
Marc.
P.s. Cracking forum guys, if it weren't for places like this people like me would be in a whole world of ****!!
View 4 Replies
View Related
Nov 14, 2004
I am so interested to see a solution to this little problem…i think ithis is one of my more complicated questions!!!!
Problem:
Where I work we have a series of machines… named “ C1, H7, H8 etc”
Each line has 3 counters on it,
Impressions – records the number of cartons used on the line
Standard Pack – records the number of filled cartons with product
Output – records the number of cartons that complete the whole line process and are ready to be shipped to the customer.
Sounds straight forward enough….but the process gets a little more complicated.
Some lines are referred to as joint lines… this indicates that the product from each line the output figure is joined together and totalled. So it is not possible to calculate how many each line completed for the output figure. Note… it is only the Output figure that is joint, each line still has it’s own impressions and standard park counters
Grouped lines are given a group code – P8 in this case.
Example…
C1 not joined
H7 and H8 joined.
C1 –
Impressions –1000 Cartons
Standard Pack – 900 Cartons
Output – 800 Cartons
H7 - P8
Impressions –1600 Cartons
Standard Pack – 1500 Cartons
H8 – P8
Impressions –400 Cartons
Standard Pack – 300 Cartons
P8
Output – 1600 Cartons
The output counter is brought in to the database automatically via a linked spreadsheet and a macro, this data is then stored in a table called “DaycodeMachineShiftImpressions” you will see in this table that the grouping is referred to as Machine.
As previously stated we have no real way of working out the amount each line has output individually.. the way it is calculated at the moment, is to take the figure for P8 and split it into 2 equal figures and assign that to each line.
So in this case the figure assigned to each line would be 800, although you will see that this is not possible for H8 line as it only put 400 cartons on the line in the first place.
I now want to implement the following calculation to my DB,
(see Attached Spreadsheet)
the calculations a re stored in cells b12 & b13 in the spreadsheet.
so that the output figure is separated
in proportion to impressions made.
I then need the figure per line to be fed back to the “tblProduction” output field..
in the tblproduction the data for P8 is stored to line level so in this case as H7 and H8, hence why i want to use the calculation to work out the output figure per line...
Can this be done automatically, if so please help me…
Andy
View 2 Replies
View Related
Nov 14, 2004
I am so interested to see a solution to this little problem…i think ithis is one of my more complicated questions!!!!
Problem:
Where I work we have a series of machines… named “ C1, H7, H8 etc”
Each line has 3 counters on it,
Impressions – records the number of cartons used on the line
Standard Pack – records the number of filled cartons with product
Output – records the number of cartons that complete the whole line process and are ready to be shipped to the customer.
Sounds straight forward enough….but the process gets a little more complicated.
Some lines are referred to as joint lines… this indicates that the product from each line the output figure is joined together and totalled. So it is not possible to calculate how many each line completed for the output figure. Note… it is only the Output figure that is joint, each line still has it’s own impressions and standard park counters
Grouped lines are given a group code – P8 in this case.
Example…
C1 not joined
H7 and H8 joined.
C1 –
Impressions –1000 Cartons
Standard Pack – 900 Cartons
Output – 800 Cartons
H7 - P8
Impressions –1600 Cartons
Standard Pack – 1500 Cartons
H8 – P8
Impressions –400 Cartons
Standard Pack – 300 Cartons
P8
Output – 1600 Cartons
The output counter is brought in to the database automatically via a linked spreadsheet and a macro, this data is then stored in a table called “DaycodeMachineShiftImpressions” you will see in this table that the grouping is referred to as Machine.
As previously stated we have no real way of working out the amount each line has output individually.. the way it is calculated at the moment, is to take the figure for P8 and split it into 2 equal figures and assign that to each line.
So in this case the figure assigned to each line would be 800, although you will see that this is not possible for H8 line as it only put 400 cartons on the line in the first place.
I now want to implement the following calculation to my DB,
(see Attached Spreadsheet)
the calculations a re stored in cells b12 & b13 in the spreadsheet.
so that the output figure is separated
in proportion to impressions made.
I then need the figure per line to be fed back to the “tblProduction” output field..
in the tblproduction the data for P8 is stored to line level so in this case as H7 and H8, hence why i want to use the calculation to work out the output figure per line...
Can this be done automatically, if so please help me…
Andy
View 5 Replies
View Related
May 1, 2013
I need to know the best way to insert data into the backend without cause major bloating of the backend. I am currently inserting about 20k records at a time using an INSERT INTO statement. The backend went from 83mb to 511mb trying to insert the last 20k records.
View 2 Replies
View Related
May 26, 2006
Hi,
I am absolutely puzzeled with a problem we are having with an Ms Access 2000 application, which is the front end to a SQL Server database. We have a database which was working fine for over 6 months. And now all of sudden users are intermittently getting the error messages:
"Error Executing this command"
AND
"You cancelled the previous operation."
I removed the error handling code from the application to get more detailed error messages and we got the following error message:
The expression On Click you entered as the event property setting produced the following error: .
The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
There may have been an error evaluating the function, event, or macro.
This is only intermittent and when they close the database and open it again it works fine for a little while and then the error occurs again. As you can imagine this is a major inconvenience for users.
I have searched the web and forums and there just seems to be 101 reasons why this could happen. Nothing has changed on our system which might cause this occur so I don't know why this is happening.
Could anybody provide any ideas on how I might go about trouble shooting it. We are thinking of opening a support call with Microsoft but the error messages are so generic that I'm not sure what help they could be.
Any help / ideas or suggestions would be greatly appreciated.
Many Thanks
View 4 Replies
View Related
Oct 25, 2006
Good Morning
Looking for the user to select a product name from a drop down box (not type in) when running query / report which will return details on only that product rather than all others in the query.
I have got major problems with the custom dialog boxes -- have got a table of product names, a query called current stock ( active products) . I can easily get a standard dialog box by putting [product code] in brackets in the query and this is not a problem. However in getting a custom dialog box I have had lots of problems.
Created a form called form999 which has product name field as a combo box and this has been named master1 . Clicking the form on it's own brings up the dialog box correctly and the drop down box selects the current products which is should do.
However linking it to the query I have put [Forms]![form999]![master1] in the query and it will not link unfortunately and is driving me mad.
Upon running the query it simply brings up the standard dialog box with [Forms]![form999]![master1] as the "enter parameter value. Understand code is required to get the OK and cancel macros working etc but when I click the query it should bring up the custom box which is the first stage and it is not ?? Any assistance would be greatly received.
Are there any sample DBs which have a field or related parameter as a customer dialog box -- have looked for examples without success.
many thanks and regards
Ian Watson Yarm UK
View 2 Replies
View Related
Sep 10, 2006
Hi,
Could having two look up queries, one on form an the other on table, and both of them take info from the same field and store it in a different field on a different table slow the DB?
:)
Thanks,
B
View 4 Replies
View Related
Mar 28, 2007
case 1:
Link the SQL Server tables to MS Access (mdb file) - there are 50 concurrent users access in the same file (network share drive).
case 2:
create adp file - there are 50 concurrent users access in the same file (network share drive).
I know if each client has own copy on his local machine, it will not have any problem. But, if we want to put one file only in the sharing drive, then
if either the client or server computer (or the connection between them) fails during the transaction or other operation that writes to the database file,
which case is better to solve?
View 1 Replies
View Related
Jul 24, 2005
Hi everyone
I'm starting a year-long university project which will be written in c#. The client app will be run on a LAN, with 35-40 users accessing the database concurrently, connecting to a database held on the server.
Could anyone tell me if Access can withstand 35-40 users at the same time? I found out that the maximum amount of users is 255, but what kind of performance impact(if any) will there be with 35-40?
I've searched all over the Internet for this, but I can only find references to using access behind a website, which isnt quite what I need. Any help would be great.
Thanks.
View 7 Replies
View Related
Jul 20, 2006
Hi all,
I'm hoping someone can offer me some advice on performance for a FE/BE database that will eventually be accessed by up to 60 people during the same day (usually only 3-4 people searching/writing at same time).
The system is to process complaints at a call centre - built from the ground up and my first true Acess DB application. I have noticed extremely slow times in loading forms - which is a pain considering we are a performance oriented workplace.
FE is on the desktop. BE on the server. Currently it is taking up to 10 seconds to open a form (even when the form contains virtually no information looked up from tables).
Could anyone offer any tips on how to improve performance.
Thanks
Robert :)
View 1 Replies
View Related
Jan 15, 2007
Hi all,
I am work in a medium sized (80-100 people) Government Contact Centre. As some people may know from previous posts, for several months on and off I have been developing a database which could be best described as a 'ticket of work' system for many of our transaction channels.
I am currently rolling out the 'Beta' version of the database, and am noticing some slowdown in performance.
The database is Acces 2K, F/E to B/E X2 (writing to one backend 90% of the time) sitting on one of the networked drives (F/E is local).
I have addressed some of the issues that relate to performance (such as persistent locking of B/E) and am seeking some further advice. Unfortunately, as our I.S department do not support Access use I am unable to seek advice at work.
1. Does anyone know of any tools or methods for measuring database performance?
I am particularly interested in response times and how these are impacted depending on traffic/load. It would be particularly beneficial it there was a tool available that recorded data automatically(eg. in an excel worksheet) for later analysis.
2. A question re: code efficiency. I am primarily using ADO to open and manipulate recordsets. This may be a silly question, but being self taught I have missed lots of the obvious stuff on the way. With ADO, I can either open an entire table, or use an SQL select to open only a specific record. Do the two methods differ with respect to performance greatly (more so from the perspective of other users)?
Sorry about the long post, and thank you in advance for any advice you can offer!
Cheers,
Rob
View 12 Replies
View Related
Sep 27, 2007
I'd like to know whether other users have had performance problems with different versions of Access in a single environment.
In my office, two users are on A2007, and the rest of us are on A2003 or earlier. After some nasty conflicts in the (un-split) database when A2007 and A2003 users were in the same file, I split the database. Now the A2007 and A2003 people have individual frontends. Other than having a garbled LDB file, I haven't had any other conflicts between the two programs.
However, I have had some massively irritating problems ever since I split the database.
1)The Design View on my Front End runs very, very slow (like, five beats after every action to process).
2) If I try to edit one particular, very simple form, it will not return to form view... it is stuck in Design view. (That sounds like the form has been corrupted.)
3) The auto-save doesn't seem to be working... Access (2003) crashed on me yesterday and I lost an hour's work on a new form.
I've tried some of the database construction suggestions to speed performance in other posts - forms based on queries, record locking, short paths, etc., and have seen some improvement in overall performance, but none of these should affect design view. USING the database tends to be speedy-quick.
So, did our dalliance with A2007 mess up my database? Does any one else have experience with this? Or are these symptoms common with a slow network connection (the back end is on a server, front ends are on individual desktops)?
Thanks!
View 4 Replies
View Related
Oct 2, 2006
Bear with me on this one as the query looks a mouthful although it's fairly simple.
I started with the following query, which was working working very quickly and almost instantaneously bringing back results. Essentially, it is a number of nested select statements bringing back data and joining on the first table, Structure, to group and filter the results. I had to do it this way as there are no distinct relationships between the zarinvreg, zarageddebt, or baddebt tables (not 100% anyway).
Attached on SQL_Ok.txt
I then had to add some extra joins in and all of a sudden the query has slowed to 10 seconds. There's nothing particularly heavy about these extra joins but they have a couple of WHERE caluses in them. I tried indexing all the fields in every table in the DB and that didn't help at all.
Attached on SQL_SLOW.txt
Any ideas on how to improve this, some things to try, or why the massive delay in processing ? The same query is pretty fast on SQL Server though...just not Access
View 1 Replies
View Related
Jan 17, 2005
We're going live with a database today, and running through some testing, some of the forms seem to freeze. It's only happened a couple of times, but my question is, what is the best way to distribute it.
At the moment it's just on a location on the network and the users in the team access it directly. Can anyone give me any suggestions. My neck is on the line here...
View 2 Replies
View Related
Oct 10, 2005
I have searched on this forum for other threads like this and in the db examples page, but didn't find anything. I have made a perfomance eval db in MSA 2003. It works fine except for one part. I need to score the individual on about 20 different criteria. Each one ranges from 1-5. I am having problems getting all the entries to sum when I run the report. Should I use combo boxes, check boxes, radio buttons or what? :confused: Then how do I get the individual scores to sum up when I am finished putting them in and run the report to print it? I have looked around the net for a Performance Evaluation template to see how it is done, but couldn't find one anywhere. Microsoft doesn't have one in their list of templates either. If anyone knows where to find one at, I'd appreciate that too. TIA for your help! I appreciate it.
James
View 3 Replies
View Related
Oct 24, 2005
Hi,
Im developing a project database. A normal project will need 10 000 records in the biggest table. Does this effect the performance? I mean, when they have done 8 projects, there will be like 80 000 records in one table. Is this to much? Does this influence the performance very much ?
The database is gooing to be placed on a sequelserver.
thanks for your reply since this is a very importend mather!!!
View 2 Replies
View Related
Nov 16, 2005
:confused:
I have split my database application that was approaching the 20MB size. This I have split into a front end (approx. 8 Mb) with linked tables to a back end database (approx. 12MB).
Network is 100Mb Ethernet.
However, since doing this, end users have noticed that scrolling through records and especially running reports takes significantly longer sometimes 3x/ 4x longer. I understood that splitting the DB would have a beneficial effect from a development / application 'release' point of view and maybe if I were to create an MDE file of the front end, I could also benefit from reduced network traffic given that end users are using a compiled executable etc.
With the speed issues I have been experiencing I have had no choice but to roll back to the original application format with everything in the the one MDB file.
Has anyone else had to do the same - given similar speed degradation issues?
Thanks
Guido
View 5 Replies
View Related
Jan 11, 2006
Last week, my access97 db, with back end and front end, both residing on a network as they have been for the last 2 years, decided to start running at 1/4 of the speed that they usually have. The db is used by 16 users, and roughly 5 are on at any given time (Operating system - XP). Both front end and backend were compressed without any change in performance. No changes in programming or number of records was introduced as of late. Checking with our IT department indicated that the performance of the network and drive have not changed and are up to snuff. I moved a copy of the FE and BE to my hard drive and found performance to return to normal speed, although I am not sure if it always ran faster on a PC. Any experience with this irregularity and options to check would be greatly appreciated?
View 2 Replies
View Related
