Saving Modules in Access

[carrionk]

Hi
Is it possible to save Modules in Access the way they are saved in
Excel?

Excel uses Personal.xls for using macros on every Worksheet.

Is there a Personal space in MS Access where to store Modules the same
way? So you can use them on every DB.

Thx
LC

[Salad]

ca******@yahoo.com wrote:

Hi
Is it possible to save Modules in Access the way they are saved in
Excel?

Excel uses Personal.xls for using macros on every Worksheet.

Is there a Personal space in MS Access where to store Modules the same
way? So you can use them on every DB.

Thx
LC

I've never heard of it. I usually do File/GetExternalData/Import.

I suppose you could have a blank database and when you create a new one
you could copy it over.

You could also make a reference to that database that holds the macros.
Create a new database. Open up a code module, select References,
browse to the MDB that contains the macros and set a reference to it.
Now call a macro from the other MDB.

You can go to http://groups.google.com advanced search and enter
*Access* for groups and
run macro from another database
for the words to search and you'll get lots of hits.

[pietlinden]

<duncecap=ON>
Is that what an MDA file is for? Then you can just reference it in
your References list and just use all the code in its libraries?

I *did* check the help files, but they were of no help!

<duncecap=OFF>

[Trevor Best]

ca******@yahoo.com wrote:

Hi
Is it possible to save Modules in Access the way they are saved in
Excel?

Excel uses Personal.xls for using macros on every Worksheet.

Is there a Personal space in MS Access where to store Modules the same
way? So you can use them on every DB.

Yes.

Create an MDA (or an MDB, an MDA is just an MDB renamed), put all your
code in there, then in your main database, set a reference to it.
--
[OO=00=OO]

[lylefair]

How many seconds does it take to import a bunch of modules from another
db?
How many seconds does it take to save modules as ".bas" files and to
import them into another db?
How many of our procedures need a little tweeking for a new
application?
How many of our procedures could benefit from that little tweeking?
How significant is the number of modules to the size of a db?
Who wants two files when one will do?

[David W. Fenton]

Trevor Best <no****@besty.org.uk> wrote in
news:42***********************@news.zen.co.uk:

ca******@yahoo.com wrote:

Hi
Is it possible to save Modules in Access the way they are saved
in Excel?

Excel uses Personal.xls for using macros on every Worksheet.

Is there a Personal space in MS Access where to store Modules the
same way? So you can use them on every DB.

Yes.

Create an MDA (or an MDB, an MDA is just an MDB renamed), put all
your code in there, then in your main database, set a reference to
it.

I forget if putting the MDA in the Access application folder will
cause it to be automatically loaded. ???

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[David W. Fenton]

"lylefair" <ly******@yahoo.ca> wrote in
news:11********************@g14g2000cwa.googlegrou ps.com:

How many seconds does it take to import a bunch of modules from
another db?
How many seconds does it take to save modules as ".bas" files and
to import them into another db?
How many of our procedures need a little tweeking for a new
application?
How many of our procedures could benefit from that little
tweeking? How significant is the number of modules to the size of
a db? Who wants two files when one will do?

How do you then manage code updates to your shared library? Delete
and import the modules every time you start the application?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Trevor Best]

David W. Fenton wrote:

Trevor Best <no****@besty.org.uk> wrote in

Create an MDA (or an MDB, an MDA is just an MDB renamed), put all
your code in there, then in your main database, set a reference to
it.

I forget if putting the MDA in the Access application folder will
cause it to be automatically loaded. ???

I don't think so.

--
[OO=00=OO]

[Trevor Best]

lylefair wrote:

How many seconds does it take to import a bunch of modules from another
db?
How many seconds does it take to save modules as ".bas" files and to
import them into another db?
How many of our procedures need a little tweeking for a new
application?
How many of our procedures could benefit from that little tweeking?
How significant is the number of modules to the size of a db?
Who wants two files when one will do?

Times the number of front ends using that code, times the number of
times you update that code, a bloody lot.

--
[OO=00=OO]

[David W. Fenton]

Trevor Best <no****@besty.org.uk> wrote in
news:42***********************@news.zen.co.uk:

David W. Fenton wrote:

Trevor Best <no****@besty.org.uk> wrote in

Create an MDA (or an MDB, an MDA is just an MDB renamed), put all
your code in there, then in your main database, set a reference
to it.

I forget if putting the MDA in the Access application folder will
cause it to be automatically loaded. ???

I don't think so.

Was that only in Access 2?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[David W. Fenton]

Trevor Best <no****@besty.org.uk> wrote in
news:42***********************@news.zen.co.uk:

lylefair wrote:

How many seconds does it take to import a bunch of modules from
another db?
How many seconds does it take to save modules as ".bas" files and
to import them into another db?
How many of our procedures need a little tweeking for a new
application?
How many of our procedures could benefit from that little
tweeking? How significant is the number of modules to the size of
a db? Who wants two files when one will do?

Times the number of front ends using that code, times the number
of times you update that code, a bloody lot.

Is it possible to deploy a single copy of your library on a server
and have multiple users of your front end(s) with references to the
same MDE?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Trevor Best]

David W. Fenton wrote:

Is it possible to deploy a single copy of your library on a server
and have multiple users of your front end(s) with references to the
same MDE?

I've never tried it, I don't know if any network issues might pop up in
the same way that running a shared front end off a network share.

--
[OO=00=OO]

[David W. Fenton]

Trevor Best <no****@besty.org.uk> wrote in
news:42***********************@news.zen.co.uk:

David W. Fenton wrote:

Is it possible to deploy a single copy of your library on a
server and have multiple users of your front end(s) with
references to the same MDE?

I've never tried it, I don't know if any network issues might pop
up in the same way that running a shared front end off a network
share.

It's all read-only, so it ought to work. And you're not opening
anything that has properties that Access wants to save (like form
filters), so there wouldn't be any write collisions.

Seems like it ought to work.

Might be a performance problem, though.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc