[AccessD] Macros A Rant???

Mwp.Reid at Queens-Belfast.AC.UK Mwp.Reid at Queens-Belfast.AC.UK
Fri Apr 25 08:43:59 CDT 2003


For what its worth

Personally I think you are incorrect. This discussion has also been carried on 
a MIcrosoft Beta Newgroup restricted to Access MVPs plus a few others. The 
reason being that MS is referring to everything in Access as a Macro Project 
including VBA. When you work with the new security features of Access 2003 you 
set them under the tools macro security option. However the effects apply 
equally to VBA, SQL Queries (action Queries) etc. This came about as a direct 
result of Microsoft viewing Access Macros as on par wth those of WOrd and 
Excel which we are arguing with MS is not the case. For example when you oepn 
Access 2003 you get ht witha MAcro warning. If you choose to disable Macros 
youa re in fact stopping VBA from being loaded. i.e you code driven database 
falls apart.

So while some of you find it boring it will in fact have a fairly large impact 
of how you work with security in Access 2003 and beyond mainly due to the 
confusion over Macros and VBA. 

SO in fact its not a rant. Its just happens that a very serious discussion 
between developers with Microsoft was matched by a similar discussion on 
AccessD.

Thats my thinking anyway

Martin



Quoting "Heenan, Lambert" <Lambert.Heenan at AIG.com>:

> I never thought there was EVER going to be anything useful coming out of
> it.
> It was just another typical Access-D rant! :-)
> 
> Surely there must be an alt.comp.etymology newsgroup out there that
> would
> welcome this kind of discussion.
> 
> > -----Original Message-----
> > From:	Wortz, Charles [SMTP:CWortz at tea.state.tx.us]
> > Sent:	Thursday, April 24, 2003 11:49 AM
> > To:	accessd at databaseadvisors.com
> > Subject:	RE: Hair-Splitting definitions of Macros - was RE:
> [AccessD]
> > VBAquestion
> > 
> > Susan,
> > 
> > I did not say you should kill it.  If you and Drew think you still
> have
> > something to say on the subject, why not take it to either the OT
> list
> > or discuss it privately?  But Seth and I, and maybe others, think
> you
> > two have gone beyond the point where others are getting any useful
> > information out of your discussion.
> > 
> > Charles Wortz
> > Software Development Division
> > Texas Education Agency
> > 1701 N. Congress Ave
> > Austin, TX 78701-1494
> > 512-463-9493
> > CWortz at tea.state.tx.us
> > 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


More information about the AccessD mailing list