data access page

[cbearden]

i have a problem with one...actually every one i have made(except one which actually worked).
i make the page and run it. it will allow me to scroll through my records but will not allow me to enter any in. i haven't changed any settings to the page. could osmeone help me.

thanks

 

[___]

This could be a Primary Key problem. Try opening the Table on which the Page is based in design view, and set one of the fields to be the Primary Key, If this does not fix the problem you may have to recreate the Page after you have set the Primary Key.

 

[cbearden]

This could be a Primary Key problem. Try opening the Table on which the Page is based in design view, and set one of the fields to be the Primary Key, If this does not fix the problem you may have to recreate the Page after you have set the Primary Key.

Thanks for replying

i just tried to add a primary key but when i went to save:

"the changes you requested to the table were not successful b/c they would create duplicate values in the index, primary key, or relationship. CHange the data in the filed or fileds that ocntain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."

I hit ok...then

"Errors were encountered during the save operation. Indexes were not added or changed"

THe field i'm using is for a VIN. So there is no duplicate fields.

 

[___]

You could also try opening the Page in design view, select properties and the 'All' tab and view your connectionString. Click the '...' button and in the 'Data Link Properties' dialog box click the 'Advanced' tab. Check that the correct security settings are enabled. If 'Read' is selected change the security to 'ReadWrite'.

 

[cbearden]

You could also try opening the Page in design view, select properties and the 'All' tab and view your connectionString. Click the '...' button and in the 'Data Link Properties' dialog box click the 'Advanced' tab. Check that the correct security settings are enabled. If 'Read' is selected change the security to 'ReadWrite'.

i don't seem to have that option, "connection string"

 

[cbearden]

I went back to my table and deleted all my records(luckily the db is in the working so the info is not important). I made a primary key and then i added information to the table. I opened up my dap and it did work. i can now add and delete. thanks for your help!

 

[___]

Glad you got it working.