473,569 Members | 2,598 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Slow Down

74 New Member
Question. I am currently running Access with one to seven people on it at any given time. We are tracking alot of information from. however the system is starting to slow down. I have indexed several items and have moved most all the macros to VBA...

What else can i do to speed this up? it is saved as an MDE and slpit data base.
would going to some sort of server be the solution?
Aug 20 '07 #1
6 1995
MMcCarthy
14,534 Recognized Expert Moderator MVP
Question. I am currently running Access with one to seven people on it at any given time. We are tracking alot of information from. however the system is starting to slow down. I have indexed several items and have moved most all the macros to VBA...

What else can i do to speed this up? it is saved as an MDE and slpit data base.
would going to some sort of server be the solution?
If the database is split front-end/back-end and the front-end is an mde you shouldn't be getting this kind of slow down. Are you running compact and repair on a regular basis?

Mary
Aug 21 '07 #2
Hutch
74 New Member
If the database is split front-end/back-end and the front-end is an mde you shouldn't be getting this kind of slow down. Are you running compact and repair on a regular basis?

Mary
Ya probably a few times a week. My front end is 103,620 KB and my back end is 7,620 KB. I'm not sure if this is big or not? I only have expreiance working with this data base.
Aug 21 '07 #3
MMcCarthy
14,534 Recognized Expert Moderator MVP
Ya probably a few times a week. My front end is 103,620 KB and my back end is 7,620 KB. I'm not sure if this is big or not? I only have expreiance working with this data base.
No 103 is average. You would have to be hitting upwards of 2 GB to be having problems.

What version of Access are you using? Could the problem be with the Network?
Aug 21 '07 #4
MGrowneyARSI
90 New Member
do you have picures for the background of the forms if so take them out I find they can slow an msadb down alot otherwise i have no more geusses just set it to compact and repair on close
Aug 21 '07 #5
Hutch
74 New Member
No 103 is average. You would have to be hitting upwards of 2 GB to be having problems.

What version of Access are you using? Could the problem be with the Network?

It might be, that would be out of my leage, But other then that nothing comes to mind?
Aug 21 '07 #6
MMcCarthy
14,534 Recognized Expert Moderator MVP
It might be, that would be out of my leage, But other then that nothing comes to mind?
Without seeing the actual application there is no way to know for sure but you can have up to 255 concurrent users so you shouldn't be having a problem.
Aug 21 '07 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

9
3442
by: j askey | last post by:
I have a strange bandwidth issue that I have finally tracked down to something fairly specific if anyone has any ideas... Setup: Win2003 Server, PHP 4.3.4, IIS6.0, ISAPI Network: DSL line with a Cisco 678 router using NAT and static port maps. Two switches between webserver and Cisco. Problem: Accessing PHP driven site via any computer...
12
2619
by: Neil | last post by:
I previously posted re. this, but thought I'd try again with a summary of facts. I have an Access 2000 MDB with a SQL Server 7 back end. There is a view that is linked to the database via ODBC and has been in place for several years without any performance problems. Recently I added a couple of fields to the output of the view, and it...
18
3058
by: Mark P | last post by:
I have a bit of vb code that uses Tables.Append to programatically link tables from Oracle and DB2 datasources. The problem I am having on some client machines is that the link will take anywhere from 1 to 3 minutes to link the table. When I manually link the tables,through Access, it takes no time at all. Note that only certain client have...
6
1236
by: WebBuilder451 | last post by:
Has this happened to anyone here? I first thought that it was a Vs.net problem but i now see it take a good min. to load an html page. The aspx pages load very slowly in vs.net, but i think this is related to iis slowing down. Any Help would be appreciated. thanks kes -- thanks (as always) some day i''m gona pay this forum back for all...
29
2105
by: Geoff Jones | last post by:
Hi All I hope you'll forgive me for posting this here (I've also posted to ado site but with no response so far) as I'm urgently after a solution. Can anybody help me? I'm updating a table on a database i.e. I've modified the table in a DataSet and I want to update it to the SQL database which the table originally came from. I'm using a...
0
2080
by: TD | last post by:
I have a combobox that is sometimes slow to drop down when clicked on. If you select an item in the list that is near the top of the list then the next time you click on the combobox it drops down fast for you to make another selection. If you click on an item from the list that is way down the list then the next time you click on the...
3
2189
by: UJ | last post by:
I had somebody (who was an idiot) tell me that tables are slow in rendering? That you shouldn't do things like tables inside of tables. Is that true? I think she didn't know what she was talking about but I just wanted to confirm with people. TIA - J.
23
5262
by: PeterOut | last post by:
If I had code like this. unsigned short usLimit=10 int a, i; for (i=0; i<(int)usLimit; ++i) { a=(int)usLimit; }
3
2123
by: John | last post by:
Hi I have replaced an ms access app with its vb.net version at a client site. Now the clients keeps complaining about how slow the app response is. The complains they have are for example when app is minimised and then trying to maximise it after a while takes a while for app to get maximised. Also form painting of controls is slow and app...
10
2335
by: penworthamnaynesh | last post by:
Does php slow your website down? This is what i would like to know.The reason is because my site is writtent 50% in html and 50% in php and is very slow at loading. And i cant tell wether php is doing it or html o is it another reason because i only have 20gb bandwidth My site is called : ultimate city the game http://www.ultimate-gamez.net
0
7700
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7974
tracyyun
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...
0
6284
agi2029
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...
1
5513
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5219
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...
0
3653
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...
0
3642
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1221
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
938
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.