Getting Rid of Access

[spazman]

I have been asked to see if we can remove MS Access from user stations the next time we do a system upgrade. 99% of the firm only use Access to print our DB driven floor maps. Everthing else I can easily convert to ASP pages all the reports / user entry screens etc etc. The floor maps are my stubmling block. What they are (I didn't create them so this is a brief explanation) is a Form with text boxes assigned a number, the office number, this gets matched to the DB field of office number and it prints the user info for that office. Can any one think of way to do this, not code just thoughts, as in we do it this way, or you could try this. I was think of putting access on the web server and user server side scripting to print just the floor maps, but then thought this may be against MS licencing (if you know this is not the case let me know)

 

[snowboardr]

If you want to "switch" your database I would go with MySQL any day of the week or year for that matter...

I have a pretty decent tutorial that is pretty straight forward on importing an access database over to MySQL..

http://www.vzio.com/tutorials/mysql_database.asp

www.vzio.com
ASP WEB DEVELOPMENT

 

[spazman]

All my data is already is MS SQL, Access is for the user front end. It's what generates the reports and maps, data entry screens.

 

[rollout369]

I don't see why you can't put Access on the server and then create the maps using ASP. This wouldn't require licenses--it would be the same thing as using Access on a website to generate pages.

=========================
rollout
=========================

 

[spazman]

I should check with MS, I don't think without a huge amount of work that I could transfer the maps to ASP pages, I was thinking of just using server side scripting to open the Access DB and print the maps f0orm a command line.

Thanks for the input.