subdatasheet question

  • Thread starter Thread starter EAB1977
  • Start date Start date
E

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.
 
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
 
Back
Top