"you can't carry out this action at this time"

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

I am getting this error every time we have applied a
filter and want to open a form /report i.e. docmd action
I have imported a previous version of the form, repaired
the database recompiled the code and even rebuilt the
database - any ideas?
 
Hi Alan -

There can be several causes to this error message but the most common one is
an invalid reference. Here are some tips:
Check for missing references.

In a new module, choose References from the Tools menu. Look for anything
that says MISSING. If a reference is marked as MISSING, uncheck it and close
the dialog.

You *especially* want to make sure that the reference to Microsoft DAO 3.6
Object Library appears in the list. You may need to go through this process:

Q248790 ACC2000: Invalid DAO Reference Causes Fatal Error in MSACCESS
http://support.microsoft.com/support/kb/articles/q248/7/90.asp

Ensure that the database *doesn't* contain any reserved words. (I've seen
this error message occur when reserved words were used as column names.)

Q209187ACC2000: Reserved Words in Microsoft Access
http://support.microsoft.com/support/kb/articles/q209/1/87.asp

If the report is based on one or more queries, try running the report's
underlying queries by themselves on the "problem" computer.

Hope that helps!
Kristyn Wagoner
Microsoft PSS

Please do not reply directly to this alias. This alias is for newsgroup
purposes only.

This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top