Re: Location of VBA code in MDB file

Tony Toews <[email protected]> Fri, 03 Jan 2014 18:52:34 -0700
Newsgroups gmane.comp.db.mdb-tools.devel
Message-ID <[email protected]>
--===============1816715322034801369==
Content-Type: multipart/alternative;
	boundary="=====================_15874677==.ALT"

--=====================_15874677==.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed

At 06:34 PM 2014-01-03, Ross Knudsen wrote:
>I see on the TODO list that there is a task to extract the VBA code 
>from the database.  I'm quite keen on giving this a go but I wanted 
>to know where in the database it is actually stored?  Is it a record 
>in a table somewhere?

I have a vague memory that, starting in Access 2000, all VBA code was 
placed in a BLOB/Memo field in one record.   I'm not at all sure if 
compiled VBA code was placed in the same BLOB.   That said the code 
won't be that useful without the forms and reports.

Tony


-----
Tony Toews, Microsoft Access MVP
Tony's Main Microsoft Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/

--=====================_15874677==.ALT
Content-Type: text/html; charset="us-ascii"

<html>
<body>
<font size=3>At 06:34 PM 2014-01-03, Ross Knudsen wrote:<br>
<blockquote type=cite class=cite cite="">I see on the TODO list that
there is a task to extract the VBA code from the database.&nbsp; I'm
quite keen on giving this a go but I wanted to know where in the database
it is actually stored?&nbsp; Is it a record in a table
somewhere?</blockquote><br>
</font>I have a vague memory that, starting in Access 2000, all VBA code
was placed in a BLOB/Memo field in one record.&nbsp;&nbsp; I'm not at all
sure if compiled VBA code was placed in the same BLOB.&nbsp;&nbsp; That
said the code won't be that useful without the forms and
reports.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br><br>
Tony<br><br>
<x-sigsep><p></x-sigsep>
<font size=3>-----<br>
Tony Toews, Microsoft Access MVP<br>
Tony's Main Microsoft Access pages -
<a href="http://www.granite.ab.ca/accsmstr.htm" eudora="autourl">
http://www.granite.ab.ca/accsmstr.htm<br>
</a>Tony's Microsoft Access Blog -
<a href="http://msmvps.com/blogs/access/" eudora="autourl">
http://msmvps.com/blogs/access/<br>
</a>Granite Fleet Manager
<a href="http://www.granitefleet.com/" eudora="autourl">
http://www.granitefleet.com/<br>
</a></font></body>
</html>

--=====================_15874677==.ALT--



--===============1816715322034801369==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
--===============1816715322034801369==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
mdbtools-dev mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

--===============1816715322034801369==--