Open database with vba 2

[labanTek]

Hi can someone tell me how to open another Ms Access database when a command button is clicked on a database that is already open?
Thanks in advance.

 

[Remou]

It depends on what you want to do. This may suit:
FollowHyperlink "C:\tek-tips.mdb"

 

[labanTek]

Thanks so much for your help.

 

[Zion7]

As Remou said, depends on your objective.
FollowHyperlink, or Shell()

To run DDL operations, or DLL from initially opened DBase, you may want to use DAO OpenDatabase(), or ADO/ADOX.Connection()

 

[labanTek]

Thanks to you both for the valuable information. Can I also delete a file or database using vba? If so what is the code?
Thanks in advance.

 

[RoyVidar]

[tt]Kill "c:\tek-tips.mdb"[/tt]

Might check if the file exists first (Dir function?)

Roy-Vidar

 

[Zion7]

check out Kill().

 

[labanTek]

Thanks all.