Access database with reports to multiuser web interface
I have a client that ask me to convert an Access database to something web based. The database has 20 tables, 10 input forms (input of data is not done directly into tables), about 100 queries and 20 reports.
- I don't mind using mssql/c# but I would prefer using php/mysql.
- The client would like to have the ability to 开发者_JAVA百科create himself custom report like it's possible in Access (WYSIWYG interface to select tables and fields and possibility to add header, footer, labels, etc.).
- The solution can be something licensed but I would need something flexible as this is the first step of a bigger project.
Thank you very much in advance for your ideas/help.
Just convert the DB to Mysql and use an odbc driver to link access to the mysql db for report creation, what is the issue?
Maybe this tool or this.
精彩评论