[AccessD] Create a .lib library for use with Access

Stuart McLachlan stuart at lexacorp.com.pg
Tue Mar 21 16:56:34 CDT 2023


Ends with .mda if you save it in the 2000-2003 format.

Ends with .accda (or accde or .accdu)  for more recent version.

See for example utility.accda etc in your
C:\Program Files\Microsoft Office\root\OfficeXX\ folder.

On 21 Mar 2023 at 13:08, John Colby wrote:

> nope.  A vba library (only valid in Access) ends with an mda, however
> you can name it any extension you want IIRC.
> 
> On Tue, Mar 21, 2023 at 5:29AM Arthur Fuller
> <fuller.artful at gmail.com> wrote:
> 
> > Ok, I'm wrong. But I thought John Colby has created one, consisting
> > of VBA code. Maybe I misunderstood; it wouldn't be the first time.
> > But I was given to understand that one could collect a bunch of
> > reusable code and package it. Maybe John meant that he references
> > it, although if it's not a .Lib file or a .DLL, then I have no clue
> > as to how one might reference it. It seems a shame to gather all
> > that reusable code and then have to import it into the next app one
> > is going to write. But I guess if that's what's required, ok, I'll
> > do it that way. Creating an Add-In seems totally wrong. (Actually, I
> > am creating an Add-In, but it has a form as well as some modules, so
> > that's quite another kettle of fish; easy enough to implement,
> > though.
> >
> > On Tue, Mar 21, 2023 at 3:47AM Stuart McLachlan
> > <stuart at lexacorp.com.pg> wrote:
> >
> > > How do you expect to use a .lib file in Access?
> > >
> > > If we are talking about same thing, a .lib is a file which is
> > > statically linked  into an application at compile time. (And
> > > that's a realy compile to a .exe file - not what Access does with
> > > VBA code)
> > >
> > > It's essentailly the same as a DLL wrapped inside an executable
> > > file.
> > >
> > >
> > >
> > > On 21 Mar 2023 at 2:35, Arthur Fuller wrote:
> > >
> > > > I'm having lousy luck searching for this. I keep getting hits
> > > > that tell me how to create a library database, not a .lib file.
> > > >
> > > > Suggestions?
> > > >
> > > > --
> > > > Arthur
> > > > --
> > > > AccessD mailing list
> > > > AccessD at databaseadvisors.com
> > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > Website: http://www.databaseadvisors.com
> > > >
> > >
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> >
> >
> > --
> > Arthur
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> 
> 
> -- 
> John W. Colby
> Colby Consulting
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com




More information about the AccessD mailing list