[AccessD] MS Access with IIS

Drew Wutka DWUTKA at Marlow.com
Sat Sep 24 11:17:25 CDT 2011


Easy Peasy.  You are just going to use ADO.

Would you like a utility I built a while back, that builds 'data
classes' in asp classic?  I built it in VB6, you point it to the .mdb,
and it creates a data class for a table (or query) along with a 'group'
class for the individual data class. Email me off list if you want it.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Friday, September 23, 2011 5:50 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] MS Access with IIS

Drew:

Server 2003 Developers edition with IIS version 6, fully tricked out,
runs ASP classic as well as a number of databases protocols and
Extensions etc.

TIA
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Friday, September 23, 2011 12:56 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] MS Access with IIS

Accessing an .mdb on a web server (like IIS) is identical to accessing
the .mdb from your programming interface itself.

For example, if you want to use classic ASP, then you are using
VBScript, and VBScript can access an .mdb using ADO.  Now, years ago, I
believe you had to install ADO separately, but I think since XP, that
ADO is included, not 100% positive on that.  If you are using .Net, (ie,
ASP.Net), then you have the .Net runtimes installed on the server.

What platform are you using to program with, and I can point you in a
better direction.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Thursday, September 22, 2011 8:32 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] MS Access with IIS

Well, you have me at a disadvantage as I do not know what you mean?

Jim
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Thursday, September 22, 2011 3:40 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] MS Access with IIS

Nope.... 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Thursday, September 22, 2011 5:01 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] MS Access with IIS

Does that mean Access have to be installed on the IIS server?

Jim


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Thursday, September 22, 2011 12:30 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] MS Access with IIS

You can communicate with just ADO.  I haven't used .Net with an .mdb,
but I don't think it would be much different.

I STRONGLY recommend that the .mdb be placed on the same server as IIS.


Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Thursday, September 22, 2011 12:44 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] MS Access with IIS

Hi All:

In the many years, I have worked with MS Access there is on thing I have
never done with it. I have never used MS Access as the DB for an
application running off an IIS server...any web server for that
matter...MS SQL, Express, Oracle, MySQL etc but never MDB.

So does MS Access have to be installed on the IIS server and does an
extension have to be added to the server etc.? Can just a set of drivers
be configured...? (If the truth be known I would just love to upsize to
any other DB and be done with it but that is not what the client wants;
and the client is always right.(?))

If any one has experience with this process, their knowledgeable tips
would be greatly appreciated.

MTIA
Jim 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com The information contained in
this transmission is intended only for the person or entity to which it
is addressed and may contain II-VI Proprietary and/or II-VI Business
Sensitive material. If you are not the intended recipient, please
contact the sender immediately and destroy the material in its entirety,
whether electronic or hard copy. 
You are notified that any review, retransmission, copying, disclosure,
dissemination, or other use of, or taking of any action in reliance upon
this information by persons or entities other than the intended
recipient is prohibited.


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com The information contained in
this transmission is intended only for the person or entity to which it
is addressed and may contain II-VI Proprietary and/or II-VI Business
Sensitive material. If you are not the intended recipient, please
contact the sender immediately and destroy the material in its entirety,
whether electronic or hard copy. 
You are notified that any review, retransmission, copying, disclosure,
dissemination, or other use of, or taking of any action in reliance upon
this information by persons or entities other than the intended
recipient is prohibited.


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com The information contained in
this transmission is intended only for the person or entity to which it
is addressed and may contain II-VI Proprietary and/or II-VI Business
Sensitive material. If you are not the intended recipient, please
contact the sender immediately and destroy the material in its entirety,
whether electronic or hard copy. 
You are notified that any review, retransmission, copying, disclosure,
dissemination, or other use of, or taking of any action in reliance upon
this information by persons or entities other than the intended
recipient is prohibited.


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity 
to which it is addressed and may contain II-VI Proprietary and/or II-VI Business 
Sensitive material. If you are not the intended recipient, please contact the sender 
immediately and destroy the material in its entirety, whether electronic or hard copy. 
You are notified that any review, retransmission, copying, disclosure, dissemination, 
or other use of, or taking of any action in reliance upon this information by persons 
or entities other than the intended recipient is prohibited.





More information about the AccessD mailing list