Open a different database

[indesisiv]

Can anyone tell me the code needed to open a different database.
Basically i just need to run this from a command button so that the users can open a different database.

i have tried the

Call Shell("C:\test\play.mdb", 1)

but i assume that it only works on exe files or something because i get the message invalid procedure call or argument.
But it works normally when i just try and open something like word.


Any ideas

Steve

 

[Mile-O]

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=46573

 

[indesisiv]

Thanks

Cheers Mile
Thats exactly what i was looking for.

 

[ghudson]

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=46573

Mile-O, is there any difference or benefit to the "CreateObject" method versus either of these for opening an existing Access database?

Call Shell("C:\Program Files\Microsoft Office\msaccess.exe X:\TestDB.mdb",vbMaximizedFocus )

Application.FollowHyperlink "X:\TestDB.mdb"

 

[Mile-O]

I don't know although I'd have thought the Shell or FollowHyperlink method would only open the database while creating an Object lets you manipulate the database.

People should remember to set the Object to Nothing once complete with it otherwise it will live on in the memory.