[Serious] Browser Data Access

[Bruce Fox]

Hi VB'ers,

Scenario:
Currently data items (such as PDF's) reside on a server, and they are accessed thru an Excel sheet via hyperlinks - no biggy. In essence the xls is used to log changes, version status, who is uploading the new item etc, and the hyperlink to the item on the server.

Due to certain constraints this is the best method that could be used and has been in place for awhile. As I'm soon to be taking over part of this role, what I am thinking of doing is creating a GUI/Frontend that can be used to log etc the same functions as above. In short, get away from the user using the worksheet as such, and creating a web interface.

Suggestions please.


I'm not fishing for the best method to 'code' the GUI/frontend, but the appropriate method of capturing the data item configuration data (currently in the xls sheet).

Questions:
What is the best method of storing the item's configuration data (currently in the xls sheet)? Should i maintain it in xls and just create a frontend to the xls? What about an mdb file?



Cheers, 'n' Beers,

[penagate]

Export the current workbook to SQL and use either SQL Server or MySQL as your database backend. You will find it easier in the long run than trying to work with Excel or Access (neither of which are proper data storage tools).
There are some free Excel -> SQL export tools available on the net.