dbTalk Databases Forums  

Reading lines from module in another access database

comp.databases.ms-access comp.databases.ms-access


Discuss Reading lines from module in another access database in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Simon Boardman-Weston
 
Posts: n/a

Default Reading lines from module in another access database - 07-29-2003 , 09:00 AM






Can anyone help me find a way to read lines from another Access (2000)
database using vba.

I have a maintenance db which I use to maintain other access dbs and I
can happily read and alter lines in modules within the same db
programmatically. I can also get a list of modules in other dbs but I
can't find a way of reading (and if necessary, modifying) code lines
in other dbs.

Ideally what I would like to do is read in lines from modules in other
dbs to check if they are the correct version then edit them as
appropriate.

I would be most grateful if someone could help with this.

Thank you

Reply With Quote
  #2  
Old   
Mike S.
 
Posts: n/a

Default Re: Reading lines from module in another access database - 07-29-2003 , 11:28 AM






You cannot open an object in another db in design mode. Just import the
module into the utility db, process it then export it back, if needed,
overwriting the original.

--
Mike S.
Optimal Systems www.oscorp.com
--
"Simon Boardman-Weston" <sbw (AT) brigroup (DOT) co.uk> wrote

Quote:
Can anyone help me find a way to read lines from another Access (2000)
database using vba.

I have a maintenance db which I use to maintain other access dbs and I
can happily read and alter lines in modules within the same db
programmatically. I can also get a list of modules in other dbs but I
can't find a way of reading (and if necessary, modifying) code lines
in other dbs.

Ideally what I would like to do is read in lines from modules in other
dbs to check if they are the correct version then edit them as
appropriate.

I would be most grateful if someone could help with this.

Thank you



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.