MS Access Limits 2

[PCLewis]

While looking for a way to use VBA to pull apart an Access Macro (like you can an Access Module), I came across a fairly good run down of some of the limits in Access.

http://www.microsoft-accesssolutions.co.uk/access_specifications.htm

 

[ZmrAbdulla]

You could get the same in the VBA help file. Look for topic "Access specifications" or type "Limitations" for search.

________________________________________________________
Zameer Abdulla
Help to find Missing people
You may be the boss' pet; but you are still an animal

 

[RoyVidar]

One will often find references to this site, too Microsoft Access 2000 and 2002 Maximum Capacities, though the information is quite similar.

Pulling apart macros - if you found something better than this faq705-5796, I'd be interested in the approach used.

Roy-Vidar

 

[PCLewis]

That Faw is pretty cool. I never knew about that undocumented method on the Application object before.

Since there is no way that I can find to examine a macro "as is", I simply use:

  DoCmd.SelectObject acMacro, "Macro1", True
  DoCmd.RunCommand acCmdConvertMacrosToVisualBasic

in conjunction with the AllMacros collection to convert all macro's to code modules. For my purposes this approach is OK because what I am doing is pulling apart an existing application (all tables, code, queries, reports etc) and analysing it for upgrade potential.

I definitely will try that FAQ approach though because it has a distinct advantage of not causing a change to the target database. On the other hand, relying on undocumented features is problematic as they are likely to pull it out once day (maybe).

Cheers