Access 2000 on XP

  • Thread starter Thread starter ndennis
  • Start date Start date
N

ndennis

Since installing Access 2000 on WinXP my application will
not close without bringing up the error message to send
to Microsoft. I don't know what the problem is that was
sent. The same application still works on my laptop with
Win98SE.
 
Make sure you installed Service Pack 3 for Office 2000, and Service Pack 8
for Jet 4. Available from support.microsoft.com
 
Thank you for your help. I had already installed SP3, but not the Jet update. So I downloaded and installed as you instructed and the problem still happens. I am almost at tears - I need to be able to work on this application. I would like to use my PC, but I just can't. Do you know of any other way to resolve this issue?
 
There are several things you can do. Firstly, I want to assure you that
A2000 does run okay on Win XP. It is one of the configurations I use, as do
many others.

Now that you have the service packs, let's try this sequence:

1. Make a backup copy of the mdb file, while Access is not running.

2. Open the file, and turn off the Name AutoCorrect check boxes under:
Tools | Options | General

3. Compact the database:
Tools | Database Utilities | Compact

4. Close Access. Decompile it by entering something like this at the command
prompt. This is all one line, and include the quote marks:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\My Documents\MyDatabase.mdb"

5. Compact again.

6. Close Access, and make another copy of the file so you can restore to
this point.

7. Start testing.

8. If it is still unstable:
a) Create a new (blank) database.
b) Turn off Name AutoCorrect.
c) Import everything from the copy at step 6.

You should have a stable database after step 8. Essentially what the steps
do is to cull the corruptions that can creep in as you constantly modify the
database, and then get Access to recreate it from scratch using the JET 4
SP8 engine.

It would also be worth checking that you have the necessary references after
your change to the new o/s. In Access, press Ctrl+G to open the code window.
Choose References from the Tools menu. Deselect any references you do not
need, and look for any of the checked references that have "MISSING" beside
them. More info in references:
http://allenbrowne.com/ser-38.html

Let us know how you go.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

ndennis said:
Thank you for your help. I had already installed SP3, but not the Jet
Click to expand...
update. So I downloaded and installed as you instructed and the problem
still happens. I am almost at tears - I need to be able to work on this
application. I would like to use my PC, but I just can't. Do you know of any
other way to resolve this issue?
 
ndennis said:
Thank you for your help. I had already installed SP3, but not the Jet
Click to expand...
update. So I downloaded and installed as you instructed and the problem
still happens. I am almost at tears - I need to be able to work on this
application. I would like to use my PC, but I just can't. Do you know of any
other way to resolve this issue?
 
I tried almost everything on your last post. The "Name AutoCorrect" was never turned on. The application was already set up to Compact on closing. I did do the decompile as your instructed

The application continues to not operate correctly. Most times I cannot close and a .ldb file is created when I stop Access from running by using "Ctrl Alt Delete"

I did not create a new application and copy all the objects. I started, but here are over 20 queries and maybe slightly less reports

I have almost given up. There is something wrong with my system. I have Office 2000 Small Business Suite and Access 2000 as a separate purchase. Then when I bought my new computer it has Works 2004 Suite that includes Word 2002. Before I came to this site I uninstalled Access 2000 and reinstalled. Then I thought I should reinstall the SP3, but it said that it did not need to install. When I did an about in Access 2000 it said it was SP3

I wonder if I uninstall Office 2000 Small Business Suite AND Access 2000 again and then try to run the SP3 and the Jet8 patch if that would solve my problems. Also, I wonder if I need an Office 2002 SP since Word 2002 is on my new computer. I don't have Word 2002 on my laptop (with Win98)

I also started wondering if the McAfee antivirus on my new computer may be causing a problem. I have Norton on my laptop????

Please help with my suggestions on uninstalling Office 2000 Small Business Suite and Access 2000.
 
ndennis said:
I did not create a new application and copy all the objects. I started, but here are over 20 queries and maybe slightly less reports.
Click to expand...

You can also do a File >> Get External Data >> Import and import all
the objects at once.

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
 
Thank you Tony for your help in how to import all objects. I did as Allen suggested and created a new application and imported all the objects. The application still does not work. Each button that I try says that "you can't carry out this action at the present time". Then the application will not close and I have to Ctrl Alt Delete to get Access to close. Of course, then I get a message to "Send to Microsoft" and an ldb file as well as (sometimes) a dbl.mdb file

I asked my son to try to work with my application on his home computer. He has WinXP Home and Access 2000. The application works fine for him

There is something going on with my system????? I am going to uninstall the McAfee and install Norton 2004. That is a stab in the dark, but I am lost. I was going to change from the 90 day free trial of McAfee to Norton anyway.
 
ndennis, I don't have the complete thread here, but did we check references?

Press Ctrl+G to open the immediate window.
Choose References from the Tools menu.
Any of the checked ones marked "MISSING"?

Note the names of the checked references, and uncheck them. (The Office and
VBA libraries are required, so you will not be able to deselect those.).
Then close the application, and restart.

Open the Immediate window again, and check the references you unchecked
again. Now choose Compile from the Debug menu. Does the application compile?

More information on references:
http://allenbrowne.com/ser-38.html

The other thing to remove is any non-standard add-ins you may have. From the
Immediate window, Add-ins | Add-in Manager.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

ndennis said:
Thank you Tony for your help in how to import all objects. I did as Allen
Click to expand...
suggested and created a new application and imported all the objects. The
application still does not work. Each button that I try says that "you can't
carry out this action at the present time". Then the application will not
close and I have to Ctrl Alt Delete to get Access to close. Of course, then
I get a message to "Send to Microsoft" and an ldb file as well as
(sometimes) a dbl.mdb file.
I asked my son to try to work with my application on his home computer. He
Click to expand...
has WinXP Home and Access 2000. The application works fine for him.
There is something going on with my system????? I am going to uninstall
Click to expand...
the McAfee and install Norton 2004. That is a stab in the dark, but I am
lost. I was going to change from the 90 day free trial of McAfee to Norton
anyway.
 
I checked references and turned off 4 different ones. Then I closed the application and restarted. I checked that the references were still off and then went to the Debug menu and chose compile. Nothing happened.

I do not have and Add-ins in the Add-in Manager

I closed the application again and restarted and again the application will not function. I can open the input form and put data in, but the buttons that have my reports attached will not operate. Then when I try to close I can't close. I have to Ctrl Alt Delete to close

My son was able to run this application on his WinXP Home computer with Access 2000. There has to be something wrong with my system or my installation of Office. I don't think there is anything wrong with the application or it wouldn't work for him and on my Win98 system

I just don't know where to go from here. Thank you for all your help. I may have to pay Microsoft tech support for help or just give up.
 
I have uninstalled McAfee and installed Norton Antivirus software. I also turned off 6 items that were loading on startup. They include, Real Player, Quick Time, Works Update, Acrobat Assistant, MS Office, Music Match

My application works well now. So far no problems.
 
----- ndennis wrote: ----

I have uninstalled McAfee and installed Norton Antivirus software. I also turned off 6 items that were loading on startup. They include, Real Player, Quick Time, Works Update, Acrobat Assistant, MS Office, Music Match

My application works well now. So far no problems
 
Back
Top