I have two databases, one is much larger than the other, but both have the same start up code. The larger database opens quickly, but the smaller database takes forever. I tried compacting and repairing the front end and the back end of the database, but that did not help. Any ideas on how I can speed this up?
View RepliesI have a very simple table with about 20 fields. The thing is it has about 360,000 records in it. It has always been a little slow to open, although using a query works pretty fast. There is just this one table, no forms, no reports, no saved queries. Simple database with one table, but it takes forever to open now, seems to have gotten worse. I have compacted and repaired many times and it does not help. The database is stored on a server.
When I click to open the table up it says RUNNING QUERY at the bottom of the screen and then runs and runs for a LONG time. I cannot rely on queries since we want to keep this real simple for users of this data. Just go in, do a FIND or a FILTER and that is it.
Any idea why this is running so slow, or why it says RUNNING QUERY when I attempt to open it, is that normal?
Thanks.
Hi,
I have a database here that is run by users who use either Access 2002 (XP) or Access 2003.
I have noticed something which to me seems odd and dunno if any of you guys could explain why or how to resolve it?
If one of the 2002 users opens the database it opens fine first time (I use 2002 myself for development) however if a 2003 user opens it it can take 30s+ to open, but then if they close it it will re-open in just a couple of seconds like for the 2002 users.
However if a 2002 user opens it once a 2003 user has just closed it they will then take 30s or so to open it, but then again if they close and re-open it's almost instant.
Is that normal?
Incidentally office 2007 doesn't seem to suffer from this, but it's dead slow at running the database anyway so I'm not going down that route for the forseeable future!
Thanks in advance for any input!
I did try the recommended method of searching this forum using google but it didn't seem to work for me:(
I have a form. It has about 75+ bound text boxes, and about 25+ unbound text boxes that calculate values. And about a dozen command buttons. The code behind all this mess prints off in about a dozen pages.
Everything works. BUT, it takes around two or three minutes from clicking to open the form before the form appears. (There is no delay in moving between records.)
If I go into design mode, it takes anywhere from 10 to 20 minutes for it to save changes.
I noticed things really slowed down as I started copying controls.
Is there anything I can do to speed up this monster?
David
Hi,
I have a database for booking equipment in and out.
I have the backend stored on a shared drive on our LAN, and the front end on each client machine.
The database has been working fine until just now, it runs very slow and my DCount functions have stopped displaying data.
I have no idea why this has happened, please help?
This problem is driving me nuts!!
I`ve just spent a fair few months creating a database to be used by our sales team, I`ve about finished it and came to trial it with the sales manager. When he is using the database at the same time as me it becomes slow.
The design has a front end with all the queries, forms etc and a back end on a server containing the tables.
The database was created using Access 2000 and was designed to replace a similair db created on 97 which has a decent speed on the network.
The other strange thing is that one particular macro that I`ve been using for the speed tests runs quite slow (about 3 secs) when 2 pcs have the db open but once the macro has run if it is run again it takes typically less than a second to run.
What would cause a db to run a macro at different speeds after they`ve been run once? I`ve tried everything I can find on the net to try and improve the speed to no avail.
Help please!!
Hi everybody,
I have an access database which is around 40 MB after compacting it and I feel that it is slow especially when I open cross table form. Is there any way to speedup the databse.
Note: my databse is on the share drive in my work.
The database response is significantly slow when our application requests data over a network. Are there any settings to adjust network response? The network is connected via a T1 line.
According to information I've found online, our application is the front end to the database and the database sits open on the server.
My database is opening much slower than normal just over the past few days. When I run a performance analyzer it is telling me that my database is only being compiled in a partial state. How did this happen and what do I do to fix it??
Thanks...
I am new to access.
On occasion my access database all of a sudden begins to operate very slowly, I notice the queries take a much longer time to run.
Last week it suddenly began to operate very slowly after idling in excess of 30 mins
Today when I change the screen to design view and then back to form view once again it begins to operate very slowly. (yesterday was working fine on my desktop at home, I have not made any changes to the database with exception to saving and using the file this morning on the shared drive at work) If I shut down and re open it operates well but once again changing to design view causes the same issue. Sometimes compact and repair rectifies sometimes not.
I recall reading somewhere (fairly recently) about a parameter or property in Access which is "On" by default and allows a form/query to identify when backend table field names or query arguments are changed and automatically looks for and "fixes" the renamed link. By leaving this switched ON, the database is slower than it could be. The db speed performance can be can be improved significantly by switching this 'feature' off. (i.e. Name of the property)
View 3 Replies View RelatedHi All,
I'm having trouble with access. Basically it has been very slow to load
(over 30 seconds when not opening a database) and when opening a database it just crashes.
Has anyone any idea what could cause this as it worked fine before ?
also would a reinstall help ??
-Elfman
i have a database that runs updates from within itself.what i need is, this database to then open a another database run a update query, then close it.
View 4 Replies View RelatedWhat is the best place to have opendatabase statement ? Currently I have opendatabase in all of my forms. I dont have any modules in my application. I am new to access programming. Is module really necessary in an application?
If I can put the opendatabase statement in one place, it will be easier for me to change the database name and path, if I have to..I dont know how to do it.
Can anyone help..I hope this one should easy for many of you people.
Thanks very much.
Hi,
I've run across a couple issues with our database. The most immediate issue is that I have been unable to open the database on any networked (or non-networked) computer. Me and a assistant typically enter data into this database from two seperate computers. She works on a wireless networked computer with the file on my computers hard drive. I work directly with the file. My computer is wired to the router. (in case that information helps)
We keep getting errors about "cannot access remote computer" and such, they seem to occur when she's entering data and I have the database open, then close Access. It will often give her the error and not allow her to save the record.
But just today she entered something, I closed my database window, then reopened it and I could not get in. All network computers rebooted, and still cannot get into the file. I can enter the password and then it goes to just a blank area (like when your first open access with no database). Older backup versions of the database still work, so it doesn't seem like an Access error. I also noticed that the little "LockFile"s are not being created (I ever faked one just to try it out and it deleted it after i entered the database password)
I can't repair, or convert or anything, it just asks for the password, I give it...and then nothing.
I'm very lost. Thanks for any help.
I have one database and I want the ability to click on a button and open up another database. Can I do that?
View 1 Replies View RelatedI can't open my database...
It was open yesterday and after a power failure computer turned off...
2day I can't open it...
Messege box says something like ---database was open--- not properly closed--- etc. etc. and can't perform auto repair...
I tried to import the objects in other database but can't do that as well...
Is there any way to repair the database???
Thanx and regards,,
MPB
I have problem once each day when I open Access for the first time. I get an error message "Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.". It asks for a file name and insists on compacting (I think) and saving the database. I go through this several times saving it under a diferent name each time until I get the warning "Security warning Some active content has been disabled. Click for details." with a button to disable it.
View 13 Replies View RelatedHello. I haven't seen this before with Access; I've searched the forum and haven't found anything yet...
I have an Access database that was being used by about 9 different people. Everything was going along okay, but one day it became read-only for no reason. Once everyone got out of the DB it said it needed repairing. So with only one person in I ran the repair, but the horror-inducing message "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." appears and when I click "OK" on the message nothing happens whatsoever.
Luckily backups existed, but some data was lost. Is there anyway to run a repair on the database that won't open? Or is it a lost cause?
Thank you! :D
We've got a client that runs two access 97 based databases on their network. up until recently both databases worked
fine on all workstations (all XP Pro).
About 3 weeks ago they called me to report that one of the databases would not load on 3 workstations. It opened
fine on all the others. I checked out the permissions on the database (which is stored centrally on the server) and
everyone had full control.
Within the last week they have added two new xp pro workstations to the domain - neither of which can access the
database in question. they can access the other database no problem - as can all the other workstations.
The occurs as follows:
1. Double click on the icon for the database
2. access 97 loads but does not load the database's interface - instead it opens an empty version of access (with
file menu etc at the top)
3. no specific error messages at all.
4. close access and the standard xp program crash message appears (see screenshots below)
As mentioned above, other workstations can open the database fine.
the only thing that has changed on the network is the installation of some server and workstation based production
software - we have not yet consulted with the company that installed this - we felt that if it was this software
causing the problem then all workstations would be suffering. we wil have to consult with them once we've exhausted
all the possibilities.
Thanks in advance for any advice
http://www.techresource.co.uk/error1.jpg
http://www.techresource.co.uk/error2.jpg
Hello all,
Please help with this:
On opening my database, I have a switchboard that opens up.
How do also run a report automatically just after the switchboard screen opens. To make the switchboard open when I click on my database, I went to tools..> startup. But I don't know how to run a report automatically after that.
Thanks for your help!
I am getting the following Error:
"This database is in an unexpected state; Microsoft access cannot open it.
"This database has been converted from a prior version of Microsoft access by using the DAO CompactDatabase method instead of the Convert Database command on the tools menu. This has left the database in a partially converted state.
"If you have a copy of the database in its original format, use the convert database command on the tools menu to convert it. If the original database is no longer available, create a new database and import your tables and queries to preserve your data. Your other database objects can't be recovered."
The database is on the server. Nothing was changed. Someone in our IT department says they simply opened it and then closed it. I think that they had their access program set to compact and repair on close.
I have tried to import the tables but am gettting the same errors.
I have the original database but it is an old backup that is missing data.
Can someone HELP
I have copied a work database onto my flash drive and then onto my laptop to do some work in it.
Now I can not open the database because it has the error message.
You do not have the necessary permissions to use the database etc...
I have copied the Application file, the Data file and the Workgroup information file and the only one I can open is Workgroup information file. I have tried holding the shift key down as well.
Any suggestions as I have heaps of work to do and I have tomorrow away from work to do it.
Hi,
I created the database, which shared by multi-user. But, my user have a problem to open it. When user1 open the database, user2 cannot open it, I did not remember the error message, it is said that Admin (computer name) prevent you to open the database. But, if the user1 switch another application program (the database file is still opened), user2 can open the database, then both users can access the same database file.
Why do we have this problem? How can I fix it?
I have a user who is having trouble opening a database he created. Here is his description.
I am having an issue with Access that has occurred today and once several weeks ago.
First, I build a complex database for Safeway report. It functions correctly, I can access it from excel.
Problem, I go to update or modify the databases, Access gives me the macro message which I override.
The access database window will not open, no error appears, just a blank access screen with tool bars above.
I have tempted to do a compact and repair of the database which did not help.
Microsoft Online help says the issue can be cause by old Anti Virus Software.
The database will permit excel to pull data from it.
Does anybody have an answer.
Is it possible to open a database from a form in a different database? Not necessary to do so; it would just be handy to do from the form I already have up and looking at rather than having to go open another instance of access and go to that database.
View 8 Replies View Related