A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

blank form, can't insert new record



 
 
Thread Tools Display Modes
  #11  
Old April 15th, 2010, 12:13 PM posted to microsoft.public.access.forms
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default 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  
Old April 15th, 2010, 05:16 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:05 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.