My App has 10 or so tables that we provide that contains proprietary data.
This data will need to be updated once or twice a year.
I would like some comments, suggestions on my proposed strategy for updating
these tables via an ftp site:
1) Post a .mdb file to our ftp web site that contains the updated tables. My
App code connects to the ftp site and gets the file name for any update files
on the site. I already have code to do this and it works fine. My plan is
to have a FTPDownload Table in the backend of My App. It will contain the
name and date of the last update file downloaded. If the current update file
has a later date, it will be downloaded. Should I also keep a separate
record for each table in My App that is updated this way? Not every table in
My App will necessarily need to be updated each time there is a download and
as the developer I may need to know when the last update for each table
occurred not just when an update file was downloaded. Suggestions, advice?
2) If update file is more recent than last update, ask the administrator if
they wish to continue. If so start the forced logoff process to disconnect
everyone from the back-end file. This code is already present in My App.
Also, I’m planning to backup the back-end file from code prior to deleting or
importing any tables.
3) Once the back-end file is backed up, download the update .mdb into a
temporary folder created by code. Use TransferDatabas e to copy the new
tables from the update .mdb to the back-end file, using code in My App. When
should I delete the existing tables before or after the import? If after,
then all of the imported files will need to be renamed because they will have
a “1” at the end.
4) After the update, delete temporary folder that was created to hold the
update .mdb.
What’s the recommended method for initiating this process. Should the code
look for updates every time My App starts up? BTW: Only members of the
Admins group are allowed to update the tables. Should this be manually
initiated by administrators, but they won’t really know when an update is
posted.
Thoughts, recommendations , suggestions are greatly appreciated.
--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200604/1