Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  help with stored procedure called from MS access

Author  Topic  rnoJoe Starting Member 4 Posts Posted - 2007-03-07 : 17:31:26 I am not a Sql programmer and need some help with writing a stored procedure. I have an access database application and would like a User to be able to insert sensitive information in a table located on a sql 2000 server. This db has multiple user s and I don’t want everyone to be able to see the real data. I created a linked temporary table to store the sensitive data and now would like to be able to automatically run a stored procedure that moves that data from the temporary table to the real table. Best way I can explain it is this ***In the access database I have a Form for user to enter info into The user clicks a save button that puts the data into a linked temporary table. I Need help writing code in the access db that runs a stored procedure on the sql server Returns a message if that record already exists or if successful Clear out temporary table Need help writing Stored Procedure that looks something like this Create procedure Blah blah blah Check real table to see if record exists If so then Return exists message to access db Else Insert into realtable Select * from TempTable Return successful message End IF Thank you so much for your help