Need help switching from ACCESS application to sequel server

[Kristen Shealy]

I am part of a small research group that would like to
migrate from ACCESS application to a sequel server. We
are currently using MS 2002. We need 5 or 6 users to have
access at any given time. How difficult is this to do?
How will this change the front end? What are the steps to
setting it up?

 

[Kevin3NF]

Access MDB or Access Data Project? Why do you need to switch? Do you have
a SQL Server person available?

In its simplest form, with a simple Access db, you can move the tables
pretty easily, and just link back to them from Access. Most things will
still work.

In the more complex variety (Access data projects), you will need ot convert
a good number of queries into stored procedures, re-define relationships,
etc.

Access can easily handle 5-6 users w/o going to SQL Server....