[AccessD] Autoexec Code?

Greg S weeden1949 at hotmail.com
Thu Jul 17 09:25:35 CDT 2003


Hello Group!

I know that part of my question has been discussed before but I can't seem to find it (too shor a night I think...).  

1.  I want to open a hidden form on startup that opens to a table in the BE.  The purpose is to keep the BE open until the last user exits.  This "should" speed up some of the timing issues I've been having at a local client (large network, some fiber connections, but some older switches and servers).  It's a fully secured app, so I can't directly open the table by the form...it has to be done thru a query since none of the users have permissions on the tables.  

2.  Related to that, I could just put the code in the AUTOEXEC macro that opens the form hidden.  But I HATE macros.  They're functional, but that doesn't make me like'em any better.  I have one form that opens via the startup dialog and put the code in there that opens my hidden form.  It works, but doesn't seem like the best way to do it.  

3.  Is there some way to autoexecute a MODULE or some of the code (other than the way I'm forcing it with the form above in #2)?  

Btw, it's Access 97, soon to be changed over to Access 2002, or .net, or xp or whatever they want to call it this week...

Thanks!
Greg Smith
Weeden1949 at hotmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030717/ceb5926f/attachment-0001.html>


More information about the AccessD mailing list