Hi,
I have had this same dilema and have used a variable to construct a statement and then execute it - here's an example that works for me. you will need to change the table name obviously. and ofcourse the @Pvar variable can be have multiple values, or a null.
Declare @PVar as Varchar(80)
declare @SqlStr as Varchar(8000)
Set @Pvar = '12141,12142,12 143'
set @SqlStr = 'Select * from tblInvoice '...
Sami Ward
Last Activity: Feb 19 '08, 02:29 PM
Joined: Nov 1 '07
Location:
-
Hi Jim,
Thank you very much for your reply. I tried looking at the proxy thing, but after much fiddling about couldnot get the thing to work. Set up a DTS instead and called that from the procedure by using the
EXEC msdb.dbo.sp_sta rt_job @job_name = 'dtsPackageName '
and the same happened worked for me but not the user - because this need to use a proxy account too.
in the end I went to the Security section...Leave a comment:
-
Hi,
you can move this to SQL Server forum if you like, I don't mind.
thanks....Leave a comment:
-
Hi Jim,
thank you very much for your reply. we SQL Server 2000, and I have created an Access 2003 adp to link to the database in sql Server.
there is a group set up, which all relevant users are added to.
the group has access to read, write and execute queries.
everything works fine. all procedures seem to work ok, and users can create tables and update no problem.
the only issue I had was using the transferText...Leave a comment:
-
Hi,
have checked permissions everywhere I can think of, for the user, and all looks fine.
I don't think you can use t transfertext method in access data project. there doesn't seem to be a way of creating a specification/template for export format, where I can tell it to use tab as a delimiter.
triedtput to method, but that does not give the required result in the text file.
any other ideas of how to get a table...Leave a comment:
-
Error 7874 Can't find the object tableName
I have an an MSAccess data project front end linked to an SQL Server Database.
I keep getting Error number 7874: database cannot find the object tblname
when I look however the table is there.
I am calling a procedure which deletes all records in the table and then repopultates it with new records.
so the table is never deleted and recreated.
Once the procedure has run, then I transfertext the table to a local...
No activity results to display
Leave a comment: