|
|
|
Access 2000 on XP |
|---|
| message from ndennis on 23 May 2004 |
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.
|
| Allen Browne replied to ndennis on 24 May 2004 |
Make sure you installed Service Pack 3 for Office 2000, and Service Pack 8
for Jet 4. Available from support.microsoft.com
|
| =?Utf-8?B?bmRlbm5pcw==?= replied to Allen Browne on 27 May 2004 |
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?
|
| Allen Browne replied to =?Utf-8?B?bmRlbm5pcw==?= on 28 May 2004 |
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.
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.
|
| =?Utf-8?B?bmRlbm5pcw==?= replied to Allen Browne on 29 May 2004 |
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.
|
| Tony Toews replied to =?Utf-8?B?bmRlbm5pcw==?= on 29 May 2004 |
You can also do a File >> Get External Data >> Import and import all
the objects at once.
Tony
|
| =?Utf-8?B?bmRlbm5pcw==?= replied to Tony Toews on 30 May 2004 |
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.
|
| Allen Browne replied to =?Utf-8?B?bmRlbm5pcw==?= on 31 May 2004 |
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.
|
| =?Utf-8?B?bmRlbm5pcw==?= replied to Allen Browne on 31 May 2004 |
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.
|
| =?Utf-8?B?bmRlbm5pcw==?= replied to =?Utf-8?B?bmRlbm5pcw==?= on 31 May 2004 |
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.
|
| =?Utf-8?B?bmRlbm5pcw==?= replied to =?Utf-8?B?bmRlbm5pcw==?= on 1 Jun 2004 |
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.
|
| zg replied to =?Utf-8?B?bmRlbm5pcw==?= on 29 May 2004 |
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?
|
|
