ACCESS to SQL convertion

[adi32]

I have an Access 2000 db with tables in my computer and the client application (linked tables forms reports) in 12 client pc’s
I want to upgrade from access to sql server
It is easy that?
How the clients will be working after this conversion with access or with another application?

 

[crosmill]

If you want to keep the Access front ends for it then it's pretty simple, SQL server and Access both come with ODBC drivers to connect to each other.

All you have to do is link the tables into the back end Access db and give them the same table names, everything 'should' slot into place nicely, but, as always, it never does.

You should also migrate your queries to SQL server, I've noticed a performance drop when runing against linked tables, but if you get Access to call a SQL Server stored procedure the performance dramitcally increases.

Hope I answered what you wanted.

 

[adi32]

it is possible to totally remove the access?

 

[crosmill]

Yeah but your users will still need a front end unless they can all write SQL.

VB (I think) is the prefered front end for SQLServer db's but it really depends on what your going to be doing with it.