connecting Access database on local apache server

[rudodoo619]

I have coldfusion installed as a multiserver configuration running on both
Apache and IIS. Is it possible to use coldfusion MX7 to connect to an access
database while running on a localhost Apache 2.0 server? If not would it be
better to use MySQL as my database?

When I connect to the database with coldfusion administrator it seems find,
however when I try and test it using dreamweaver mx 2004 all sorts of issues
pop - up. Also, do I have to copy the Access DB and make sure that it is in
my web root directory? or can I leave it in My Documents?

[TurboMini]

The acess db does not have to be in the web root -- better that it not be for security's sake

what are you doing to test in dreamweaver? are you able to make a DSN through the CF administrator?

[rudodoo619]

Well, I am trying to run a simple recordset query and everytime I click on test
a whole screen of errors pop up. I think it might have something to do with
the ODBC driver.

I get the following message " -1, Syntax error in FROM clause"

[TurboMini]

"syntax error in FROM clause"

is there something wrong with the sql statement itself?

[LL@Work]

Paste the cfquery code to the forums here and someone should be able to help

[rudodoo619]

I will just work on it later. Once i get to know coldfusion a little better