ADO and Active Server pages on a mac

[Janis Rough]

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

 

[CyberTaz]

Mac XL doesn't include ODBC drivers, but you can obtain 3rd party. Have a
look at the two links at the bottom of this page. Perhaps one of them
provides the connectivity:

http://mcgimpsey.com/macoffice/index.html#macxl

I expect you'll get some additional input on the subject, so keep checking
back

 

[Jim Gordon MVP]

Hi Janis,

The short answer to your question is, "Yes, you can."

The long answer including everything I think you need to know about how to
go about doing this is here in this Word document:
http://www.agentjim.com/MVP/Excel/Office2004andAccess.doc

Some day soon I hope to update the document with some more examples, but it
should get you on your way.

If you have any additional questions please post back to this group.

Enjoy!

-Jim Gordon
Mac MVP

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

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info