Jane,<BR><BR>if we're talking big enterprise-size databases, SQL wins over Access hands down due to the fact that it's designed for multiple databases, multiple connections (Access is OK until, oh, say 7 people get onto the database at the same time) etc etc.<BR><BR>Have a look at the Access and SQL sites at Microsoft.com for a better comparison. You can use Access (an Office product) for ASP work but you could also cross the Atlantic on a raft.<BR><BR>Franco<BR>email@example.com<BR><BR >
In order to use Access, the .mdb file must live on the Web Server. I don't think you'll have much luck with this in a "multinational" environment. The user IUSR_workstationname can't normally access other machines on a network. Use SQL Server and you'll save yourself a lot of frustration.