MS Access

[Geekwithaguitar]

This may not be the best location for this thread, but it's 5 am, I've been working on this for almost a day and a half straight, and I'm pure stumped.

For a custom MS Access .mdb program, the database properties are locked out. In order to fix the database (the programmer left the company and won't be reached, the putz) I need to be able to do that. I've tried moving all the forms, reports and tables to a new database, but they all depend on a macro called, appropriately enough, "PCMurphy". So my question is:

a)How do you find a hidden macro in an mdb file, and
b)if I just can't find it ever, how can I concisely find all the references to it--so that I can write a new macro to replace it?

Thanks in advance,

Blue

[Hired Goon]

haha, you got macro'd. man I hate macros, and I hate especially hate hackcess macros - docmd.stufftheshitwaycozIgotnoclue

anyhoo, did you try holding left shift when opening the database, this is the simple way of bringing up the database window (guess you're already past that). Under options there is a setting for "show hidden objects", did you try that?

in relation to part b, it really depends how the thing is written. If it's all docmd and various bodgey macro functions in some shiteworthy nested macro structure, and not code in VBA modules, it could be quite difficult...I guess in theory you could write a procedure in VBA to loop through all of the database objects/controls checking for that macro reference...

Perhaps you should consider upgrading to ASP.net and SQL Server? No self respecting programmer should be made to work with access, and then this thread would sort of be in the right location. It's win win ;)

[Geekwithaguitar]

That'd be nice, but my employer insists on fixing this instead of getting something new. It's got oodles of old records, and they're used to it. ^_^ So I've got to break into the macros somehow. Any more clues?

BTW, I'm out of town until friday the 16th, so if I'm slow in replying it doesn't mean I'm gone. ^_^

[cyberwired]

try asking on or searching www.experts-exchange.com

[dwarfthrower]

Expert Sexchange?

They'll charge you to join up and see answers... try searching http://www.tek-tips.com to see if it's been covered before.