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 5 1503
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 "profession al" 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*******@hotm ail.com> wrote in message
news:26******** *************** ***@posting.goo gle.com... 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
"Chuck Grimsby" <c.*******@worl dnet.att.net.in valid> wrote in message
news:pb******** *************** *********@4ax.c om... 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.
"Chuck Grimsby" <c.*******@worl dnet.att.net.in valid> wrote in message
news:60******** *************** *********@4ax.c om... On Fri, 29 Oct 2004 01:14:33 GMT, "rkc" <rk*@yabba.dabb a.do.rochester. rr.bomb> wrote: "Chuck Grimsby" <c.*******@worl dnet.att.net.in valid> 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.
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*********@ho tmail.com> wrote in message news:<10******* ******@corp.sup ernews.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 "profession al" 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*******@hotm ail.com> wrote in message news:26******** *************** ***@posting.goo gle.com... 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
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.RemoteAddre ss = "123.456.78 .90" ' over the web
or
FTP.RemoteAddre ss = "192.168.0. 102" ' local network
FTP.UserName = "User"
FTP.Password = "MyPassword "
FTP.Connect
FTP.RemoteFile = "Database.m db" 'FTP opens to specified directory
FTP.LocalFile = "Database.m db"
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*******@hotm ail.com> wrote in message
news:26******** *************** ***@posting.goo gle.com... 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*********@ho tmail.com> wrote in message
news:<10******* ******@corp.sup ernews.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 "profession al" 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jeroen Van Goey |
last post by:
Hi,
I want to put the OMIM databse locally on my computer. I downloaded
the file genemap from ftp://ftp.ncbi.nih.gov/repository/OMIM/ It
contains a list of fields, separated by the '|' character. An example
is:
1.1|9|11|95|1pter-p36.13|CCV|P|Cataract, congenital, Volkmann
type||115665|Fd|linked to Rh in Scottish family||Cataract, congenital,
Volkmann type (2)| | ||
1.2|9|25|01|1pter-p36.13|ENO1, PPH, MPB1|C|Enolase-1, alpha||172430|S,
|
by: Exit12 |
last post by:
Hi all
I'm new to mysql so easy!
I use PHPMyadmin as a front end to administering my databases
but my simple question is how do I, from the command line (winxp prompt)
drop a certain databse.
so once I log into mysql, using mysql -u root,
how would I go about deleting whole databases?
|
by: sreenivasan alakappan |
last post by:
Hello,
I want to create a database applciation in C++. I am using VC++
6.0 as the deevelopment environment. When I ever i createa project, it
only allows me to create a form based normal application or a databse
application. But I dont want that.
My aim, is read some input file, extract certain valeus and write
into the database. I want to connect to access or some database, there
is no particular need in this.ALl i will need in this...
|
by: Elham Ghoddousi |
last post by:
I have a problem with my TEMPDB Database.It gets extra size through
importing data into one of my databases in same server.
How can I shrink my TempDB Databse?
Thanks
|
by: sid.rane |
last post by:
Hello,
I was looking for databse tools that allow easy access to data for
users with minimal or no DB knowledge to perform meainstream functions
such as read/write/edit/delete data. Something like an editor perhaps,
that will also have user previledges before he/she starts accessing
databases.
Are there any off-the shelf products available that support MS Access?
| |
by: Nir Amber via DotNetMonster.com |
last post by:
I cant seem to get the databse to update the tables.
i get the following error
"System.InvalidOperationException: Missing the DataColumn 'description' in
the DataTable 'Transactions' for the SourceColumn 'description'."
here is the code im using. please will someone explain what i am doing wrong
regards
Nir
|
by: Gurdeep Toor via AccessMonster.com |
last post by:
Hi Folks,
I am building an application in VB.NET... It connects to 2 databases MS SQL
SERVER 2005 and MS ACCESS 2003 .. It works all fine with SQL but It only
reads the record from the ACCESS table which is linked with SAGE ACCOUNTING
SOFTWARE V 11... Now When i Update or add record to the ACCESS linked table
then i got the Error..... INVALID KEYWORD SPECIFICATION... My Code looks like.
...
'...
|
by: tan |
last post by:
Hi, I have tested my databse and everthing works fine but then have given it to a customer and the following part of the code does not seems to be updating as required.
Set rs = db.OpenRecordset("LTOT_second_oxygen2", dbOpenDynaset)
rs.FindFirst " = '" & Me! & "'"
If rs.NoMatch Then
rs.AddNew
rs! = Me!
rs.Update
End If
|
by: Bakarre |
last post by:
To display a field from databse and calculate time different
--------------------------------------------------------------------------------
Good day,
i have problem to display a field from databse and calculate time different.
See below my code.
I hope somebody can fix the problem for me.
<?php
|
by: tokcy |
last post by:
Hi everyone,
I am new in php and ajax, i am facing the prob while i click on element of first drop down then in second dropdown all element showl come from database.
I mean i have three dropdown 1. category which comes from database 2. brand which comes from databse according to content of first dropdown . and 3. price which is static.
when i am doing these things without ajax on every onChange() thw whole page is refreshing that i do not...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |