 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Macros / August 2006macro gets deleted
I created a Macro that ran a few action queries and imported data (using the TransferText action). I had SetWarnings set to NO. When I did a test run the file to be imported was missing. This caused an error message to be displayed (which was fine) and the macro to stop (also ok). When I went back to the listing of macros it was gone. It had been saved - had even been run successfully several times before the bad run. Is this a known issue in Access? I'm guessing I'll have to go to code for this - can't have a simple error message deleting my macros! Lauri, Never seen this before.  SignatureSteve Schapel, Microsoft Access MVP > I created a Macro that ran a few action queries and imported data (using the > TransferText action). I had SetWarnings set to NO. When I did a test run [quoted text clipped - 5 lines] > Is this a known issue in Access? I'm guessing I'll have to go to code for > this - can't have a simple error message deleting my macros! Thanks anyway, Steve. Wonder if it has something to do with the fact we run Access from our server - not locally. I had similar problems in the past where it deleted a table when I encountered an error. Hmmmm. Very frustrating! Lauri, Hmmm, never a good idea to run Access on the server! You're not pressing the Delete key to get rid of the error message, are you? SignatureSteve Schapel, Microsoft Access MVP > Thanks anyway, Steve. > [quoted text clipped - 3 lines] > > Hmmmm. Very frustrating! > Hmmm, never a good idea to run Access on the server! I know but it's not my call. :( > You're not pressing the Delete key to get rid of the error message, are you? Nope - just hitting enter. I'm going to test this more to see if I can faithfully replicate it (AFTER I make a backup copy of my macro). Lauri Thanks, Lauri. If you get any more clues as to what's happening with stuff getting deleted, please let us know. SignatureSteve Schapel, Microsoft Access MVP >> Hmmm, never a good idea to run Access on the server! > [quoted text clipped - 8 lines] > > Lauri |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.