VBA project does not compile

  • Thread starter Thread starter angus
  • Start date Start date
A

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?
 
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
 
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





.
Click to expand...
 
Back
Top