Close One Open Another

[DS]

From a form I want to close a split database and open another without
exiting access. How can I simply do this...

DoCmd.Close acForm,"frmDone"
DoCmd.Close Front.mdb
DoCmd.Close Back.mdb
DoCmd.Open db, New.mdb

Thanks,
DS

 

[DS]

From a form I want to close a split database and open another without
exiting access. How can I simply do this...

DoCmd.Close acForm,"frmDone"
DoCmd.Close Front.mdb
DoCmd.Close Back.mdb
DoCmd.Open db, New.mdb

Thanks,
DS

I tried this but it closes the mdb and access and doesn't reopen.

DoCmd.Quit
Application.FollowHyperlink "c:\Proserv\DB\databasea.mdb"

DS

 

[Douglas J. Steele]

Take a look at the free TSI SOON (Shut One, Open New) database add-in
http://www.trigeminal.com/utility.asp?ItemID=8#8

 

[DS]

Take a look at the free TSI SOON (Shut One, Open New) database add-in
http://www.trigeminal.com/utility.asp?ItemID=8#8

Thanks Douglas,
I wanted something that is not dependent on VB6.
Isn't there and easy way to do this?

DoCmd.Quit quits access completely.....fine'
Now why can't I reopen Access and go directly to another datase/
The hyperink thing is not working...

DoCmd.Quit
Application.FollowHyperlink "c:\Proserv\DB\databasea.mdb"

This shouldn't be this hard!
Thanks
DS

 

[Douglas J. Steele]

Thanks Douglas,
I wanted something that is not dependent on VB6.
Isn't there and easy way to do this?

As far as I know, there's nothing built into Access that can accomplish what
you're trying to do.

This shouldn't be this hard!

Perhaps, but on the other hand, I've never had a requirement to do this in
all the years I've been using Access.

Why are you trying to do what you're trying to do?

 

[Douglas J. Steele]

I'm closing down my application for the day, then after the mdb is closed
I simply want to make a backup of it from another access mdb.

Well, that precisely the sort of thing TSI SOON was created for. However,
there's nothing stopping you from copying the back-end from the front-end
(assuming no links between the two are active). You can check whether the
locking file (.ldb) exists in the same folder as the back-end, and create
your copy if it doesn't. (And, of course, there should be no need to backup
the front-end)

 

[DS]

As far as I know, there's nothing built into Access that can accomplish what
you're trying to do.




Perhaps, but on the other hand, I've never had a requirement to do this in
all the years I've been using Access.

Why are you trying to do what you're trying to do?

Douglas

I'm closing down my application for the day, then after the mdb is
closed I simply want to make a backup of it from another access mdb.

Thanks
DS

 

[DS]

Well, that precisely the sort of thing TSI SOON was created for. However,
there's nothing stopping you from copying the back-end from the front-end
(assuming no links between the two are active). You can check whether the
locking file (.ldb) exists in the same folder as the back-end, and create
your copy if it doesn't. (And, of course, there should be no need to backup
the front-end)

So can I sever or should I sever the links, since at this point all
employees are locked off the system anyhow.
You know O forgot that I am not copying the front end so you are right
about just copying the backend. Thats an easy solution!
Thanks Doug!
DS