Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
import all existing modules?
- Thread starter primerov
- Start date
jksmi
Technical User
- Nov 25, 2002
- 258
- 0
- 0
Hi, if you select new table and choose import table from the wizard you can select the other database and chooses modules from the import tab DON'T DO THIS WITHOUT BACKING UP FIRST!!! there is a known bug that doing this will corrupt your database - according to MSKB installing service pack 3 should fix this, but on my PC it didn't...
You can do it programatically if you create a ref to VBIDE (Microsoft Visual Basic for Applications Extensibility x.x).
The other option is to create a reference to your other database (in references go to browse and change file type to .mdb). It depends what type of functions you use, but you can either call them directly using this reference or quickly copy and paste them.
HTH, Jamie
FAQ219-2884
![[deejay]](/data/assets/smilies/deejay.gif "[deejay] [deejay]")
You can do it programatically if you create a ref to VBIDE (Microsoft Visual Basic for Applications Extensibility x.x).
The other option is to create a reference to your other database (in references go to browse and change file type to .mdb). It depends what type of functions you use, but you can either call them directly using this reference or quickly copy and paste them.
HTH, Jamie
FAQ219-2884
- Status
Similar threads
- Locked
- Question