UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> Autoexec V. Manual Code Execution, Access 2016    
 
   
FrankRuperto
post Nov 1 2019, 03:54 PM
Post#21



Posts: 251
Joined: 21-September 14
From: Tampa Bay, Florida, USA


@Albert

That's a good alternative, unless Greg's IT department has disabled running vb scripts in group policy settings.
What's curious is everything was working until about 3 weeks ago and no mods were made by Greg, so did a Windows, Office, or IT Dept update break it?
Could it be that you are linking to a password-protected backend and the password expired?
Have you run compact/repair on your FE?

The Access error message doesnt seem to relate at all to the problem.
Error 2001 usually occur when Access cannot make sense of part of an embedded SQL statement, or when elements within a Domain Aggregate Function are incorrectly specified.
Perhaps turning on trace and recording it in a log file could reveal, or looking at the Windows and Office Event logs?
You could spend hours trying troubleshoot the problem, only to find out there's nothing you can do about it with the existing setup, so a workaround like Albert's, if allowed, is a good solution.
This post has been edited by FrankRuperto: Nov 1 2019, 04:29 PM
Attached File(s)
Attached File  OfficeEvent.PNG ( 46.95K )Number of downloads: 2
Attached File  SystemEventLog.PNG ( 114.33K )Number of downloads: 3
 

--------------------
Currently supporting pawnbrokers that use my store management system developed with Access 2010 on Windows7. Experienced with Informix and Oracle DB's.
Go to the top of the page
 
FrankRuperto
post Nov 9 2019, 07:32 PM
Post#22



Posts: 251
Joined: 21-September 14
From: Tampa Bay, Florida, USA


@SerranoG

So it occurs to me that since your IT Dept restricts admin privs on your box that they're also auto logging you out of the box, or locking the account which requires a password to unlock, after X amount of inactive time?

If that's true, the task scheduler cannot launch your Access app if no user is logged in.

--------------------
Currently supporting pawnbrokers that use my store management system developed with Access 2010 on Windows7. Experienced with Informix and Oracle DB's.
Go to the top of the page
 
2 Pages V < 1 2


Custom Search


RSSSearch   Top   Lo-Fi    14th November 2019 - 05:06 PM