Intelligent Automation & Macro Software  

Go Back   Tethys Solutions Forums > Products Zone > Workspace Macro
Register FAQ Search Today's Posts Mark Forums Read

Workspace Macro Post messages and questions related to Macro Recorder or Windows Macro here.


Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 06-03-2008, 01:30 PM
beaks3lee beaks3lee is offline
Junior Member
 
Join Date: Dec 2007
Posts: 8
Default open file security warning

how do i disable this? I'm opening our MS access file on a workgroup/domain/server and it's giving me this security warning, select 'open' in 'currently active window' doesnt work

More info:

The macro starts open MS access 2003 file on our server.
The next screen that pops up is 'Open File - Security Warning'
Name: THE NAME OF MY DATABASE I WANT MACRO TO OPEN
Publisher: UNKNOWN
Type: Microsoft Office Access Application
From: MY LOCATION (which is correct)

I tried inserting a mouse click on the 'open' option, i tried insert keystroke 'o' to OPEN and it just does nothing. How can I stop this? I'm using ms access 2003 and i just had a new server installed in the office as before we were just using a shared folder (as the server).

Last edited by beaks3lee : 06-03-2008 at 01:56 PM.
Reply With Quote
  #2 (permalink)  
Old 06-04-2008, 01:10 AM
forumsupport forumsupport is offline
Senior Member
 
Join Date: Apr 2007
Posts: 486
Default

Hello,

Try inserting 'Alt+o' keystroke in currently active window. It should work.

While recording, we suggest you to wait for few seconds after every action you perform so that on replay macro would get enough time to execute each action. This would lead to an errorless execution of macro.

We have recorded one sample macro for your reference. Please copy it under location, 'C:\...\My Documents\Workspace Macro\My Macros' folder.

This macro would try to open db1.mdb file located under C:\. Before running this task please make sure db1.mdb exists under C:\.

Hope that helps.
Attached Files
File Type: wksp OpenMsAccess.wksp (5.8 KB, 1 views)
Reply With Quote
  #3 (permalink)  
Old 07-30-2008, 12:44 PM
beaks3lee beaks3lee is offline
Junior Member
 
Join Date: Dec 2007
Posts: 8
Default Musta been a fluke

they ended up reloading the server and the security warning didn appear any more, thank goodness.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -7. The time now is 05:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.0.0 ©2007, Crawlability, Inc.
Copyright © 2003-2008 Tethys Solutions, LLC. All rights reserved