URGENT - connecting to ms access database

[horseisbrown]

OK, I'm trying to make a database connection on my macintosh to a MS Access database which can be accessed via ftp on a drive at my university. Firstly, is this even possible? and secondly, how on earth do I do it?!
(or I could put the access file on my mac and connect to it there, but again, I'm not sure how to do this either, obviously I am new to all this)
Thanks for the help.

[Newsgroup_User]

Your access file won't work on the Mac so their is no point in putting it
there. If the machine on the university can be turned into a server and
access via an IP then you could create a connection to a remote server from
your mac. The easiest way to do this is via a DSN conenction.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"horseisbrown" <webforumsuser@macromedia.com> wrote in message
news:e4hnso$b1l$1@forums.macromedia.com...
> OK, I'm trying to make a database connection on my macintosh to a MS
> Access
> database which can be accessed via ftp on a drive at my university.
> Firstly, is
> this even possible? and secondly, how on earth do I do it?!
> (or I could put the access file on my mac and connect to it there, but
> again,
> I'm not sure how to do this either, obviously I am new to all this)
> Thanks for the help.
>

[horseisbrown]

thankyou both.

[fortune007]

Hello Paul,
I am trying to connect to an Access database from my Mac via Dreamweaver. I keep getting an error saying "Datasource name not found and no default driver specified." This is the first time I have tried to do this with access and it is driving me crazy trying to figure out what is wrong. please help if you can. Thank you.

[Newsgroup_User]

On Thu 18 May 2006 08:04:40a, horseisbrown wrote in
macromedia.dreamweaver.appdev:

> OK, I'm trying to make a database connection on my macintosh to a MS
> Access database which can be accessed via ftp on a drive at my
> university. Firstly, is this even possible? and secondly, how on earth
> do I do it?!
> (or I could put the access file on my mac and connect to it there,
> but again,
> I'm not sure how to do this either, obviously I am new to all this)

OpenOffice.org's Base ( http://www.openoffice.org/product/base.html) says
that it can read Access files. It has a native OS X port. I haven't used
it recently, so I can't offer comment on how well it works.