Updating a remote web Access DB

[John Beschler]

Here's one possible scenario:

1. Create an ASP page that allows the user to upload the
datafile.
2. Create another ASP page that has a link to start your
import program. This could be an ASP page or you could use
VB, etc.

HTH,
John

>-----Original Message-----
>Hi Guys
>
>I know I've been harping on about text files and time

outs recently, but I

>have developed web sites with Access DBs as well.
>
>My problem this time is that my client wants to update

the product details

>on a web site that I have done for them, but in a batch

rather than clicking

>through pages in a CMS vein.
>
>I don't want them to have access to my Access DB as this

is my bread butter,

>so does anybody know of a method whereby the user can

create say their

>product updates in such as Excel (to save as a text tab-

delimited file if

>simpler) and then get this file to auto-update my DB on

the web.

>
>Some of you guys must have come across this problem

before so any help you

>can give would be very much appreciated.
>
>Rgds
>
>Laphan
>
>PS: if you have done something like this before, did you

give the user a

>sort of remote backup system so that they don't blow up

the original WWW DB

>when updating?
>
>
>.
>

[Bullschmidt]

Sure, I've done that before.

For uploading:
ASP File Upload Using VBScript by John R. Lewis - 7/10/2000
[url]http://www.aspzone.com/articles/john/aspUpload[/url]

And for connecting to a .csv file:
Able Consulting - ADO Connection String Samples
[url]http://www.able-consulting.com/ADO_Conn.htm[/url]

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Tom Gahagan]

Would it not be easier to have them working off of a copy of your bread and
butter file and then write a sync routine to unify the two files. That way
they could both be access files.... which you seem to be comfortable working
with.

Just a thought anyway. :)

Best
Tom Gahagan

"Laphan" <news@FrozenMoles.co.uk> wrote in message
news:bgm6e2$sg6$1@sparta.btinternet.com...

> Hi Guys
>
> I know I've been harping on about text files and time outs recently, but I
> have developed web sites with Access DBs as well.
>
> My problem this time is that my client wants to update the product details
> on a web site that I have done for them, but in a batch rather than

clicking

> through pages in a CMS vein.
>
> I don't want them to have access to my Access DB as this is my bread

butter,

> so does anybody know of a method whereby the user can create say their
> product updates in such as Excel (to save as a text tab-delimited file if
> simpler) and then get this file to auto-update my DB on the web.
>
> Some of you guys must have come across this problem before so any help you
> can give would be very much appreciated.
>
> Rgds
>
> Laphan
>
> PS: if you have done something like this before, did you give the user a
> sort of remote backup system so that they don't blow up the original WWW

DB

> when updating?
>
>

[Debbie Davis]

Hi Laphan,

How did you decide to handle this? I have the exact same situation and
am struggling with some different upload, update methods. Thanks in
advance for any suggestions you may have.



*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!