Access 2007 Import

S

StanL

I use to be able to import an Excel file into a table in Access 2007 now I
always get a warning message "Because of your security settings and current
security policy, this control is disabled. To modify your policy and enable
the databsae, use the Message Bar." I have no restrictions in the trust
center settings and all of a sudden the message bar never displays. I have
tried everything I can think of but with no success including removing office
2007 and reinstalling. I think my registry must be corrupted somehow. Any
thoughts?
 
S

StanL

Issue Resolved...
I did a compact and repair on my database it the import function now works.
I do not understand this as I created a new database and tried to import and
had the same problem. Must be something to do with 2007 security center.
 
P

Pete D.

Acctually it is an option in the trust center. Look at Showing the message
bar in the trust center. Dead give away is you created a new database so
your default options changed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing SSNs from Excel into access 2007 and using as primary ke 1
import in Access 2007 9
Trust Center - Trusted Locations are greyed out 0
Trust Center - Trusted Locations 0
Importing Access XP into 2007 possible? 5
Outlook Outlook 2007 Application_ItemSend and Application_NewMail() event not firing 0
Add import export file extension in Access 2007 1
Access 2007 import failure 4

Top