access fields not showing!

[Adam - NDMX]

hi
my company has an access database that contains things like workorders, etc.
We'd like to set it up to publish to the web in a presentable dynamic format.
we dont have a sql server, i would like to use coldfusion instead of asp. for
now its just dev

i have downloaded trial versions of coldfusion and dreamweaver, and have been
following the tutorials pretty well, and it looks like it should work. however
i can't seem to access the fields in the tables in our database. i was able to
go through the coldfusion administrator and link up with the dev database so
that its a connected data source, however when in dreamweaver and i 'view
databases' and see mine, it says i dont have permission to work on the database!

do i have the right idea to use dreamweaver and coldfusion to get my access
database dynamically represented on the web?

[Vbprog40]

I dont use dreamweaver, Just notepad. But you are on the right track!

Take a look at this to build queries:


[url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/[/url]
wwhelp.htm?context=ColdFusion_Documentation&file=0 0000124.htm

[pdrich]

Adam, you have the right idea, but you don't have to use Dreamweaver to do
ColdFusion queries. Ifyou can get it working, though, It may save you some
time. Unfortunately, I'm not sure what the permissions problem might be.

You can query your database in the CFM file by simply using the <CFQUERY> tag
with SQL statements.

<CFQUERY datasource="yourdsname" name="qryMyQueryName">
select * from tablename
</CFQUERY>