subdatasheet question

[EAB1977]

I have a Access 2000 file format database in Access 2003 and I am
trying to change the subdatasheets selectuion from Auto to None. When
I try and save the changes, it saves, but when I go to try and confirm
that the changes were made, they were not.

Is this a setting that a user can change in a linked table? I am
getting horrid performance when I am trying to do a query via VBA.

 

[Jeff Boyce]

The key is in your next to last sentence...

If the table is a linked table, it isn't really in your Access file. So
when you attempt to change a property of that table from the "front-end", it
doesn't happen. That's as it should be! After all, if you had a table you
controlled that others linked to, would you want them to be able to change
its properties?

Go to the Access file where the data is actually stored and make the change
there.

Regards

Jeff Boyce
Microsoft Office/Access MVP