We have a database on our website which we refresh by FTP'ing a new version 
from our office network several times a day.  This works fine but it would 
be more efficient if we could see the database on our website as just 
another database on our network and we could write code to update it just as 
we would any other database on our system without having to create a new 
version locally and then having to FTP it up to the website.

The web database also collects data from time to time from our clients and 
if we could see it as just another network database it would be easy to 
download this data into our office system - right now we FTP a copy of the 
database down to the office and read the data from clients from it.

I would be pleased to hear from anyone as to how I might go about setting 
this up - assuming it's possible, of course.

Thanks!

Ian



_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

Can you not just build an admin area for updating it for the office so that
office updates go straight into the database? 

You are using Access I assume?  You might have some locking problems if too
many people hit it at once--move it to SQL server and then build an
interface or something that updates it from the office directly--that's my
vote.

Karri

-----Original Message-----
From: Ian Maley [mailto:imaley@h...]
Sent: Wednesday, July 31, 2002 6:39 AM
To: Access ASP
Subject: [access_asp] Updating web database without using FTP




We have a database on our website which we refresh by FTP'ing a new version 
from our office network several times a day.  This works fine but it would 
be more efficient if we could see the database on our website as just 
another database on our network and we could write code to update it just as

we would any other database on our system without having to create a new 
version locally and then having to FTP it up to the website.

The web database also collects data from time to time from our clients and 
if we could see it as just another network database it would be easy to 
download this data into our office system - right now we FTP a copy of the 
database down to the office and read the data from clients from it.

I would be pleased to hear from anyone as to how I might go about setting 
this up - assuming it's possible, of course.

Thanks!

Ian



_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

Many thanks for your reply Karri.  Could you elaborate on your 'build an 
admin area' comment?.

I do have an admin area to monitor activity on the web, add users and 
various other things etc and what I would like to achieve - and maybe I'm 
missing something here - is to be able to update the web database 
periodically during the day - automatically - from our office data without 
having to create and FTP a new web database each time.

I would like to be able to see the web database as just another database on 
our network.  I'm afraid I can't quite get my mind around it.

Ian





_________________________________________________________________
Join the world?s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

Karri:

I think what I'm looking for is the interface you refer to.  The web data 
contains an extract of our office data and I need to create an inteface 
between the office database and the web database to update it automatically 
- using ASP code - rather than FTP'ing the stuff up and down.

Anybody any ideas?

Ian




_________________________________________________________________
Join the world?s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

Ian,
I am not sure all the items you update in your application but here is what 
I have done.

I have an Amateur Radio Club web page and we keep track of member name, 
license status, dues renewal date, and Amateur Call sign [FCC thing]. I also 
have a status flag but not relevent to this conversation.

I have an ASP web page that only accesses and displays information in 
predetermined order for the general viewing of the memembers.  This page can 
be viewed at  http://68.43.100.7:81/I94  and you have various methods of 
reviewing data.  In addition to a member look up by call sign.

I have a second set of ASP pages that allows a mirror of the data base to be 
updated, memembers added, removed, dues date changed, license status 
changed, and call sign changed by the person who does the maintence.  This 
is seperate data base because Access does  not allow multiple hits at the 
same time.

That is all I need have someone trying to read and update at the same time  
D'oooh.  We do not have enough usage yet to get into this, but if true it 
would have to be SQL or Oracle style that allows multiple hits at same time.

Both files are resident in once place and when I see the dates are different 
I manually move the [display] database to backup directory, copy the 
updateable database to the other file name and at this point both files are 
the same.  Veiwable and updateable are identical [datewise] until the next 
time updatable database is revised.

This has worked quite well for me and I am currently exploring ways to move 
the file with a command rather than manually.  But that is another issue.  I 
hope this gives you some ideas to help in planning.

So this is what I have done and I do not use FTP at all as both files are on 
same server.

Regards,
Chuck



>From: "Ian Maley" <imaley@h...>
>Reply-To: "Access ASP" <access_asp@p...>
>To: "Access ASP" <access_asp@p...>
>Subject: [access_asp] Updating web database without using FTP
>Date: Wed, 31 Jul 2002 07:38:55 -0400
>


"If your not part of the solution,
there is good money to be made
prolonging the problem."


http://68.43.100.7:81/aa8vs


_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

Hi Chuck:

thanks for your reply.  We have a database in the office which is 
constantly being updated by 26 users.  I have a database on our web site 
which has an extract of the one in the office - this is used by our 
clients so they can see the status of their accounts without having to 
call us.  

Several times a day we create the extract database in the office and FTP 
it up to the web overwriting the one already there.  This works fine as 
far as it goes.  However the clients also want to enter data using the web 
site.  Now I have a problem.  I don't want to overwright the existing web 
database any more.

So it would be nice if I could see the web database on our network and 
update it using ASP code - and pick up any data the clients may have left.

Does this make sense?

Ian



_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

We have done the same type of access updates on a shared host using a VB
application with RDS.

Manhal M Shukayr
mshukayr@r...
www.river-cities.com


River Cities Software

----- Original Message -----
From: <imaley@h...>
To: "Access ASP" <access_asp@p...>
Sent: Wednesday, July 31, 2002 5:36 PM
Subject: [access_asp] Re: Updating web database without using FTP


> Hi Chuck:
>
> thanks for your reply.  We have a database in the office which is
> constantly being updated by 26 users.  I have a database on our web site
> which has an extract of the one in the office - this is used by our
> clients so they can see the status of their accounts without having to
> call us.
>
> Several times a day we create the extract database in the office and FTP
> it up to the web overwriting the one already there.  This works fine as
> far as it goes.  However the clients also want to enter data using the web
> site.  Now I have a problem.  I don't want to overwright the existing web
> database any more.
>
> So it would be nice if I could see the web database on our network and
> update it using ASP code - and pick up any data the clients may have left.
>
> Does this make sense?
>
> Ian
>
>
>
> _________________________________________________________________
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
>