External Source Control of Basic Modules in MS-Access?

[Randy Yates]

I would like to, at a minimum, be able to export and import MS-Access
basic modules so that I can edit them using my own
editor. Additionally I'd like to move the routines into a source
control mechanism such as CVS.

Has anyone ever accomplished such a thing? Pointers would be
appreciated.
--
Randy Yates

[Randy Yates]

Randy Yates <ra*********@sonyericsson.com> writes:

I would like to, at a minimum, be able to export and import MS-Access
basic modules so that I can edit them using my own
editor. Additionally I'd like to move the routines into a source
control mechanism such as CVS.

Has anyone ever accomplished such a thing? Pointers would be
appreciated.

Let me add that I've got half of this working - I can export modules.
The problem is in importing - even though I DoCmd.DeleteObject a module,
Access complains that it exists when I try to add it back in.
--
Randy Yates
Sony Ericsson Mobile Communications
Research Triangle Park, NC, USA
ra*********@sonyericsson.com, 919-472-1124

[pietlinden]

It sounds like the collection needs to be refreshed between the
DoCmd.DeleteObject and the import step. That should completely remove
any "memory" of it...

[Trevor Best]

Randy Yates wrote:

I would like to, at a minimum, be able to export and import MS-Access
basic modules so that I can edit them using my own
editor. Additionally I'd like to move the routines into a source
control mechanism such as CVS.

Has anyone ever accomplished such a thing? Pointers would be
appreciated.

Is CVS SCC compliant? If so you can use it natively within Access if you
have the developers edition. I use StarTeam like this.

--
[Oo=w=oO]

[Randy Yates]

pi********@hotmail.com writes:

It sounds like the collection needs to be refreshed between the
DoCmd.DeleteObject and the import step. That should completely remove
any "memory" of it...

I looked around for a "refresh" or "update" method but couldn't
find one. Do you know how to do this?
--
Randy Yates
Sony Ericsson Mobile Communications
Research Triangle Park, NC, USA
ra*********@sonyericsson.com, 919-472-1124

[pietlinden]

S-M-R-T!! I am so smart! (Oh, I mean S-M-*A*-R-T!!)

DBEngine(0)(0).Containers("Modules").Refresh

(trying very hard not to burn my diploma...)

[Randy Yates]

pi********@hotmail.com writes:

S-M-R-T!! I am so smart! (Oh, I mean S-M-*A*-R-T!!)

DBEngine(0)(0).Containers("Modules").Refresh

(trying very hard not to burn my diploma...)

"Compile Error: Method or Data Member Not Found"
--
% Randy Yates % "Though you ride on the wheels of tomorrow,
%% Fuquay-Varina, NC % you still wander the fields of your
%%% 919-577-9882 % sorrow."
%%%% <ya***@ieee.org> % '21st Century Man', *Time*, ELO
http://home.earthlink.net/~yatescr

[John Mishefske]

Randy Yates wrote:

I would like to, at a minimum, be able to export and import MS-Access
basic modules so that I can edit them using my own
editor. Additionally I'd like to move the routines into a source
control mechanism such as CVS.

Has anyone ever accomplished such a thing? Pointers would be
appreciated.

Check out the undocumented .SaveAsText and .LoadFromText hidden
functions. Then you can use CVS, PVCS or whatever system you prefer for
*modules* and *classes*.

--
'---------------
'John Mishefske
'---------------

[Trevor Best]

Randy Yates wrote:

pi********@hotmail.com writes:

S-M-R-T!! I am so smart! (Oh, I mean S-M-*A*-R-T!!)

DBEngine(0)(0).Containers("Modules").Refresh

(trying very hard not to burn my diploma...)

"Compile Error: Method or Data Member Not Found"

DAO ref?

--
[Oo=w=oO]

[Randy Yates]

John Mishefske <mi************@JUNKtds.net> writes:

Randy Yates wrote:

I would like to, at a minimum, be able to export and import MS-Access
basic modules so that I can edit them using my own
editor. Additionally I'd like to move the routines into a source
control mechanism such as CVS.
Has anyone ever accomplished such a thing? Pointers would be
appreciated.

Check out the undocumented .SaveAsText and .LoadFromText hidden
functions. Then you can use CVS, PVCS or whatever system you prefer
for *modules* and *classes*.

Thank you John!
--
% Randy Yates % "Ticket to the moon, flight leaves here today
%% Fuquay-Varina, NC % from Satellite 2"
%%% 919-577-9882 % 'Ticket To The Moon'
%%%% <ya***@ieee.org> % *Time*, Electric Light Orchestra
http://home.earthlink.net/~yatescr