Close Macro Action can not run

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I built a new database in Office 2007, but in order for all my employees to
use it, I had to save it as a .mdb instead of a .accdb. Now none of my
macros work. I keep getting these kind of errors for all of the macros I
built : The 'Close' macro action cannot run with the specified 'Save'
argument either when in disabled mode or when called from an embedded macro.
The Error Number is 2950. Can someone please help???
 
Unfortunately, the embedded macros that ACCESS 2007 allows you to create and
use are incompatible with earlier versions, therefore they are "deleted"
(wiped out, removed, as if they were never there) from the database when you
convert it to an mdb file. So there is no way to "fix" the mdb file to
"reinstate" those macros from the accdb file.

You would need to create saved macros in the accdb file before you convert
it to an mdb file. So, you'll need to go back to your accdb file, convert
those macros to saved macros (ones you can see in the Macros section),
assign them to the events in the forms, reports, etc., and then convert it
to an mdb file.

Or you can create those macros in the mdb file that you've already created
from the conversion.
 
Thank you for the help.

Ken Snell (MVP) said:
Unfortunately, the embedded macros that ACCESS 2007 allows you to create and
use are incompatible with earlier versions, therefore they are "deleted"
(wiped out, removed, as if they were never there) from the database when you
convert it to an mdb file. So there is no way to "fix" the mdb file to
"reinstate" those macros from the accdb file.

You would need to create saved macros in the accdb file before you convert
it to an mdb file. So, you'll need to go back to your accdb file, convert
those macros to saved macros (ones you can see in the Macros section),
assign them to the events in the forms, reports, etc., and then convert it
to an mdb file.

Or you can create those macros in the mdb file that you've already created
from the conversion.
Click to expand...
 
Back
Top