Access -> SQL upgrade

[stingers]

I am currently upsizing an Access 97 database to a SQL/Access solution. While I am an experienced access user I am pretty new to SQL. We have chosen to upgrade due to performance problems with our current database due to number of users(15) all making frequent updates, table size, and poor programming (by a previous programmer)

My questions are; will we see substantial performance gains using Access/SQL if the Access db is an MDB or should I go with an Access Project (adp) Is there that much of a difference between using bound and unbound forms?

I would appreciate any pointers, useful links etc.

Thanks in advance

Ryan Paul

 

[hermanlaksko]

Hi Ryan

Yes you will get an increased performance and data security boost for your base.
I would start using the current program (mdb) and connect this to your SQL server after upgrading your current data-database (mdb)to SQL, via an ODBC driver.
Later I would, once this is up and running, change my program to an adp file.

Michael