MS Access for Mac

[Scott Jenken]

I am interisted in still using Access for when I make the switch to a Mac
computer. Does anybody have any idea as to weather Access will be included
in the Office for Mac Suite? Are there other alternitaives to making
databases similar to the functuionality of Access without haveing to pay too
much?

I appritiate any help you can offer,

Thanks, Scott

 

[Jim Gordon MVP]

Hi Scott,

At last we can address your request.

You can now use Mac Office as a completely relational database without
relying on an external program to be the data store.

Actual Technologies has created an ODBC driver that for about $30 US lets
you use Excel .xls or even text files as a data source.

From there you can create all the SQL queries you need to get your data
sets. You can even use parameter queries.

The documentation on how to accomplish this is not complete, but here's a
link to help you get started.

Look for the Word document titled OfficeAsRelationalDatabase inside the
Examples folder.

Download the Access driver (the access driver is the driver that you can use
with Excel and Text files).
http://actualtechnologies.com/product_access.php

There's a free mode that only returns the first 3 records of the result set
so you can see if the driver works the way you would like it to before you
buy.

-Jim

I am interisted in still using Access for when I make the switch to a Mac
computer. Does anybody have any idea as to weather Access will be included
in the Office for Mac Suite? Are there other alternitaives to making
databases similar to the functuionality of Access without haveing to pay too
much?

I appritiate any help you can offer,

Thanks, Scott

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Jim Gordon MVP]

I see that I forgot to put in the link. Here it is:
http://www.agentjim.com/MVP/Database.zip

This is only temporary location. This link should work only for a few weeks.

-Jim

The documentation on how to accomplish this is not complete, but here's a
link to help you get started.

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Hylton Boothroyd]

I see that I forgot to put in the link. Here it is:
http://www.agentjim.com/MVP/Database.zip

This is only temporary location. This link should work only for a few weeks.

I'm getting a 404 reply today.

 

[Jim Gordon MVP]

You're right! I dropped the letter S - Databases is plural in the link
http://agentjim.com/MVP/Databases.zip

And I thought I copied and pasted so that I would get it right. Sheesh!

-Jim

I'm getting a 404 reply today.

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info