ADO and Active Server pages on a mac

Can you use ADO object to connect to an Access database from Excel on a Mac
on a network? I would like to connect to an Access database using ODBC.
In otherwords does the Excel object model on a Mac have ADO? I know what
the object model is about and an ADO object connection.

Here are the instructions:

Here is how to create a connection to a MS Access Database:

1. Open the ODBC icon in your Control Panel.
2. Choose the System DSN tab.
3. Click on Add in the System DSN tab.
4. Select the Microsoft Access Driver. Click Finish.
5. In the next screen, click Select to locate the database.
6. Give the database a Data Source Name (DSN).
7. Click OK.

So here is the object code:

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "northwind"
%>

Does ADO only work on Active Server Pages on a PC? Is Active Server Pages
the middleware to connect to an Access database through a Windows Server and
IIS? What is the relationship between Active Server Pages and ADO.
I'm confused since I'm on a Mac.
Thanks,
Janis

.

Relevant Pages

  • Re: ADO and Active Server pages on a mac
    ... Mac XL doesn't include ODBC drivers, but you can obtain 3rd party. ... Here is how to create a connection to a MS Access Database: ... Does ADO only work on Active Server Pages on a PC? ...
    (microsoft.public.mac.office.excel)
  • Re: How to connect MS ACCESS in Netwaork base VB6.0 Programme from server
    ... Structure you can use to connect to and query an Access Database using ADO. ... How to connect MS ACCESS in Netwaork base VB6.0 Programme from server ... SIDE) AND ATTENDENS STORE OM MS ACCESS DATABASE WHICH IS STORED ON ...
    (microsoft.public.vb.winapi)
  • Re: ADO and Active Server pages on a mac
    ... In otherwords does the Excel object model on a Mac have ADO? ... Here is how to create a connection to a MS Access Database: ... Does ADO only work on Active Server Pages on a PC? ...
    (microsoft.public.mac.office.excel)
  • Re: Importing data From Word Form to Access
    ... you have DAO and ADO. ... > access database. ... This reply is posted in the Newsgroup; please post any follow question or reply ...
    (microsoft.public.word.docmanagement)
  • Re: renaming a access table in ado .net
    ... i need to rename a table in a access database, ... I'm not aware of any way to rename a table directly using Access SQL DLL. ... You will probably need to use either ADOX or DAO. ...
    (microsoft.public.dotnet.framework.adonet)