Which would be a more efficient way of creating a medium size (40-60 user) client server application using SQL Server?
1. Access Project using ODBC linked tables to view local Access data.
or
2. Access .mdb database with linked tables for SQL server data.
I would like to use local data for user specific settings and tables that don't change very often but by far most of the data will be on the server.
Thanks
1. Access Project using ODBC linked tables to view local Access data.
or
2. Access .mdb database with linked tables for SQL server data.
I would like to use local data for user specific settings and tables that don't change very often but by far most of the data will be on the server.
Thanks