open another access file

[meenctg]

I have a form here with a button i wanna when user will click on button another access file will open.

or current file will close and another file will open.
Is it possible with vb for access? please help me

 

[pr2-eugin]

Application.FollowHyperlink will do what you want. Or even Shell command.

 

[namliam]

Something along the lines of:
shell("MSACCESS.EXE ""D:\Yourfolder\YourDatabase.accdb"" ")

 

[meenctg]

Something along the lines of:
shell("MSACCESS.EXE ""D:\Yourfolder\YourDatabase.accdb"" ")

I have a function for get the current db path,,, I wanna open another mdb file which is also in current directory it's name Backup.mdb

 

[pr2-eugin]

I have a function for get the current db path,,, I wanna open another mdb file which is also in current directory it's name Backup.mdb

So what seems to be the problem now?

 

[meenctg]

So what seems to be the problem now?

How to coding for open the backup.mdb file. My current db path function is GetDBPath()

 

[pr2-eugin]

I thought I already gave you the link to Shell function..

Shell("MSACCESS.EXE " & GetDBPath() & "[COLOR=Red][B]backup.mdb[/B][/COLOR]")

 

[meenctg]

I thought I already gave you the link to Shell function..

Shell("MSACCESS.EXE " & GetDBPath() & "")

GetDBPath() just face the current db path like when i open my main database file in c:\ GetDBPath() just give the c:\ but i wanna open another mdb file name is backup.mdb in current directory of my main database file

 

[pr2-eugin]

Ah ! Sorry check the updated code in Post#7

 

[JHB]

Try the, Application.CurrentProject.Path.

Shell("MSACCESS.EXE " & Application.CurrentProject.Path & "\BackUp.mdb")

 

[namliam]

dont forget to "" the filename, I believe that is still needed in case there are spaces in the filepath/name.