Hello, I have a database for my website and use Coldfusion MX7 code to interact with it. Whenever I add to my database, modify it, etc, I upload the database to my web server ftp and overwrite the existing one. Well, there is one problem here, because there is 1 table in my database that changes based on user input. This table is a rating feature. So, day after day, users can come on and rate something, thus changing this table in my database. If I upload a new database and overwrite this, all of the user ratings get erased. So, is there a way I can upload my database, but NOT overwrite my RATE table of my database? I use MS Access 2002 as a datasource. Thanks!
download it first and shut the site (feature) down while you make the changes and update it..... or do all the db changes via SQL
This would also be a good reason to switch to Ms Sql sever based database. When I make changes to my database I'm changing it on the server so the upload step is eliminated. I used to have this same problem and one time I didnt download the Access database file first. What a pain it is to have to contact everyone who joined my site. I had to tell them I accidently deleted there profiles. A mistake I will not make again. Also see if your host provider has a backup feature, If they do be sure to turn it on. Network Solutions host my site and they back up my site everynight. I think they just delete the pervious backup each night as well, not totally sure. I just make sure to back my site myself on a regular basis. Good luck!
Yes, there are a lot of advantages to using MS SQL over MS Access. You could even use the built in commands to make your own db backup via cfquery if you really wanted to Bottom line, you could hack together something that works with MS Access. But unless you have direct access to the db from your computer its likely to be a two step process and not as simple as with MS SQL.