Updating databse / ASP

[YM]

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

[Frank]

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" <ma*******@hotmail.com> wrote in message
news:26**************************@posting.google.c om...

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

[rkc]

"Chuck Grimsby" <c.*******@worldnet.att.net.invalid> wrote in message
news:pb********************************@4ax.com...

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.

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.

[rkc]

"Chuck Grimsby" <c.*******@worldnet.att.net.invalid> wrote in message
news:60********************************@4ax.com...

On Fri, 29 Oct 2004 01:14:33 GMT, "rkc"
<rk*@yabba.dabba.do.rochester.rr.bomb> wrote:

"Chuck Grimsby" <c.*******@worldnet.att.net.invalid> wrote in message
news:pb********************************@4ax.com.. .

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.

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

wantit to be.

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.

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.

[YM]

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" <fn*********@hotmail.com> wrote in message news:<10*************@corp.supernews.com>...

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" <ma*******@hotmail.com> wrote in message
news:26**************************@posting.google.c om...

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

[Frank]

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" <ma*******@hotmail.com> wrote in message
news:26**************************@posting.google.c om...

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" <fn*********@hotmail.com> wrote in message

news:<10*************@corp.supernews.com>...

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