0

I'm working with MS access front end and sql server backend.I have created a Pass-through query and i have the "Exec storedProcedurename" in the passthough query.when i create a datasheet view for this pass-through query the fields are non editable.Is it possible to make the datasheet view fields editable?

user2514925
  • 931
  • 8
  • 33
  • 56

1 Answers1

1

Sorry but you cannot do this. Here's a previous answer on this topic:

How to make a passthrough / passthru query editable?

Community
  • 1
  • 1
David Rushton
  • 4,915
  • 1
  • 17
  • 31
  • Thank you for the response.Currently we are using View in the update-able datasheet and we are planning to change the view as it affects the performance.which is the best way to replace views in update-able datasheet? – user2514925 Dec 18 '15 at 12:12
  • Are linked tables an option you have considered? – David Rushton Dec 18 '15 at 18:47
  • What are the tables lacking that made you consider using an SP? If you wanted to apply logic on top of your data you can use views (you'll need to set a PKey to make editable - http://stackoverflow.com/a/20474851/2572928). – David Rushton Dec 20 '15 at 21:34