Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

On Error

Status
Not open for further replies.
Steve1001

Steve1001

Technical User
Nov 1, 2002
17
US
Hi All

I have a an access db that runs every 60 mins and collects data from other non access db's,(the tabels from this db are linked to other Acess db's)The PC that runs this is in another part of the building, and when the task is complete sends an e-mail confirming this. About once every 3 months the db wont run( I can not find the reason - it is probabley due to the conection to one or more of the external db's)I then get an e-mail telling me that the operation has failed. A simple re-boot clears the Pc and all is well again - the question is, does anyone no the code that I could use so that when there is an error, the PC re boots , instead of sending a failed message?


Thanks


Steve
 
Status
Not open for further replies.

Similar threads

renigar
  • Question
Access VBA Syntax Error
Replies
5
Views
189
Andrzejek
Andrzejek
PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
266
PizMac
PizMac
TheresAlwaysAWay
  • Locked
  • Question
Long-established database suddenly giving error Cannot open macro [Name] because it is not valid
Replies
6
Views
306
dhookom
dhookom
renigar
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
380
renigar
renigar
atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
304
atadbitslow
atadbitslow

Part and Inventory Search

Sponsor

Back
Top