|
How do I manage a MS Access database?
A Microsoft Access database is a stand-alone
database file. It can be moved via FTP. If you created the file using
your Control Panel then it will be located in the DB sub-directory of
your website automatically. If not, it is best to put your MS Access
database in that directory anyway for security reasons.
Simply download the database using FTP to your local computer. You will
need to have MS Access (generally it's part of MS Office) installed on
your local computer to edit the database. You will need a more recent
version of MS Access to open the file. e.g. 2000+
When you have completed your changes simply upload the file back to the DB sub-directory.
It is generally good practice:
- Rename local files before overwriting them when using FTP. e.g. mydata12-25-2005.mdb
- Download the files before uploading them when using FTP so you don't over write currently live DB's.
- Keep regular backups of your data.
|