Ashfaque
06-12-2011, 09:18 PM
Hi,
I worked with a back end sql server (desktop edition) and front as MS Access for a single pc user with ODBC connection which was working perfectly.
Since the owner need more user, I am forced to use SQL server on a separate pc with Windows 2003 Server and connect 10 users around with MS Access front end on each pc connected to the SQL Server tables.
Until I develop back table on SQL Server, I have kept back end as Access and loded onto file server (root directory of Windows 2003 server drive) and simply linked tables on 3-4 pcs from back end. This way the traffic become very heavy and FE db is very slow as each table contains not less than 100,000 records. But this is temporary solution till SQL server tbl developments.
My question is I have only experience of ODBC connectivity and not the string type connectivity. So will ODBC connectivity provide the same speed like string connection what I heard from other programmers?
I know the main issue will be calling of unlimited records in FE will force to be slow down speed but I have used method to call very limited data on each forms (combo, list etc...)
But how about ODBC tables? Doesn't ODBC means same like link tables? I have no exact idea about if ODBC will fetch all records at the startup of db or it is just a symbol of connectivity and bring the required data from server upon request.
Please put some light on it....
Thanks,
Ashfaque
I worked with a back end sql server (desktop edition) and front as MS Access for a single pc user with ODBC connection which was working perfectly.
Since the owner need more user, I am forced to use SQL server on a separate pc with Windows 2003 Server and connect 10 users around with MS Access front end on each pc connected to the SQL Server tables.
Until I develop back table on SQL Server, I have kept back end as Access and loded onto file server (root directory of Windows 2003 server drive) and simply linked tables on 3-4 pcs from back end. This way the traffic become very heavy and FE db is very slow as each table contains not less than 100,000 records. But this is temporary solution till SQL server tbl developments.
My question is I have only experience of ODBC connectivity and not the string type connectivity. So will ODBC connectivity provide the same speed like string connection what I heard from other programmers?
I know the main issue will be calling of unlimited records in FE will force to be slow down speed but I have used method to call very limited data on each forms (combo, list etc...)
But how about ODBC tables? Doesn't ODBC means same like link tables? I have no exact idea about if ODBC will fetch all records at the startup of db or it is just a symbol of connectivity and bring the required data from server upon request.
Please put some light on it....
Thanks,
Ashfaque