Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / June 2007

Tip: Looking for answers? Try searching our database.

Error Messages - GRRRRR

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Melissa - 22 Jun 2007 17:39 GMT
I have Access 2003 and our school database is on it.  I downloaded McAfee
anti-virus and then we had two power outages two days ago.  Ever since, I
cannot access anything.  I keep getting this "there was an error executing
the command".  What is that?  I am not Access literate so any help would be
appreciated!

I put the office 2003 disk in and hit repair office applications and that
did not work either.

Thanks!
Mel
Jerry Whittle - 22 Jun 2007 18:02 GMT
At times like this, nothing beats a good backup.  In fact make a complete
backup of your database now and put it away for safe keeping.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

I'm assuming in the above that the database file is corrupt. It's also
possible that your PC was messed up with power outages. You may need to
uninstall and reinstall Office. I had one case where we wiped the hard drive
and started over from the computer's recovery disk. In another case it was
just easier to buy a new computer.
Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> I have Access 2003 and our school database is on it.  I downloaded McAfee
> anti-virus and then we had two power outages two days ago.  Ever since, I
[quoted text clipped - 7 lines]
> Thanks!
> Mel
Tony Wickernark - 24 Jun 2007 06:20 GMT
at times like this; nothing beats SQL SERVER

Accesss MDB is a piece of crap database

I mean seriously get real kids

ADP uber alles

> At times like this, nothing beats a good backup.  In fact make a complete
> backup of your database now and put it away for safe keeping.
[quoted text clipped - 29 lines]
>> Thanks!
>> Mel
aaron.kempf@gmail.com - 25 Jun 2007 01:38 GMT
CORRECTION

at times like this; nothing beats Access Data Projects

you wouldn't have data corruption if you used a real database

On Jun 22, 10:02 am, Jerry Whittle
<JerryWhit...@discussions.microsoft.com> wrote:
> At times like this, nothing beats a good backup.  In fact make a complete
> backup of your database now and put it away for safe keeping.
[quoted text clipped - 28 lines]
>
> - Show quoted text -
John W. Vinson - 22 Jun 2007 18:24 GMT
>I have Access 2003 and our school database is on it.  I downloaded McAfee
>anti-virus and then we had two power outages two days ago.  Ever since, I
>cannot access anything.  I keep getting this "there was an error executing
>the command".  What is that?  I am not Access literate so any help would be
>appreciated!

At what point does the error occur? When you're opening Access, opening the
database, trying to do something in the database?

Try going to Start... All Programs... and navigate down to msaccess.exe (you
might need to do a Search in Windows Explorer instead). See if you can open
Access without opening ANY database - that will at least narrow down the
possible problems.

            John W. Vinson [MVP]
missinglinq - 24 Jun 2007 11:40 GMT
It sounds as if Aaron Kempf is ranting under a new name!

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.