By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 943 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Data Accesss Page, Recordset is read-only

P: 3
Hi all,

I'm new to the site so please forgive me if I missed one of the guidelines that I read.

I have a large budget database using Access 2000. I'm trying to make the budget table into a Data Access Page. I create a new DAP in design view and drag the table over so that one record is displayed on the page at a time. The fields are not editable, and I need them to be. When I add a button to add a record and click it, a warning message displays, "recordset is read-only"

The properties in the header where the fields are stored are 'True' for dataentry, datadeletion, and dataedit.
I have created DAP's in the past, but they usually allow for editing without me having to do anything. I've been researching all over the web and haven't had any success yet. Any ideas?

Thanks,
Phil
May 17 '07 #1
Share this Question
Share on Google+
2 Replies


P: 3
I think I figured it out....

I had no primary key in my budget table, so the recordset cannot be updatable without a primary key. Is this right?
If so, I will have to look at the duplicates according to an ID number and delete them so there are no duplicate primary keys.
May 18 '07 #2

ADezii
Expert 5K+
P: 8,619
I think I figured it out....

I had no primary key in my budget table, so the recordset cannot be updatable without a primary key. Is this right?
If so, I will have to look at the duplicates according to an ID number and delete them so there are no duplicate primary keys.
  1. Just create an AutoNumber Field in the Table and Exit Design View. The AutoNumber Field should automatically populate for all Records.
  2. Go back in the Design View for the Table and designate the AutoNumber Field as the Primary Key.
  3. Go into Design View for the DAP and add the AutoNumber Field to the Header Section.
  4. You can now edit Records in the DAP.
May 23 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.