473,811 Members | 2,950 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Database opening slowly

Very strange: the same database opens rather fast on one computer and
very slowly on the other computer. Once it is open, there is no
difference in speed, but only opening it takes about one minute.

I have had this problem before, and suddenly (after a few days) the
problem was gone without any sign of the cause. But now it seems to
stay...

I use Access 97, Jet 3.5, Windows XP and I am running the database on
a local machine, imitating a network using the SUBST command.

Thanks in advance!

Roel Schoonveld
Nov 13 '05 #1
2 1216
If you haven't already, obtain the most current Service Release for Office
97 and install it on the slow-access-booting computer.

http://www.microsoft.com/downloads/d...displaylang=en -
Download details: Office 97 Service Release 2b (SR-2b) Download Information

Once you have run this service release pack and rebooted the machine, try
booting up the database and see if it still gives you this trouble.
"Roel Schoonveld" <ro**@schoonvel d.com> wrote in message
news:c6******** *************** ***@posting.goo gle.com...
Very strange: the same database opens rather fast on one computer and
very slowly on the other computer. Once it is open, there is no
difference in speed, but only opening it takes about one minute.

I have had this problem before, and suddenly (after a few days) the
problem was gone without any sign of the cause. But now it seems to
stay...

I use Access 97, Jet 3.5, Windows XP and I am running the database on
a local machine, imitating a network using the SUBST command.

Thanks in advance!

Roel Schoonveld

Nov 13 '05 #2
"ByteMyzer" <sb*@nospam.new s.chi.sbcglobal .net> wrote:
If you haven't already, obtain the most current Service Release for Office
97 and install it on the slow-access-booting computer.

http://www.microsoft.com/downloads/d...displaylang=en -
Download details: Office 97 Service Release 2b (SR-2b) Download Information

Once you have run this service release pack and rebooted the machine, try
booting up the database and see if it still gives you this trouble.


I'd also ensure Jet 3.5 SP3 is on both computers as well.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
4303
by: Mehmet Gunacti | last post by:
Hello, on our homepage, when pressing an anchor tag, a special sized popup window opens via javascript. but it opens very slowly. on other web pages, there are also javascript-opened windows, but they load very very fast, within 2-3 seconds. i tried several things such as :
14
7147
by: L Mehl | last post by:
I tested a FE/BE application developed in A2000 on a A2002 machine and got this message when exiting the app. Clicking the only available button "OK", exits the application, as intended. The FE is just the mdb, not an mde. FE and BE are in different directories on the same machine. Are there settings, preferably via code, that I can add to stop this error? Thank you for any help.
4
1937
by: Niranjan | last post by:
I have an Access XP split application operating on Windows XP. I have a form that opens on Startup that opens the backend database and keeps it open until the application is closed. For the first user to open the application it takes about 30-40 secs which is acceptable. But for the 2nd user onwards it takes about 1.5 - 2 minutes which is not acceptable. What can I do to open the application faster for the second user onwards. I have...
26
10891
by: Bruno Jouhier [MVP] | last post by:
I'm currently experiencing a strange phenomenon: At my Office, Visual Studio takes a very long time to compile our solution (more than 1 minute for the first project). At home, Visual Studio compiles the same solution much faster (about 10 seconds for the first project). My home computer is only marginally faster than the one I have at the office (P4 2.53 vs. P4 2.4, same amount of RAM). On the slow machine, the CPU usage is very low,...
3
2132
by: Marvinq | last post by:
I am working on an Access 2002/Oracle vba automated overnight process. The problem is there is one user with rights to a certian set of tables and another user with a certain set of tables. I can't run the overnight process with just one login. Currently, I am having problems with relogging into the database with a different login. Even when I enter a different userid and password into a connection string, the system seems to still use...
3
10299
by: Martin B | last post by:
Hallo! I'm working with C# .NET 2.0, implementing Client/Server Applications which are connecting via Network to SQL-Server or Oracle Databases. To stay independent from the underlaying Database I use System.Data.Common.DBConnection and .DBCommand. How can I keep aware from connection losses (network not availeable, db-server not available...)? Are there any strategies to detect this broken connections, and how can I
1
1978
by: Robert Hooker | last post by:
Hi All, After moving to VS2005, we've noticed that opening an existing (large) solution and being able to type code takes a lot longer than in VS2003. Typically, the IDE will open, and all the windows will appear, but then the hour glass will flick on and off for about 1 minute. If the "Pending Checkins" window is open, I can see a message that says "Updating. xxx file(s) to process" with the 'xxx' portion slowly counting down from 800...
3
5234
by: Suresh P | last post by:
Hi All, I tried to access the mysql database in ODBC using ip address and username/password. It returns, "cannot connect to MySQL server on IP ADDRESS(10060)". This could be related to Firewall on the server. Is there anyway to access MySQL database using ODBC without opening port 3306?
2
1411
by: thomkola | last post by:
My lap top was functioning very good. But for the last two days after booting the machine if i click on any desktop ikons it takes lot of time to open the programmes. but recyle bin and my computer and all opening as usauall. I can see my hard drive indicator blinking slowly . I am using avast anivirus and spy bot search and destroy. i connect to internet using a hewaui wireless modem. kindly help me
0
9607
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,...
0
10395
jinu1996
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...
1
10408
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,...
0
10137
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7674
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6895
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();...
1
4352
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3876
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3027
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.