database doesn't show up when I add it

[tonysteve]

I am adding a MS access '07 database that I made, but when I go to add it and browse to it, it does not show up..Is there a reason why it is not showing up. I also get this message when I try to verify it:

Connection verification failed for data source: ask
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.

help!!

[paross1]

Where is your Access db file located in relation to your ColdFusion server (wwwroot)? This is telling you that CF can't find the database file, and it must be located where CF has access and the appropriate permissions.

Phil

[Guest]

You must install the MS Access 2007 driver on your system. ColdFusion does not do this for you. You then need to create an ODBC system dsn using window's odbc manager. Then create an ODBC socket DSN in coldfusion to use your database. See this forum thread for more info.

[tonysteve]

When I place another access file ( one which I downloaded off the web) in the wwwroot folder, it does show up.

For some reason some access files show up and others do not...Is this strange?