April 8, 2009 at 4:05 pm
I have a front-end tool that is done through an Access project and all of the back-end is setup on sql server. I have a non-system admin user that utilizes this tool everyday. Sometimes, when the user runs the tool, it gets to a point in the program, where its supposed to insert records into a table, but the insert does not work and the program just completes without this run. This only happens some days. I have turned on all of the permissions so this user can write to this table and set it up so the user can own the database. Does anyone have any suggestions what could be going on? I've ran a debug trying to check for any duplicate records for this insert into the table, but no duplicates exists.
April 8, 2009 at 4:14 pm
Do you get any errors while doing this and also what permissions this user has got?
April 9, 2009 at 11:21 am
No, we are not seeing any errors when running the stored procedures.
I setup this user to have full access to this database so they are able to read and write to the necessary tables.
I have a feeling it could be the users profile setup on the Windows Server 2003. What do you think?
April 9, 2009 at 11:25 am
I assume the user has EXEC authority to the stored proc in question?
Francis
April 9, 2009 at 11:28 am
Yes they do.
April 15, 2009 at 2:43 am
Maybe the transaction is being rolled back because of Triggers?
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 15, 2009 at 7:31 am
Using Profiler may be the best way to figure out what is happening. Profiler output can get pretty large so you probably don't want to leave this one for a long time but if you can manage to recreate the error the profiler output may help a lot. There is a free download of a book on http://www.sqlservercentral.com/articles/books/65797/ which may help.
Francis
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply