Splitting up data and code.... In MS Access 2007
Posted on 2011-10-30
Hey, I have got (hopefully not a stupid question...)
I would like to split my table to have code in one file and my data in another. and have BOTH on the net.
All of the references I see to front/back end state the the application is run from the local desktop.
I would LIKE to keep the code on the server and have it run from there. The reason is just for maintaining the code.
I want to have the data separate becuase that way, I can update my code, with out having people log out. I use a link to the application, and between version, I just change the link to point to the new version.
The way it is right now, I have to kick everybody off, copy the application, then copy all of the data from the old to update the new.
the way I would like to run it, when I put in the new versions, as people log out of the old, and then the next time they login, it would just load the new code, no updating of the data tables.
Then when I see the lock remove from the previous version, I can then move THAT code offline.
Is this possible?
Are there any "gotchas" I need to worry about? I realize speed wont be quite as good and a local app and shared data, but that to me seems like a nightmare to maintain, especially when you have people across the country, and many are noobs
Again, I have tried searching, but I only fing references to local/remote setups.