SQL Server Backend: linked tables or no more bound forms ?

[byterbit]

Speed and file size issues are driving me to consider a server (MYSQL or SQL Server) back -end. I love Access of course, and want to keep the front end work anyway.


Can I be lazy and just link to my tables in the back ? Or must I dispense with bound forms and work at coding my data entry forms ?
I understand (tell me if I'm wrong ) that the speed issue with Access on a LAN is based on the entire MDB (it's already split) holding the data being brought over the network to the client computer. Will this happen anyway if the forms stay bound to a server backend ?

[pbaldy]

I work with Access/SQL Server most of the time, and most of the time use bound forms with no speed issues. Certainly SQL Server has some tools that can speed things up, but often you can just upsize the tables and the application will run fine.

[RRS415]

Check out this article might help you out: Import or link Access to SQL Server data.