I currently have a web based application built using Access 7.0 and ASP's
The higher-ups want to move it to SQL Server 6.5
I'm fairly new to working with databases, and am a bit lost...(this might be
an understatement - depending on the humor you find in my next question)
What is SQL Server 6.5 - I've read the information on Microsoft's site and
still have questions. So I thought I'd come to the experts..
I am familiar with Access, and SQL Sybase Anywhere, after that I'm dead in the
#1 How does SQL Server compare to Access - I am not asking about performance -
I have no doubt that SQL Server is much more powerful. In general terms am I
going to use SQL Server the same way as I use Access?
#2 When I upgrade to SQL Server - Is Access now out of the picture? The data
from Access will now be in what format? What is the file extension on an SQL
Can anyone help or point me in the right direction for more information?
Much thanks in advance...