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.