Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.
Course Of The Month
4 days, 5 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
error message on opening ms access
Posted on 2015-01-06
hi
i have office 2007 , windows 8
when i open any access file , error message appear
as the attached
err.docx
i have office 2007 , windows 8
when i open any access file , error message appear
as the attached
err.docx
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
6
5
4- +1
18 Comments
Active 7 days ago
When did this error first start appearing?
...make sure that the code compiles
I see that you are running an Access 2000 format db under office 2007, ...so you might have some VBA reference issues here, ...I am sure another Exert can help with that...
...make sure that the code compiles
I see that you are running an Access 2000 format db under office 2007, ...so you might have some VBA reference issues here, ...I am sure another Exert can help with that...
Active today
Office 2007 requires the file to be in a Trusted Location, so be sure you've set that up on the machine. To do that, open Access, then click File - Access Options - Trust Center, then click Trust Center Settings - Trusted Locations. You can add the Trusted Location from there.
To check references, open the VBA Editor and click Tools - References. If any are marked MISSING, post back here and let us know. Note that you must do this on the machine where you're having trouble.
To check references, open the VBA Editor and click Tools - References. If any are marked MISSING, post back here and let us know. Note that you must do this on the machine where you're having trouble.
Active 7 days ago
Again,
1. When did this error first start appearing, ...
(It may have been cause by a Windows update...)
2. Does the code compile?
Is this an issue on all machines?
Try the old standbys:
Run the compact/Repair utility
Create a blank new database and import all the objects...
As a very last resort you may have to Repair/Reinstall Office...
But lets see what other Experts may say first...
JeffCoachman
1. When did this error first start appearing, ...
(It may have been cause by a Windows update...)
2. Does the code compile?
Is this an issue on all machines?
Try the old standbys:
Run the compact/Repair utility
Create a blank new database and import all the objects...
As a very last resort you may have to Repair/Reinstall Office...
But lets see what other Experts may say first...
JeffCoachman
Active today
As Jeff said - you need to give us more details. When does the error occur - do you click a button, or does it occur as soon as you open the database? Could code on a Form be causing this issue?
Was this database working previously, and this behavior started suddenly?
If it was working - was it working on the SAME machine where you're now experiencing troubles?
Was this database working previously, and this behavior started suddenly?
If it was working - was it working on the SAME machine where you're now experiencing troubles?
Active today
White-Paper----Upgrading-to-Access-2007-Try opening the database by clicking the file name while holding down the Shift key (you may have to do this a few times). That will bypass any startup code or form. The reference in the error message to an ActiveX control might indicate that you have an ActiveX control (or a version of one) that isn't supported in the current environment (though maybe not; Access error messages sometimes point in the wrong direction). If you have the old CommonDialog control, that might well be the culprit. It has mostly been replaced by the FileDialog object in recent versions of Office.
Try Jeff's suggestions; one or another of them often fixes mysterious problems. Also, you might want to upgrade the database to a more recent format. I am attaching a document with some information on changes that might need to be made when upgrading a database.
Try Jeff's suggestions; one or another of them often fixes mysterious problems. Also, you might want to upgrade the database to a more recent format. I am attaching a document with some information on changes that might need to be made when upgrading a database.
Active 7 days ago
I'm receiving this error when I upload from some sites , but from my own filed I face no problemPlease clarify:
Upload or Download?
On occasion downloaded Access files (or any downloaded file, for that matter) can get corrupt, ...try downloading the file again.
Are all the files downloaded form a particular site having his problem?
If so, you may wish to contact the webmaster for this site, and verify the integrity of these files.
JeffCoachman
Active today
I'm receiving this error when I upload from some sites , but from my own filed I face no problemWhen you download what? Can you explain what you mean by this?
Active today
Your original question said you got the error when opening an Access database, but now the issue appears to be downloading. Is the database one that you downloaded (from where?), and does the error appear when selecting the database to download, or when opening it?
actually , i'm downloading files from one site , learning site , when i open some of them (opening startup up form ) , it occure the error
please just check the attached file , and give me your feed back
UUU4.zip
please just check the attached file , and give me your feed back
UUU4.zip
Active today
I downloaded the database, and found that the error has something to do with the frmKM form. I made a new form, and copied objects to it from the original form, and cleaned up the code that synchs to a selected record (using a combo box instead of a free-form textbox, so only correct numbers could be chosen). The test form opens without error, but when I select a value from the combo box, I get the error again. This database has Arabic (I think) text, so presumably it was created for an Access version for an Arabic-speaking country. Maybe the problem has something to do with that. I think you may need to recreate the database from scratch (it has only a few objects, so this wouldn't be much of an issue).
I am attaching the modified database, in case the code on the test form is of use to you.
HBF-Modified-UUU3.accdb
Also, consider normalization. If this is a database for storing client orders, the Northwind sample database is a good reference. See my recent Access Archon article #238, which has several one-to-many forms based on the Northwind tables. here is a link for downloading it:
http://www.helenfeddema.com/Files/accarch238.zip
and here is a Customers and Orders form:
I am attaching the modified database, in case the code on the test form is of use to you.
HBF-Modified-UUU3.accdb
Also, consider normalization. If this is a database for storing client orders, the Northwind sample database is a good reference. See my recent Access Archon article #238, which has several one-to-many forms based on the Northwind tables. here is a link for downloading it:
http://www.helenfeddema.com/Files/accarch238.zip
and here is a Customers and Orders form:
YES helen
thanx for your help
actually you are correct , the text in arabic
what i'm doing is i'm supervisor for one learning site , i'm downloading files of members whom they are asking questions via forum about their problems , but mostly i'm facing this problems when opening their files such this
so it is so difficult to always copy the forms again
thanx for your help
actually you are correct , the text in arabic
what i'm doing is i'm supervisor for one learning site , i'm downloading files of members whom they are asking questions via forum about their problems , but mostly i'm facing this problems when opening their files such this
so it is so difficult to always copy the forms again
Active today
I think that the first thing to do with this database is normalize the tables in a one-to-many relationship, then create a form with a subform, the main form being bound to the "one" table, and the subform to the "many" table. Tabbed forms are great for many purposes, but in this case (if I understand it correctly) a form with a subform would be better.
thanx
but sorry again
this case not only for this database , it is with most files i downloaded from member questions
every day i'm downloading around 6 -. 7 files like the one i attached
should i adjust every file i downloaded ?
but sorry again
this case not only for this database , it is with most files i downloaded from member questions
every day i'm downloading around 6 -. 7 files like the one i attached
should i adjust every file i downloaded ?
Active today
If you're getting the same error on all files, then the first thing I'd do is make sure your Office and Windows installations on your machine are fully up to date.
If that doesn't work you may need to uninstall and reinstall Office.
After that, if you continue to get errors when opening the files you're downloading, then it's possible the files that are uploaded have troubles. In general, if you can "fix" the file (i.e. compact/repair), then the fault lies with that file, and not with your installation of Access. The uploading process can sometimes cause issues, so take a look at that as well.
If that doesn't work you may need to uninstall and reinstall Office.
After that, if you continue to get errors when opening the files you're downloading, then it's possible the files that are uploaded have troubles. In general, if you can "fix" the file (i.e. compact/repair), then the fault lies with that file, and not with your installation of Access. The uploading process can sometimes cause issues, so take a look at that as well.
Featured Post
ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Suggested Courses
Course of the Month4 days, 5 hours left to enroll
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.