Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

#Delete in Query

Status
Not open for further replies.
warthog72

warthog72

Programmer
Aug 13, 2003
42
0
0
US
Ok, I'm using SQL Server 2k as backend and running a query in access using ODBC linked to SQL tables.

Everytime I do a query on any SQL table, I get #deleted as the results. The field and record count is correct, but each field entry is #deleted.

I can use a pass-through query to view the right data, but anything else and I get #deleted.

Help, please. Thanks in advance.

Steve
 
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Delete query takes FOREVER to run 1
Replies
11
Views
99
jedraw
jedraw
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
184
TheresAlwaysAWay
TheresAlwaysAWay
Trob70
  • Locked
  • Question
There is no object in this control 1
Replies
9
Views
173
Trob70
Trob70
Moss100
  • Locked
  • Question
Create a Report from a query and then personalise the report for each client - possible?
Replies
2
Views
54
dhookom
dhookom
atadbitslow
  • Locked
  • Question
how to search data and display matches that include the user's input, but not necessarily match
Replies
5
Views
120
atadbitslow
atadbitslow

Part and Inventory Search

Sponsor

Back
Top