Dear Simon:
Access includes Jet, a database. It also includes the database MSDE, a
version of SQL Server.
The rest of Access is a Front End. SQL Server does not include a Front End.
You cannot convert the Front End to SQL Server, only the data and queries.
Actually, there are things that are often implemented in an Access Front End
that can, and probably should be, moved to a SQL Server back end.
Do you intend not to have any front end at all? Or are you planning to
convert only the data and queries to SQL Server?
There is an upsizing wizard. I've used it, but then modified what it
produces. There are other differences that will require changes. There are
also usually significant opportunities to make the SQL Server back end much
better than what the wizard produces. But that's a starting point.
I do not think of moving from Jet to MSDE to be a switch from Access, but a
switch within Access. Perhaps that's what you want.
Tom Ellison
