ontopofmalvern
Registered User.
- Local time
- Today, 20:55
- Joined
- Mar 24, 2017
- Messages
- 64
Hi
I have a split database I use to manage my school's timetable. What I want to be able to do is work on new timetable while still being able to access and tweak current one. The easiest way I see to this is to able to switch between different backends.
This is effectively what I am doing at the moment - as it is a single user database - I just move or rename the backend in windows and relink to using linked tables manager - I'd like a more elegant solution which would allow me to switch in the front end. I can easily enough create the new backend in Windows i just want a bit of VBA I can put behind a button to close one backend and open another.
As I am the only user it doesn't need to be pretty I can hard code filenames, paths etc.
Hope that makes sense
Richard
I have a split database I use to manage my school's timetable. What I want to be able to do is work on new timetable while still being able to access and tweak current one. The easiest way I see to this is to able to switch between different backends.
This is effectively what I am doing at the moment - as it is a single user database - I just move or rename the backend in windows and relink to using linked tables manager - I'd like a more elegant solution which would allow me to switch in the front end. I can easily enough create the new backend in Windows i just want a bit of VBA I can put behind a button to close one backend and open another.
As I am the only user it doesn't need to be pretty I can hard code filenames, paths etc.
Hope that makes sense
Richard