Access Front-End with Sql Backend Tables

[Rico S. via AccessMonster.com]

I have an Access database that I need to move the tables to SQL. I doing
this because there will be up to 25+ concurrent users and I know that Access
as a database can't handle that without performance issues.

My question is :Is it a good idea to still use Access as the front end and
use SQL server as the database on the backend? Or any other suggestions is
appreciated.

Thanks,
Rico

 

[John Vinson]

I have an Access database that I need to move the tables to SQL. I doing
this because there will be up to 25+ concurrent users and I know that Access
as a database can't handle that without performance issues.

My question is :Is it a good idea to still use Access as the front end and
use SQL server as the database on the backend? Or any other suggestions is
appreciated.

Absolutely. There's a Microsoft whitepaper at support.microsoft.com
describing the issues involved in this kind of upsizing; you'll want
to make some changes to your forms (they should return only a single
or very few records rather than being bound directly to a table, for
instance) but it actually will work nicely even without changes.

John W. Vinson[MVP]

 

[Pat Hartman\(MVP\)]

If you use the upsizing wizard, choose the option to link the tables to the
database. Don't convert to an .adp. That would involve a lot more work and
the .adp doesn't seem to be getting any future development effort so it is a
dead end.