database issues

[ssprouse]

I am trying very hard to have a SQL database with live data that is populated by a web form for registrants. I want someone at my office to have access to that data without having access to SQL. Is there a way to take the live data that is coming from SQL and have it in an Access database so that my coworker can run reports and keep track of who is registering for a specific course? Is there an easier way to do this that I am just not thinking of?

[chazzy]

you need to use a programming language :-)

[ssprouse]

I do. I use coldfusion and SQL for the online registration. I have access to the SQL data. What I want is for a coworker to also have that access to that data without SQL, possibly in a linked Access database where they could then view the data and run reports, queries, etc. What I don't want is for my coworker to have access to all my SQL data.

[ray326]

By "SQL" do you mean "SQL Server"? If you don't want to hand out access to the database server then the best thing to do would be to create the reports they need in CFL. Otherwise you can create a user id for them within the database manager and grant select on only the appropriate tables.

[yamaharuss]

You could also setup an admin page with user/password protection where she would login and view the data via preset queries in CFM.