Solved

Access, SQL Server

Posted on 2010-08-26
11
530 Views
Last Modified: 2012-05-10
I'm trying to execute a store procedure (just simple like 'TRUNCATE TABLE tablename') through a pass through in Access, but it give me a run-time error '3325' saying 'Pass-through query with ReturnsRecords property set to True did not return any records', please let me know why
0
Comment
Question by:qnryat
  • 5
  • 5
11 Comments
 
LVL 44

Accepted Solution

by:
Leigh Purvis earned 500 total points
ID: 33534793
Because an action such as 'TRUNCATE TABLE' doesn't return any records.
You should set your Returns Records property as False in the query properties sheet (assuming it's a persisted querydef and not just created on the fly).
0
 
LVL 2

Expert Comment

by:bgrandjean
ID: 33534797
Open the query in design mode and open the properties window.  Set the Returns Records property to No.  Access generally expects a query to return rows and this setting property will tell it not to expect rows.
0
 

Author Comment

by:qnryat
ID: 33534862
I set the Returns REcords to no, now I get the error with server log in, here's how I call the sp with a
docmd.openquery passthroughqueryname
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 44

Assisted Solution

by:Leigh Purvis
Leigh Purvis earned 500 total points
ID: 33534893
You still get the error if you open the query by double clicking it in the DB window / Nav Pain?
A problem with the server login is just that.
You need to make sure you have valid credentials assigned.
What is your query's Connect property (obfuscating any sensitive details as required of course - i.e. don't give us all your password ;-).
0
 

Author Comment

by:qnryat
ID: 33535052
yes I still get the error by double clicking on it in the db window. No password require, I was able to open the Sql table in the db window
0
 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 33535446
And does the passthrough have the same Connect property as that linked table?
0
 

Author Comment

by:qnryat
ID: 33535575
How do I set the connect property in the query so that it will point to the right datasource without having it popup to select the datasource?
0
 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 33535643
What is your Connect property currently??
0
 

Author Comment

by:qnryat
ID: 33535772
It was just "ODBC;" then I added PSF_GEN so "ODBC;PSF_GEN" which is the name of the server, and it's working now. But if I don't want to create a passthrough query, but instead having a docmd, what would it be?
DoCmd.RunSQL ("Truncate Table....) or how do I specify the connnection in the docmd statement?
0
 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 33535828
You're sending a command to the server.
You can't trivially just execute that locally - that's exactly what passthroughs are for.
If you enter a valid Connect property you won't be prompted for anything.

If you want to execute commands in a more ad-hoc manner then you can use a variation of the theme in this recent thread - but it'll take a bit of VBA understanding.
0
 

Author Comment

by:qnryat
ID: 33535939
I got it. Thanks.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question