What is the benefit of SQL

[Gigi]

What is the benefit of SQL insteatd of keep data in access?

 

[jlheath]

What steps are needed to move to SQL server from Access?
We have Access databases that use forms & switchboards as
our user screens. When our SQL team copied the database
onto the server, only the tables come through. They say
that I need to know how to connect/link my queries/forms,
etc. to the db on the server. What do I do next?

-----Original Message-----
G> What is the benefit of SQL insteatd of keep data in
access?

It's more reliable when multiple users are accessing the
same data. Or for very large databases.

 

[Vadim Rapp]

j> What steps are needed to move to SQL server from
j> Access? We have Access databases that use forms &
j> switchboards as our user screens. When our SQL
j> team copied the database onto the server, only the
j> tables come through. They say that I need to know
j> how to connect/link my queries/forms, etc. to the
j> db on the server. What do I do next?

Access has an upsizing wizard that converts mdb to adp. But, before diving into
it, I would suggest some training in order to appreciate its workings:

create a sample simple mdb

using upsizing wizard in access, upsize it to sql server

examine the result. This will give you the picture of how it works. Then you
are ready to move on to the live project.


Vadim