473,695 Members | 1,927 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Using Access/Jet on Web site

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.

Nov 13 '05 #1
6 1992
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

Nov 13 '05 #2
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

Nov 13 '05 #3
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

Nov 13 '05 #4
Tom
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


Nov 13 '05 #5
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
>



Nov 13 '05 #6
A huge "Thank You" to all who took the time to answer. Feeling much better
equipped to do this now...
Steve E.
Big snip...

Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
4655
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: ...
1
2673
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...
1
2899
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
1
2043
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,
7
1977
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....
7
1411
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?
2
10381
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...
17
2564
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.
0
1205
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...
0
8630
marktang
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...
0
8568
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,...
0
9115
Oralloy
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...
0
8825
tracyyun
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...
1
6491
isladogs
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...
0
4340
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...
0
4579
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2272
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1976
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.