Data Access Page Help

[SteveCarrier]

I have a database with a bunch of tables and procedures that manipulate the data in the tables. Everything works great but now I need to make the data available to be edited or accessed through some data access pages. I realize now that these pages used slightly different VBSCRIPT coding rather than VBA. Instead of re-writing all of the procedures(50 pages of code) I was hoping that you can reference specific modules of the database and procedures within the modules. For example, if I have a button on a data access page and I want the button to run a PageManager() procedure within a module called modPageManager, can I call this from the VBScript of the button.

If anyone knows about these Data Access Pages I would really appreciate some advice!

Thanks a ton in advance.

Steve Carrier

 

[FancyPrairie]

I don't believe you can reference the modules from within a data access page. However, you could create a text file (i.e. YourProject.vbs) and copy and paste your code in the text file. Then include the text file in your data access page. However, you will have to make changes to your code since vbscript only supports variants not strings, integers, etc.