If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
blank form, can't insert new record
John,
I could be way off base here, but this problem has similarity to a post I currently have in the ...public.access NG. 4/14/10 1:58am "AdminUser = form works - User = form fails" Myrinda wrote: I confirmed the permissions for the query and form to allow insertions and edits. In an FrontEnd/BackEnd database, one user could not update a table. No add, edit, delete... but Admin could. It appears that when we gave that User table permission via the FE, that did not work. When we went to the BE, and worked the Tools/Security permissions through the BE... voila... that user could now run the form, and edit and update the table. Never ran into that before... It's like doing realtionships in the FE. They don't have any effect. The BE realtionships have the control. Again... apologies if I'm may be way off base on this... Al Campagna "John W. Vinson" wrote in message news On Tue, 13 Apr 2010 08:27:02 -0700, Myrinda wrote: The table feeding the query is a linked SQL database. I do have other forms/queries from the same table that allow insertion and editing. I just can't figure out why this one won't. I've recreated the query just to be sure I have all the correct fields (and because it used to work!) but I'm not sure what the problem is now. What do you think? If this query isn't updateable, there's something corrupt. I'd suggest copying and pasting the SQL out to Notepad; delete the query; compact and repair the database to clean out any residuum; create a new query, go to SQL view without adding any tables, and copy the SQL back in. -- John W. Vinson [MVP] |
#12
|
|||
|
|||
blank form, can't insert new record
On Wed, 14 Apr 2010 06:29:02 -0700, Myrinda
wrote: Yes, it is possible to add and edit records in the linked table and it updates in the SQL database too. There is a primary key, which shows when you view the table in design view. It's an Autonumber ID field. See Al Campagna's response to me in this thread... does this user have SQL insert permissions on the table? -- John W. Vinson [MVP] |
|
Thread Tools | |
Display Modes | |
|
|