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!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Opening & Renaming an .mdb

Status
Not open for further replies.
llafretaw

llafretaw

MIS
Oct 2, 2001
64
GB
Hi I'm currently using Access 97 and was wondering how does one explicitly open another mdb just before the calling mdb closes.
I have tried using the dbengine.OpenDatabase method but that doesn't seem to actually open the called mdb.
The mdb that is called needs to compact the calling mdb once its closed. From the CompactDatabase method I see that you can't use the name of the database that is been compacted as the new mdb name as well, so I need to rename the mdb after it has compacted. Any help would be appreciated
Thanks.
 
Status
Not open for further replies.

Similar threads

ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
2K
ziffer68
ziffer68
AJAY0618
  • Locked
  • Question
How to pass a variable in VBA code by opening a form and storing the variable
Replies
3
Views
389
AJAY0618
AJAY0618
Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
332
combo
combo
Moss100
  • Locked
  • Question
Open filtered for and set cursor at particular record
Replies
1
Views
603
Moss100
Moss100
Moss100
  • Locked
  • Question
Find unique rent amount and date this was first charged
Replies
4
Views
793
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top