Hi all, I have created a data access page from a report in Access because I don't want users to use the db directly. However I find that macros, expressions and functions don't work. Also my data is collapsed and has to be expanded manually (a tedious prcoess for a 250 page report).
Should I:
a. Continue with my original plan. If so does anyone know how to expand a report by default when it opens? and does anyone know how to get command buttons working in forms exported as Data Access Pages?
b. Create a linked switchboard form in Access, let users into the database and hide everything (and pray they don't know enough about Access to 'unhide' everything).
c. Create something in Coldfusion to interact with the database (have to use CF, ASP would probably be better).
Thanks for your help
Steve
Should I:
a. Continue with my original plan. If so does anyone know how to expand a report by default when it opens? and does anyone know how to get command buttons working in forms exported as Data Access Pages?
b. Create a linked switchboard form in Access, let users into the database and hide everything (and pray they don't know enough about Access to 'unhide' everything).
c. Create something in Coldfusion to interact with the database (have to use CF, ASP would probably be better).
Thanks for your help
Steve