|
 |
access thread: Bypass FTP Software
Message #1 by George Oro <georgeoro@y...> on Mon, 21 Jan 2002 00:42:05 -0800 (PST)
|
|
Hi Guys,
I have one Access 2000 Membership Database and every
time there's some update or changes I need to ftp to
our server to update the web site db that makes me
crazy. The update and changes is very often, is there
any way to incorporate on Save button that, if Record
is New or Edited run FTP using code instead of opening
WS_FTP Pro.exe and upload.
Please help...
Cheers,
George
__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
Message #2 by frazerg@t... on Thu, 24 Jan 2002 04:01:52
|
|
> Hi Guys,
George
The first challenge is to get permission to the folder and Access database
file on the web server. ( See the Web Server's Administrator)
Next would be to get connected to that Web Server via a Network Protocol,
ie Netbeui, TCP/IP.
Protocols like FTP and HTTP are transfer protocols and Access use the
network's protocols address tabels in other databases.
Once you have the right and means to establish a connection, You can link
the Table(s) in the Access Database on the Web Server to the your code
database (You have split the Code:Queries, Forms, Reports, Macros and
Modules from the Data:Tables haven't you)
Once you have a link you can code the Form to update the linked table.
You ought to be using an unbound form and optimistic locking for this.
Refer to Access Developer Handbook (97 or 2000)
Hope this makes it a bit clearer
Regards
Greg Frazer
>Re: Bypass FTP Software
Message #3 by George Oro <georgeoro@y...> on Wed, 23 Jan 2002 20:37:23 -0800 (PST)
|
|
Greg,
Thanks for the tips men.
One thing, do you have some sample code that can send
to me? please, that will be great and very helpful...
Cheers,
George
--- frazerg@t... wrote:
> > Hi Guys,
> George
> The first challenge is to get permission to the
> folder and Access database
> file on the web server. ( See the Web Server's
> Administrator)
>
> Next would be to get connected to that Web Server
> via a Network Protocol,
> ie Netbeui, TCP/IP.
> Protocols like FTP and HTTP are transfer protocols
> and Access use the
> network's protocols address tabels in other
> databases.
>
> Once you have the right and means to establish a
> connection, You can link
> the Table(s) in the Access Database on the Web
> Server to the your code
> database (You have split the Code:Queries, Forms,
> Reports, Macros and
> Modules from the Data:Tables haven't you)
>
> Once you have a link you can code the Form to update
> the linked table.
> You ought to be using an unbound form and optimistic
> locking for this.
> Refer to Access Developer Handbook (97 or 2000)
>
> Hope this makes it a bit clearer
>
> Regards
>
> Greg Frazer
>
>
> >Re: Bypass FTP Software
>
$subst('Email.Unsub').
__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
|
|
|
View Cart
