SQL server based Access system design

[David]

When designing an Access system that will be based on
linked SQL server tables, what is the best strategy to
use. Should I start by creating a solely Access based
system first and then linking it to SQL Server at the end.
Or, should I create the SQL server tables first and
proceed that way.
This is a re-write of an existing system so I already have
some data in Access that I can use, if I proceed that
way.

 

[Jeff Boyce]

David

If you are conversant in SQL-Server, you can use the DTS to create your
tables from your existing Access data at any time. Remember permissions.

My experience in converting from Access data to SQL-Server has been that I
had to revisit my queries, forms and code. There are enough differences
that I needed to do considerable tuning.

For one thing, Access creates a primary key when you start adding a new
record, where SQL-Server doesn't create a new key until you save a new
record.

Good luck

Jeff Boyce
<Access MVP>