Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
provo
Starting Member
3 Posts |
 Posted - 2008-01-07 : 08:32:30
|
| We have a huge Access database located on a server, but now it is going very slow due to the transport of Mb file to the clients.We could export the tables to a SQL server and attach the tables to the access clients. So the question is, will access still treat the tables as it use to or could we expect access SQL querys to request the sql server as normal. Will access process the query on the client side?ThanksProvo |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-07 : 23:01:11
|
| You can still use access as frontend to pass sql queries to sql server. |
 |
|
|
provo
Starting Member
3 Posts |
Posted - 2008-01-08 : 02:57:18
|
| Yes i know that, the question was: would access (as a client) transfer the whole table, as it does with the original access tables, or just the selected records? I am thinking of network load. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-08 : 22:41:29
|
| Just selected records if tables are on sql server and you don't link them in access. |
|
|
|
provo
Starting Member
3 Posts |
Posted - 2008-01-09 : 02:10:47
|
| Ok got you, Thanks |
|
|
|
|
|
|
Migrating from access to MS-SQL