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  Other Forums  MS Access  Delete records on SQL Server through Access

Author  Topic  stf27 Starting Member 1 Post Posted - 2012-06-04 : 16:13:26 Hey guys, Problem: I have a database set up in SQL Server. It gets data from a form people fill out in Access. I'm trying to create a button that will delete a record if they decide, for whatever reason, to delete it. The problem is, when I try to create a macro to delete a record it won't delete. The only way I'm able to delete a record is if I manually go into the SQL server database and delete it from there. Question: Is there a way to delete a record on my SQL server database through Access? FYI: I'm using Access 2010 and SQL Server 2008 Any help is greatly appreciated!