Re: Access 2003
Unless you use any special Access functions, everything is supported in MSSQL, including a lot more. Queries are now called Views, you've got Stored Procedures and a lot more other features. You can easily import data from the DB into Excel, both by code, but also by using the Excel wizards.
MSSQL is vastly faster, and it's file footprint does not increase the same way as with Access.
The only downside is that unlike Access, the MSSQL databases cannot just be opened by a doubleclick. You have to use Enterprise Manager to edit the databases, and you have to have a central server that hosts them. Furthermore the Enterprise Manager isn't meant for typing in data like you could do in Access.
|