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.
| Author |
Topic |
|
cdconsulting
Starting Member
1 Post |
 Posted - 2007-11-15 : 17:59:27
|
| I Have read a few of the postings and I hate to beat a dead horse. But I am desperatly looking for your Help...I am converting all of my Access Databases over to SQL server 2005. but the catch is that I need to keep Access as my front-end. One of the problems that I have faced (and there maybe more) but when it comes to running queries (especially Delete), I cannot seem to get things to work.I would like to just store all of my data in SS2K5 and have all of my queries and forms run in Access.Why is it that I am getting errors that do not seem to make sense (Access Error 3086) when I have opened up all of the permissions associated to my database?Please let me know if anyone has any type of solution, or some place that I can go to that will help me understand this a little more.my query is pretty simple.DELETE Opsec_View.*FROM Opsec_View; |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-15 : 22:15:32
|
| Wrong t-sql syntax, try this if you want to delete all rows:delete from opsec_viewBy the way, is it a view? How did you pass sql query in access? |
 |
|
|
|
|
|
Delete query in Access w/SQL Back-End