Macro Disappears after Database Move

  • Thread starter Thread starter 1genxer
  • Start date Start date
1

1genxer

Ok I have spent hours looking here and online for a solution to my problem
but cannot find one. Hopefully someone can help.

I created a simple database for organizing a movie collection. It has simple
macros to open and close forms, and a macro that allows movies to be loaned
to friends and then returned to the database. This is something I made for my
dad for Christmas as he always complains about us kids borrowing his movies,
and that he doesn't even know what he has.

When I burned the database to a disc and put it on his computer all my
Macros were gone. I wrote the database in Access 2007, but began the file and
saved the file as a 2003 Access file. He uses Access 2003. What has caused
these to disappear (Macro's on still my computer?)? If I put the CD in my
computer the macros are there when I run the files.

Any quick help would be greatly appreciated.
 
Are you talking about embedded macros? They were new to Access 2007. When
you convert to Access 2003 format (MDB), you lose any embedded macros.

You'll either have to switch to "standard" macros or, better, VBA.
 
How would I convert them to standard macros? I don't know VBA so I don't
think I could do that option. Do I just need to re-write each macro and save
it separately? Or, Is there a way to change an embedded Macro to a standard
one?

Thanks for your explanation!
 
Genxer,

You would need to re-create and save each macro to a standard macro or macro
group, and then assign this saved macro to the required event properties.

Because of these types of problems, it is often recommended that databases
be developed using the earliest version of Access that will be used in
practice for the deployment.
 
I was afraid of that. Thanks for all the help though! At least I now know
what the problem was.
 
Back
Top