Problem solve Get help with specific problems with your technologies, process and projects.

Turning data in databases into XML

I want to publish my Access 2002 database on the Web so that it can be accessed remotely by multiple users at the same time. What is the best method to do this, keeping in mind factors like security, multi-user access and queries?
Ninety-nine times out of 100, data that is in databases is better off staying in databases rather than being turned into XML. The exceptions to this are when you have complex graph structures and/or complex hierarchical structures. If your data is primarily tabular and you have it in a database, my advice would be to leave it there. XML may have no value to offer you. If you are happy with using Access, your best bet might be to look at ASP and use the IIS layer for security, etc. If your data is not tabular/relational in nature, then XML may have a sensible role.

Dig Deeper on Topics Archive

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.