Hello Everyone.
At work, i've developed a database that is used on our production floor and it's working quite well for our needs. I'm using Front End/Back End on a file server since I do not have a SQL backend. Everything is office 2010 and Windows 7 on the desktop environment.
I've used quite a bit of the knowledge found on this forum to do some nice things. Like automatically updating the front end when I decide to push my updates, etc. Killing the application after 15-20 minutes of inactivity, etc.
So, as this thing has grown and I'm working on updates that take more time to develop and debug, my users are opening (and often automatically closing) the database several times a day. Which tends to generate some bugs on its own that is often easily fixed by running the database with the /decompile switch.
Now my question is.. Since I can automatically update the database when I push it, decompile is one of the steps I do to prep the database before updating it to the general population. Should I change where I save the database and possibly just put a short cut on the desktop with the /decompile switch as part of it so that every time it opens it's doing what I do to remedy possible errors that develop over time.
I know this enlarges the database, but that will be fixed with every update I push because I compact it before updating it as well.
Thoughts? Pro's? Con's?
TIA
Ed
At work, i've developed a database that is used on our production floor and it's working quite well for our needs. I'm using Front End/Back End on a file server since I do not have a SQL backend. Everything is office 2010 and Windows 7 on the desktop environment.
I've used quite a bit of the knowledge found on this forum to do some nice things. Like automatically updating the front end when I decide to push my updates, etc. Killing the application after 15-20 minutes of inactivity, etc.
So, as this thing has grown and I'm working on updates that take more time to develop and debug, my users are opening (and often automatically closing) the database several times a day. Which tends to generate some bugs on its own that is often easily fixed by running the database with the /decompile switch.
Now my question is.. Since I can automatically update the database when I push it, decompile is one of the steps I do to prep the database before updating it to the general population. Should I change where I save the database and possibly just put a short cut on the desktop with the /decompile switch as part of it so that every time it opens it's doing what I do to remedy possible errors that develop over time.
I know this enlarges the database, but that will be fixed with every update I push because I compact it before updating it as well.
Thoughts? Pro's? Con's?
TIA
Ed