Posted by Jonathan Roberts on 02/04/07 04:12

Erland Sommarskog wrote:
>> Have you tried using the Upsize wizard?
>
> I have never worked with Access myself, but from people that hold
> expertise in both Access and SQL Server, I have heard strong recommendations
> of staying away from the wizard.
>
> Migrating from Access to SQL Server is quite an undertaking, and there
> are many differences. Not the least since Access since is more or less
> all-in-one, while with SQL Server you get a client/server setup.
>
>

Erland,

You're right; it isn't perfect by any stretch. However, it can be a
start. I did it a few years back when an app was breaking due to
Access' problematic use of file locks and networking. There are some
gotchas, but it saved me some time. Once upsized, you can create an ADP
fairly quickly to get your forms up and running (assuming you were using
Access forms in the first place as your interface).

Jonathan

[Back to original message]