Choose Backend using VBA
Choose Backend using VBA
(OP)
I asked this in another section so apologies for trying again here.
I want to be able to allow a user to switch between two backends with identical structures but different date ranges, so
\\BackendData\CurrentOrders.mdb
\\BackendData\ArchiveOrders.mdb
There are several posts on a similar theme but I haven't been able to adapt them.
Help much appreciated, as ever.
I want to be able to allow a user to switch between two backends with identical structures but different date ranges, so
\\BackendData\CurrentOrders.mdb
\\BackendData\ArchiveOrders.mdb
There are several posts on a similar theme but I haven't been able to adapt them.
Help much appreciated, as ever.
RE: Choose Backend using VBA
TT thread about relinking tables: thread705-1776820: Dynamically Relink tables on open DB
Search "access tables relink" for more info.
combo
RE: Choose Backend using VBA
RE: Choose Backend using VBA
CODE -->
A supplementary question is how to stop people inadvertently using the Archive backend to create new orders, since the data would obviously not then appear in the Current backend. I'll ask about this in a separate post.
Thanks again for quick responses.
RE: Choose Backend using VBA
I hope you do not copy-paste this code just to change the name of your mdb
---- Andy
There is a great need for a sarcasm font.