Custom application advice

Hi,
I have made a custom web application using .asp and an
Access 2000 backend database. This application allows
users to enter reference numbers. Once reference numbers
are entered, a list is generated to be run on an external
database to get account information for the account
reference in question. By this I mean the account
holder's name, address, postcode etc...
Next, I have to import this back into the database so that
the database is enriched with more information. Staff
then work on the records, phoning customers to make sure
details are correct etc... If details are not correct,
then amendments are made on screen and saved to the
database along with the original record. This is to show
what the original record looked like and the revised
version - if there were any changes.
My problem at the moment is getting the whole thing going
for real as the setup is a test. I want to migrate to
SQL2000 and make this application run in a live
environment so that I can upload the enriched files on a
daily basis quickly and easily. Furthermore, it has been
discussed whether I can upload enriched data (maybe a .txt
file) onto the main database using a file upload facility -
is this possible?
At the moment, this is how my system works - which is
still at trial stage, so I would not mind any comments on
improvement:
1. Enter customer references. This gets posted into a
table with a timestamp, user's name (for tracking)
2. I then generate a list of two or more occurences of the
customer references. This part I am unsure about,
particularly when my list of two or more would have
different ID numbers from the records in my original table!
3. Once an external enrichment process has occurred, then
I import and overwrite the entire table (is this right?)
4. Staff can then search for and lookup the enriched data
by entering a customer reference. There is then a form
beside the original data, where they can post any
amendments.
5. Amendments are then created as a new record inthe
table, flagged as 'Amendment' and the original record
flagged as 'Original'.
6. A list can then be produced showing the Original Data
and Amendments on fields that have been amended.
Help will be appreciated.
Thanks.
SKC
The newsgroups aren't really the best venue for designing entire
applications. However, if this is a web application, I'd recommend
that you explore using asp.net, where you can work more easily with
XML and SQL Server. www.gotdotnet.com is a great source of more
information, tutorials, and samples to get you started.
--Mary
On Wed, 1 Sep 2004 02:15:16 -0700, "skc"
<anonymous@.discussions.microsoft.com> wrote:

>Hi,
>I have made a custom web application using .asp and an
>Access 2000 backend database. This application allows
>users to enter reference numbers. Once reference numbers
>are entered, a list is generated to be run on an external
>database to get account information for the account
>reference in question. By this I mean the account
>holder's name, address, postcode etc...
>Next, I have to import this back into the database so that
>the database is enriched with more information. Staff
>then work on the records, phoning customers to make sure
>details are correct etc... If details are not correct,
>then amendments are made on screen and saved to the
>database along with the original record. This is to show
>what the original record looked like and the revised
>version - if there were any changes.
>My problem at the moment is getting the whole thing going
>for real as the setup is a test. I want to migrate to
>SQL2000 and make this application run in a live
>environment so that I can upload the enriched files on a
>daily basis quickly and easily. Furthermore, it has been
>discussed whether I can upload enriched data (maybe a .txt
>file) onto the main database using a file upload facility -
> is this possible?
>At the moment, this is how my system works - which is
>still at trial stage, so I would not mind any comments on
>improvement:
>1. Enter customer references. This gets posted into a
>table with a timestamp, user's name (for tracking)
>2. I then generate a list of two or more occurences of the
>customer references. This part I am unsure about,
>particularly when my list of two or more would have
>different ID numbers from the records in my original table!
>3. Once an external enrichment process has occurred, then
>I import and overwrite the entire table (is this right?)
>4. Staff can then search for and lookup the enriched data
>by entering a customer reference. There is then a form
>beside the original data, where they can post any
>amendments.
>5. Amendments are then created as a new record inthe
>table, flagged as 'Amendment' and the original record
>flagged as 'Original'.
>6. A list can then be produced showing the Original Data
>and Amendments on fields that have been amended.
>Help will be appreciated.
>Thanks.
>SKC