Good day all, and thank you in advance for your help. No - MANY thanks in
advance for your help - I know nothing about using databases on Web servers.
I am about to discuss a project with a client who is in the apartment rental
business. He solicits "For Rent" listings from property owners and managers,
advertises the apartments, shows them, takes applications and like that. His
inventory, as it were, is a list of vacant apartments that his clients have
asked him to rent.
My client wants to have an inventory control database for use in the office
so that if someone comes in looking for two bedrooms in a place that takes
dogs, for instance, he and/or his agents can run a query to see what's
available. Or, any of them can run a different or less restrictive query for
someone who has fewer requirements... you all get the basic idea here.
Information and ways to get it out...that's what he wants to do.
I can create the database - I have, in fact, created a very similar one, for
my own use with my own properties, that I am going to "spiff up" to use as a
simple demo. The potential rub is that my client may - MAY - want to make
the inventory, or a subset of it, available to Web surfers to search (and
he'd be a fool not to, since all of his competitors do so now). So, I have a
couple of questions -
1. If I understand what I've read correctly, a Web host that says that it
supports "Access" is really
supporting Jet, and that the customer of the host loads just the tables
to the host. Yes?
2. The forms, reports, queries and so forth that we see in the desktop
product aren't supported on
Web servers; they have to be created either as part of Data Access Pages
or with scripts. Yes?
3. If he just loads the tables, as in #1, do the tables need to be created
with particular properties to
use them on the Web, and if they have to have those properties, can they
be used with those
properties in the local office with the desktop machines? In other words,
if we plan to use the
tables on the Web, can we use the same tables and properties in the
office?
For what it's worth, the use in the office will be light. It's not that big
a place. The use on the Web probably won't be as heavy as I have read is
necessary to strain an "Access" database on a Web server.
Any and all info will be appreciated, as well as suggestions on where to get
info.
Happy Memorial Day!
Steve E. 6 1988
Serious_Practit ioner wrote: Good day all, and thank you in advance for your help. No - MANY thanks in advance for your help - I know nothing about using databases on Web servers.
I am about to discuss a project with a client who is in the apartment rental business. He solicits "For Rent" listings from property owners and managers, advertises the apartments, shows them, takes applications and like that. His inventory, as it were, is a list of vacant apartments that his clients have asked him to rent.
My client wants to have an inventory control database for use in the office so that if someone comes in looking for two bedrooms in a place that takes dogs, for instance, he and/or his agents can run a query to see what's available. Or, any of them can run a different or less restrictive query for someone who has fewer requirements... you all get the basic idea here. Information and ways to get it out...that's what he wants to do.
I can create the database - I have, in fact, created a very similar one, for my own use with my own properties, that I am going to "spiff up" to use as a simple demo. The potential rub is that my client may - MAY - want to make the inventory, or a subset of it, available to Web surfers to search (and he'd be a fool not to, since all of his competitors do so now). So, I have a couple of questions -
1. If I understand what I've read correctly, a Web host that says that it supports "Access" is really supporting Jet, and that the customer of the host loads just the tables to the host. Yes? 2. The forms, reports, queries and so forth that we see in the desktop product aren't supported on Web servers; they have to be created either as part of Data Access Pages or with scripts. Yes? 3. If he just loads the tables, as in #1, do the tables need to be created with particular properties to use them on the Web, and if they have to have those properties, can they be used with those properties in the local office with the desktop machines? In other words, if we plan to use the tables on the Web, can we use the same tables and properties in the office?
For what it's worth, the use in the office will be light. It's not that big a place. The use on the Web probably won't be as heavy as I have read is necessary to strain an "Access" database on a Web server.
Any and all info will be appreciated, as well as suggestions on where to get info.
Happy Memorial Day!
Steve E.
See my earlier response today to another question on putting Access on
the web.
Specific answers to you questions:
1. No. You typically load the entire access database, database.mdb, on
the server. The web app then accesses it.
2. Correct the normal access queries, forms and reports can't be used on
the web.
Don't even try to use Data Access Pages. See the link in my prior post
for more info on that.
No you don't have to use scripts to create the screens. You can build
web sites using Access databases using a variety of tools such as
Microsoft Front Page and others.
3. Not sure. Haven't done that. Would only work if the web server was
also on your local network. Otherwise, forget it. Probably best if you
were to do all the changes on the local database and then upload a copy
of the database to the web site for read-only access. You could refresh
the database on the web server whenever the data changes.
Bob
Some additions to Bob's excellent response:
2. Your queries can and should be used by your web interface as they
are part of Jet (the database portion of your Access "database") . If
your queries use custom functions that you have in code, then those
functions will be used too.
3. The tables should be the same whether you access them from your
Access interface or your web interface. There is no need to change
them to make them more accessible from the web interface. The only
caveat is that because your users on the web will be querying the
tables differently, you made need additional indexing on some tables.
Access should take care of this for you automatically as you create the
reporting queries.
You would be much better off to have the web server on your network
rather than use a 3rd party host as Bob mentioned. However, if you
must use a 3rd party host, you can build your web interface so that it
handles reporting and data viewing/input (forms). In this way, you
wouldn't need an Access interface and you wouldn't need periodic
uploads. If you feel that you must go with the Access UI/DB in the
office and then upload it to the 3rd party web server, then you should
simply copy the entire MDB file--there's no need to strip out parts of
it.
Bill E.
Hollywood, FL
In Reply to your question 2.
The Database Queries can still be executed and using OLE you may
still execute the Reports. Forms would not be accessible, unless
there is some 3rd party software module available.
<bi********@net scape.net> wrote in message
news:11******** *************@g 14g2000cwa.goog legroups.com... Some additions to Bob's excellent response:
2. Your queries can and should be used by your web interface as they are part of Jet (the database portion of your Access "database") . If your queries use custom functions that you have in code, then those functions will be used too.
3. The tables should be the same whether you access them from your Access interface or your web interface. There is no need to change them to make them more accessible from the web interface. The only caveat is that because your users on the web will be querying the tables differently, you made need additional indexing on some tables. Access should take care of this for you automatically as you create the reporting queries.
You would be much better off to have the web server on your network rather than use a 3rd party host as Bob mentioned. However, if you must use a 3rd party host, you can build your web interface so that it handles reporting and data viewing/input (forms). In this way, you wouldn't need an Access interface and you wouldn't need periodic uploads. If you feel that you must go with the Access UI/DB in the office and then upload it to the 3rd party web server, then you should simply copy the entire MDB file--there's no need to strip out parts of it.
Bill E. Hollywood, FL
Carl,
Could you give an example of how to use OLE to execute reports.
Thanks.
"Carl" <mail2carl@_rem ove_yahoo.com> wrote in message
news:1y******** *********@newsf e6-gui.ntli.net... In Reply to your question 2.
The Database Queries can still be executed and using OLE you may still execute the Reports. Forms would not be accessible, unless there is some 3rd party software module available.
<bi********@net scape.net> wrote in message news:11******** *************@g 14g2000cwa.goog legroups.com... Some additions to Bob's excellent response:
2. Your queries can and should be used by your web interface as they are part of Jet (the database portion of your Access "database") . If your queries use custom functions that you have in code, then those functions will be used too.
3. The tables should be the same whether you access them from your Access interface or your web interface. There is no need to change them to make them more accessible from the web interface. The only caveat is that because your users on the web will be querying the tables differently, you made need additional indexing on some tables. Access should take care of this for you automatically as you create the reporting queries.
You would be much better off to have the web server on your network rather than use a 3rd party host as Bob mentioned. However, if you must use a 3rd party host, you can build your web interface so that it handles reporting and data viewing/input (forms). In this way, you wouldn't need an Access interface and you wouldn't need periodic uploads. If you feel that you must go with the Access UI/DB in the office and then upload it to the 3rd party web server, then you should simply copy the entire MDB file--there's no need to strip out parts of it.
Bill E. Hollywood, FL
The poster asked if it was possible for his customers to view access reports
on the web. As I only use Perl for the CGI I was referring to the
Win32::OLE perl module.
And as you asked, here is the perl code to view access reports on the web:
### START PERL CODE ###
#!/usr/local/bin/perl
use Win32::OLE;
use Win32::OLE::Con st 'Microsoft Access';
print "Content-type: text/html\n\n";
# Export Access Report to HTML File or Browser
my $access = Win32::OLE->GetObject("I:\ \pathto\\databa se.mdb", sub
{$_[0]->Quit;}) or die "Error: connecting to Access";
$access->{Visible}=0;
$access->{docmd}->OutputTo(acOut putReport, "ReportName ", acFormatHTML,
"I:\\pathto\\re port.htm",1);
#$access->Quit;
undef $access;
### END PERL CODE ###
You could even embed the Microsoft snapview.ocx report viewer ActiveX
Control into your webpages.
Follow this link for info: http://support.microsoft.com/kb/q209145
Carl.
"Tom" <no***@email.ne t> wrote in message
news:1O******** *********@newsr ead2.news.atl.e arthlink.net... Carl,
Could you give an example of how to use OLE to execute reports.
Thanks.
"Carl" <mail2carl@_rem ove_yahoo.com> wrote in message news:1y******** *********@newsf e6-gui.ntli.net... In Reply to your question 2.
The Database Queries can still be executed and using OLE you may still execute the Reports. Forms would not be accessible, unless there is some 3rd party software module available.
<bi********@net scape.net> wrote in message news:11******** *************@g 14g2000cwa.goog legroups.com... > Some additions to Bob's excellent response: > > 2. Your queries can and should be used by your web interface as they > are part of Jet (the database portion of your Access "database") . If > your queries use custom functions that you have in code, then those > functions will be used too. > > 3. The tables should be the same whether you access them from your > Access interface or your web interface. There is no need to change > them to make them more accessible from the web interface. The only > caveat is that because your users on the web will be querying the > tables differently, you made need additional indexing on some tables. > Access should take care of this for you automatically as you create the > reporting queries. > > You would be much better off to have the web server on your network > rather than use a 3rd party host as Bob mentioned. However, if you > must use a 3rd party host, you can build your web interface so that it > handles reporting and data viewing/input (forms). In this way, you > wouldn't need an Access interface and you wouldn't need periodic > uploads. If you feel that you must go with the Access UI/DB in the > office and then upload it to the 3rd party web server, then you should > simply copy the entire MDB file--there's no need to strip out parts of > it. > > Bill E. > Hollywood, FL >
A huge "Thank You" to all who took the time to answer. Feeling much better
equipped to do this now...
Steve E. Big snip... This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Scott MacLean |
last post by:
I'm pulling my hair out over this one. I've got a web page that I need to
have write to another server across the network. The site in question does
NOT run in anonymous mode, that is, the user is presented with a
username/password box when they view the page.
No matter what I do, when the page attempts to access the remote server, I
get a Permission Denied error. I have tried the suggestion from this page:
...
|
by: Andy |
last post by:
Hi, I was wondering if someone could advise on if the following is
possible. I have one website that is available to the public using
Forms authentication and the Membership class, it creates/stores user
information in a SQL Server 2005 db. I have another website that will
administer the first website, allowing admins to look at all of the
users in the db and see specific info from the database.The admin site
is more secure than the...
|
by: lecnac |
last post by:
Here's some details:
Server and workstation both in the same workgroup
Logged into server as local Administrator
Logged into workstation as a local user that is only in the Users group
The local user on the workstation is also defined with same name and
password on the server (and only in the Users group on the server)
Server is Windows Server 2003 running IIS 6.0
Workstation is Windows XP Professional
ASP.NET 2.0 (C#) web site
|
by: lecnac |
last post by:
Sorry for the repost. I must have done something wrong when I tried to post
my reply (I can't seem to find it).
Anyway, I'd really appreciate any help that anyone could provide. My issue
is quickly becoming more and more urgent.
Thanks for the thoughts Bruce. However, we can't do #1 (we must use
Integrated Windows Authentication). And, can't do #2 (the server will be,
|
by: Visitor No 3 |
last post by:
My local Crinkles group(U3A), of which I am one, want me to develop a noddy
database and web
site for their members. Some are computer literate, others not so. I thought
an Access 2000 .mdb on a server from the local council with a web page in
Active Server Pages(ASP) and using ADO would do the trick, then one of them
could update it at home on the web to keep track of members and somebody
else could do the same for current programmes etc....
| |
by: JJ |
last post by:
I'm playing aournd with my first asp.net 2.0 web site and looking at the
Web.sitemap file.
It seems there's a lot of publicity at the moment about Google's sitemaps
and how they are supposed to get your site more likely to be indexed.
Do we therefore use Googles, the standard web.sitemap file, or both??
If anyone has used the Google version, is there any way of getting it to
work with the TreeView and SiteMapPath controls?
|
by: Lyle Fairfield |
last post by:
I am using Microsoft’s Web Browser Control embedded on an Access Form to
browse a specific site. I have a good reason for doing so; the pages on
this site run code which aborts their display unless their window is the
top window; they also treat all child windows as not-logged in windows. So
I have not accomplished what I want with HTA’s or IFrames or Pop-Up
Windows. But the Access Form/MS Web Browser combination gives me a top
window with...
|
by: Flic |
last post by:
Is this possible?
I know about a bit about ODBC and found how to import an ODBC database
stored on the computer, however I am after accessing an SQL database
stored on a webserver. I'd like to keep it up to date, but that could
probably be done with a macro.
At the moment I'm just considoring possible options, so just need to
know if it can be done, how easy and a rough idea of how.
|
by: s13khan |
last post by:
Hi,
I'm using FCKEditor for my CMS based web site thru which I save my site data in HTML format and the site is developped using ASP and MS ACCESS as backend.
So far the site was of single language (only Enlish). But now I need some of the pages in Korean language which will have to be managed using the FckEditor and I think this can be done using UNICODE. But I don't know how to handle and/or insert and/or retrieve UNICODE data and...
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |