data access pages- how do I set it so it's NOT read-only 2

[Focusfocs]

Hello All,
I am working with a Data Access Page in Access 2003 and am finding that I cannot add or delete any records due to the recordset being read-only...any suggestions on how to rememdy this? TIA

 

[PHV]

Take a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[FancyPrairie]

Set the Data Entry property of the Page to True. To see the properties of the Page, restore the form in design view (that is, not maximized), then select the title bar.

 

[Focusfocs]

Thank you both so much....I finally got it to work, and discovered there was a yet another reason why it wasn't working. You see, I 'inherited' this system from someone else who by the way has their own company for applications now...as it turns out, they never put a primary key within the table. That too, kept me from being able to use the data access page properly and somehow caused it to be read only. I know it sounds strange, but that's the only thing I can think of...Thanks again!!