M
Maurice
Hi, any thoughts on this one appreciated...
Situation:
Access 2007 front_end - linked tables to SQL 2005 on Vista SP1 client.
Performance is dramatic so i'm investigating all possibilities here.
All proposed options in other threads are applied. Installed every hotfix
available. When I look at the table design I see that subdatasheet name is
set to [auto]. So to be sure that this would not be a bottleneck I tried
setting this to [none]. You've guessed it not possible in a linked table. So
I did the following:
I created a new empty database. From the old database I created a maketable
query from the linked table and ran it to create a table in the newly created
db. All goes well so far. In the new database I set the subdatasheet name
option to [none]. Save the table, check it to see if it actually saved it,
correct is saved as [none]. So at that point I decide to upsize only this
table to see what happens. Upsize went well and when I open the table and
look at the subdatasheet name property it is set back to [auto]. So on one
hand we try to apply as much tips as we can and on the other hand this
property is set back to [auto].
So question is... can this be set to [none] once upsized or am I stuck with
this perfomance issue?
Thanks for your time
Situation:
Access 2007 front_end - linked tables to SQL 2005 on Vista SP1 client.
Performance is dramatic so i'm investigating all possibilities here.
All proposed options in other threads are applied. Installed every hotfix
available. When I look at the table design I see that subdatasheet name is
set to [auto]. So to be sure that this would not be a bottleneck I tried
setting this to [none]. You've guessed it not possible in a linked table. So
I did the following:
I created a new empty database. From the old database I created a maketable
query from the linked table and ran it to create a table in the newly created
db. All goes well so far. In the new database I set the subdatasheet name
option to [none]. Save the table, check it to see if it actually saved it,
correct is saved as [none]. So at that point I decide to upsize only this
table to see what happens. Upsize went well and when I open the table and
look at the subdatasheet name property it is set back to [auto]. So on one
hand we try to apply as much tips as we can and on the other hand this
property is set back to [auto].
So question is... can this be set to [none] once upsized or am I stuck with
this perfomance issue?
Thanks for your time