Updating databse / ASP

Hi,

I have an ACCESS database on the web-server. I build my ASP-driven
website around the database. If I need to update dynamic information
on the website, I 1) download the entire database 2) edit it 3) upload
it back to the server.

I don't have a problem with doing that. However, I want everyone in
the office to be able to 1) edit the database 2) save it to the server
without the FTP download/upload mumbo-jumbo. Oh, and I don't want to
build data access pages - more pain than it's worth. I tried creating
a shortcut on desktop to the ftp location, but that didn't fly.

Thank you very much,

Mia

re: Updating databse / ASP

There is a free OLE control called EZFTP. It can be downloaded at:

Http://www.programmersheaven.com/zone15/cat722/2321.htm

With this routine I was able to make the FTP "mumbo-jumbo" transparent to
the users. There is also a "professional" pay version which adds some
features, but the free version worked very well for me. For the record, I
put the code in a VB6 program. The only little gotcha that I experienced was
understanding that I had to move the OLE control from the VB6 toolbox to the
form, so that it would be accessible in the code (duh).

Frank

"YM" <maxvalery@hotmail.com> wrote in message
news:26365a66.0410281029.5173da62@posting.google.c om...[color=blue]
> Hi,
>
> I have an ACCESS database on the web-server. I build my ASP-driven
> website around the database. If I need to update dynamic information
> on the website, I 1) download the entire database 2) edit it 3) upload
> it back to the server.
>
> I don't have a problem with doing that. However, I want everyone in
> the office to be able to 1) edit the database 2) save it to the server
> without the FTP download/upload mumbo-jumbo. Oh, and I don't want to
> build data access pages - more pain than it's worth. I tried creating
> a shortcut on desktop to the ftp location, but that didn't fly.
>
> Thank you very much,
>
> Mia[/color]

re: Updating databse / ASP

"Chuck Grimsby" <c.grimsby@worldnet.att.net.invalid> wrote in message
news:pb13o0dk1t3l044udkggnckir5ppsefvon@4ax.com...[color=blue]
>
> Mia, more then likely, people don't _need_ FTP capabilities to
> download your Access database.
>
> Type in the web address to your database in your favorite browser as
> if it was a webpage, and watch what happens. Your server will quite
> nicely serve up the database to the web user as if it was a zip file,
> and the user can choose to save it to their disk with a qualm.
>
> Which is a good reason not to use Access databases on your website.[/color]

That's a bit of a stretch since there's is no reason to ever publish the
actual file name or have it in anywhere that is accessible unless you want
it to be.

re: Updating databse / ASP

"Chuck Grimsby" <c.grimsby@worldnet.att.net.invalid> wrote in message
news:6034o0h0dn4jkc2213npkfo5h3pfbbtr9b@4ax.com...[color=blue]
> On Fri, 29 Oct 2004 01:14:33 GMT, "rkc"
> <rkc@yabba.dabba.do.rochester.rr.bomb> wrote:[color=green]
> >
> >"Chuck Grimsby" <c.grimsby@worldnet.att.net.invalid> wrote in message
> >news:pb13o0dk1t3l044udkggnckir5ppsefvon@4ax.com.. .[color=darkred]
> >> Mia, more then likely, people don't _need_ FTP capabilities to
> >> download your Access database.
> >> Type in the web address to your database in your favorite browser as
> >> if it was a webpage, and watch what happens. Your server will quite
> >> nicely serve up the database to the web user as if it was a zip file,
> >> and the user can choose to save it to their disk with a qualm.[/color][/color]
>[color=green]
> > That's a bit of a stretch since there's is no reason to ever publish the
> >actual file name or have it in anywhere that is accessible unless you[/color][/color]
want[color=blue][color=green]
> >it to be.[/color]
>
> Not really a stretch at all. The accessibility of the file is a
> requirement of how ASP pages work. On more then a few web pages, you
> can simply do a "View Source" of a web page and the database's name
> and location is there for anyone who wants it. I've done it a number
> of times while out surfing the web.[/color]

Your advice on being able to download a .mdb file from a web page without
the bother of using ftp is correct. A simple <a href=> will accomplish that.

Since that was what the op was looking for, (I guess) I won't bother
blabbering
on about the point I was trying to make.

re: Updating databse / ASP

Thank you for your reply,

Need a little more info - a little more specific, if you don't mind.
I don't have VB development environment, or time to develop evything
at all ... Although your solution is very sweet, can you suggest
something more idiot-proof?

Thank you again,

Mia Jones

"Frank" <fnoell_cisi@hotmail.com> wrote in message news:<10o2jls8q4nqm50@corp.supernews.com>...[color=blue]
> There is a free OLE control called EZFTP. It can be downloaded at:
>
> Http://www.programmersheaven.com/zone15/cat722/2321.htm
>
> With this routine I was able to make the FTP "mumbo-jumbo" transparent to
> the users. There is also a "professional" pay version which adds some
> features, but the free version worked very well for me. For the record, I
> put the code in a VB6 program. The only little gotcha that I experienced was
> understanding that I had to move the OLE control from the VB6 toolbox to the
> form, so that it would be accessible in the code (duh).
>
> Frank
>
> "YM" <maxvalery@hotmail.com> wrote in message
> news:26365a66.0410281029.5173da62@posting.google.c om...[color=green]
> > Hi,
> >
> > I have an ACCESS database on the web-server. I build my ASP-driven
> > website around the database. If I need to update dynamic information
> > on the website, I 1) download the entire database 2) edit it 3) upload
> > it back to the server.
> >
> > I don't have a problem with doing that. However, I want everyone in
> > the office to be able to 1) edit the database 2) save it to the server
> > without the FTP download/upload mumbo-jumbo. Oh, and I don't want to
> > build data access pages - more pain than it's worth. I tried creating
> > a shortcut on desktop to the ftp location, but that didn't fly.
> >
> > Thank you very much,
> >
> > Mia[/color][/color]

re: Updating databse / ASP

Mia,

Sorry, almost any time I have made anything nice for a user, I have had to
spend some time coding to make it happen. The OLE control can be called from
any language - probably (most likely) even Access. I did a real quick google
search on OLE control & MS Access and there seems to be information out
there on how to do it. As the VB behind Access is the same as any VB (like
the VB6 I am using), the VB code to set up the transfer is:

FTP.RemoteAddress = "123.456.78.90" ' over the web

or

FTP.RemoteAddress = "192.168.0.102" ' local network

FTP.UserName = "User"

FTP.Password = "MyPassword"

FTP.Connect

FTP.RemoteFile = "Database.mdb" 'FTP opens to specified directory

FTP.LocalFile = "Database.mdb"

FTP.Binary = True

FTP.GetFile

FTP.Disconnect

To send it back, substitute FTP.PutFile for FTP.Getfile. If you are still
connected, then the Connect and the stuff before wouldn't be necessary. All
you need to do is learn how to get an OLE control to work in Access. I doubt
that it will be too hard - I just haven't had to do it yet.

Frank


"YM" <maxvalery@hotmail.com> wrote in message
news:26365a66.0410290901.4bce903a@posting.google.c om...[color=blue]
> Thank you for your reply,
>
> Need a little more info - a little more specific, if you don't mind.
> I don't have VB development environment, or time to develop evything
> at all ... Although your solution is very sweet, can you suggest
> something more idiot-proof?
>
> Thank you again,
>
> Mia Jones
>
> "Frank" <fnoell_cisi@hotmail.com> wrote in message[/color]
news:<10o2jls8q4nqm50@corp.supernews.com>...[color=blue][color=green]
> > There is a free OLE control called EZFTP. It can be downloaded at:
> >
> > Http://www.programmersheaven.com/zone15/cat722/2321.htm
> >
> > With this routine I was able to make the FTP "mumbo-jumbo" transparent[/color][/color]
to[color=blue][color=green]
> > the users. There is also a "professional" pay version which adds some
> > features, but the free version worked very well for me. For the record,[/color][/color]
I[color=blue][color=green]
> > put the code in a VB6 program. The only little gotcha that I experienced[/color][/color]
was[color=blue][color=green]
> > understanding that I had to move the OLE control from the VB6 toolbox to[/color][/color]
the[color=blue][color=green]
> > form, so that it would be accessible in the code (duh).
> >
> > Frank
> >[/color][/color]