VBA project does not compile

[angus]

When pressing the compile option in VBA I get the
hourglass for a second however it appears that it has not
compiled corerctly. Also changes that I have made in the
code are not reflected when I run it.

I have compacted and repaired the database but to no
avail. Does anyone know how I can fix it or is totally
corrupted?

 

[TC]

Maybe a job for decompile!

Take a backup copy of your database. Create the shortcut shown below (all on
one line). Run the shortcut, open the copy, compact it, then try the
compile-all again. Note that this process >does not< affect the original, so
if it does not work, you can not possibly be worse off.

"full path to MSACCESS.EXE" /decompile "full path to copy of db"

HTH,
TC

 

[angus]

Cheers TC, worked a treat!

-----Original Message-----
Maybe a job for decompile!

Take a backup copy of your database. Create the shortcut shown below (all on
one line). Run the shortcut, open the copy, compact it, then try the
compile-all again. Note that this process >does not< affect the original, so
if it does not work, you can not possibly be worse off.

"full path to MSACCESS.EXE" /decompile "full path to copy of db"

HTH,
TC





.