new database

I'm trying to make a simple site using an microsoft acess database and cold fusion. My problem is I don't know how to access the database from coldfusion intially. Every other time i just entered the databse name as the datasource that's not working i'm not sure how to set up a dsn. Can anyone help????

Setup an ODBC connection to your access database. Then, in your Coldfusion administrator, setup your database connection for CF to use.

Read the docs please.

http://livedocs.macromedia.com/cold...r.htm#wp1235436

[QUOTE=kiteless]Read the docs please.
problem is I work for a large company and I dont think i have access to my coldfusion administator...i was wondering if there is another way around it????

If you are on ColdFusion MX and you want to set up a JDBC data source to an Access database, no there is no way around it. Someone with access to the CF administrator will have to set up the datasource. Even if you use the Windows ODBC applet to configure an ODBC Access DSN, I still believe that you'll need to create a DSN in the CF admin as a JDBC to ODBC bridge.

Actually, you might be able to do this by calling the undocumented CFMX administrator Java classes, but you're taking your chances if you try that route.

thanks for your help