473,698 Members | 2,246 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

AutoExec - Action Failed

Hi

I have multiple .mde FE's linked to an .mdb BE. The FE is distributed with an
Auto FE updater and as such all users are on the same version of the FE.
However, one user is getting "Action Failed" when the FE starts up and runs
AutoExec code.

I have seen some threads say this could indicate corruption but no ohter
users are experiencing this problem. In the past on a different db I had
something similar and it was down to the security settting but this does not
appear to be the problem this time.

Any ideas!

Thank you.

--
Darren

Message posted via http://www.accessmonster.com
Jul 4 '06 #1
6 8615

darren via AccessMonster.c om schreef:
Hi

I have multiple .mde FE's linked to an .mdb BE. The FE is distributed with an
Auto FE updater and as such all users are on the same version of the FE.
However, one user is getting "Action Failed" when the FE starts up and runs
AutoExec code.

I have seen some threads say this could indicate corruption but no ohter
users are experiencing this problem. In the past on a different db I had
something similar and it was down to the security settting but this does not
appear to be the problem this time.

Any ideas!

Thank you.

--
Darren

Message posted via http://www.accessmonster.com

I have a similar setup, in case of (such) problems I just delete the
local .mde and they will get a fresh one :p in 99% of the cases problem
solved.

Do you know where in the autoexec code it halts? Is it within the code
or can it not run any autoexec code at all?
Can you run it down to the exact line where it faults?

Grtz Henro

Jul 4 '06 #2
P.S. Access 2003

--
Darren

Message posted via http://www.accessmonster.com
Jul 4 '06 #3
I've tried prompting an upgrade already but this has not resolve it. I will
try removing the .mde altogther and try again. The user is in another branch
and as such I am working blind. Error dialog is as follows:

Action Failed
Macro Name: AutoExec
Condition: True
Action Name: RunCode
Arguments: fn AutoExec()

I am not sure whether this indicates that the macro is failing or the
function it is calling.

--
Darren

Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200607/1
Jul 4 '06 #4
Sorted.

Although I set this user up at the same time as others he did not inherit the
same permissions as the other did.

Thanks for your support anyway.

--
Darren

Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200607/1
Jul 4 '06 #5
Actually all hell broke loose after this (even with full permissions it
wasn't letting me in). Supect corruption.

Rolled back version, reinstated changes and now all seems well.

Fingers-crossed!

--
Darren

Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200607/1
Jul 4 '06 #6
Ok, this is coming back to haunt me on a daily basis now.

Currently this seems to be limited to one user. He had been using it in the
morning fine and the error occurered when reopening it. In between there have
been no upgrades. As others with FE's connecting to the same BE seem to be OK,
so far it seems to be local to this user.

Deleting the local copy and reinstalling seemed to work after two attempts
but I can't afford to keep doing this daily, or even worse have other users
start experiencing it.

Any further suggestions of a cause/fix?

--
Darren

Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200607/1
Jul 6 '06 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
9450
by: Tom Chidwick | last post by:
Hello, I've custom-built a fairly extensive object model that is designed to run in the background and control the opening and closing of related forms. The whole thing kicks-off with an AutoExec macro at startup, using a RunCode action that calls a global function and the rest works great. Pretty good stuff - flies like an eagle, when it works.
4
6160
by: mvivar | last post by:
Hi everybody: This will be not easy to explain as my mother language is not english, so my apologies in advance if it sounds confusing. We have a database access 97 wich controls time of people in their job in order to finally know how many money costs us to run some projects. People always estimates the time when reporting and we do have the impression they really underestimate the time.
6
3649
by: MLH | last post by:
Did A97, perchance, do away with the need for an AutoExec macro to initiate an autoexec sequence for databases? Or, must we still suffer with that hideous macro?
1
1660
by: Eric | last post by:
Our .Net installation project includes a custom action that is launched post install. When the msi is run from a desktop, all is fine. We tested an install doing an Active Directory push to client machines and it failed. The application installed but the custom action would not launch and the install hung. The only error message we could find in the Event Viewer was 'Fatal Error', nothing else. A customer of ours was able to...
5
6748
by: dick | last post by:
I can't seem to get AutoExec to run a function. Per an article on this group, I: 1) built a boolean function in a module that simply issues a MsgBox, then returns True 2) in AutoExec macro, I wrote a condition "onOpen()=False" including the dbl quotes. For the action I put out another MsgBox saying 'onOp is False'. The 2nd MsgBox always appears. I put a breakpoint in the function. It never triggered, so my function is not being called.
6
6435
by: Takeadoe | last post by:
Dear NG, Can someone assist me with writing the little code that is needed to run an update table query each time the database is opened? From what I've been able to glean from this group, the Autoexec Macro looks like the way to go. Could someone please assist? Thank you very much! Mike
7
4356
jinalpatel
by: jinalpatel | last post by:
I have a report which is based on a macro. Macro is serieas of open queries and a single open report query. When I run this report from my switchboard form it gives me the following series of errors. First it says "Please wait a moment while queries are run. The report will open automatically.Click ok to continue. When I hit "OK", there appears an "Action Failed" dialogue box, which has only one activated button called "Halt", which says the...
8
18782
by: kini113 | last post by:
I want to update my database every night at 10pm. I have a Macro that runs all of the queries needed to update the database (which is also saved as a VBA module) and an AutoExec Macro to runs the "Update Inventory" macro. I also scheduled the task to run every night a 10pm. The problem i have is that in order to run the "Update Inventory" macro I have to enter my ODBC password and there is no way to save the password. This there a Macro...
4
4557
by: kini113 | last post by:
I want to update my MS Access database every night at 10pm. I have a Macro that runs all of the queries needed to update the database (which is also saved as a VBA module) and an AutoExec Macro to runs the "Update Inventory" macro. I also scheduled the task to run every night a 10pm. The problem i have is that in order to run the "Update Inventory" macro I have to enter my ODBC password and there is no way to save the password. This there a...
0
8674
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9157
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8895
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
6518
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4369
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4619
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3046
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2329
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2001
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.