The should be no problem so long as the User that the Job is run under has the applicable access rights.  Are you user PONLEUR1\artmsss?  This user would need Read/Write Access...

The short answer is yes.  Here is an code example i just wrote using the Northwind DB:

CREATE PROC test_dyn_w_cur (@TableName as varchar(50))

AS

declare @SQL as nvarchar(2000)

Select @SQL = 'SELECT *...

locks is an advanced option. 

Use the sp_configure system stored procedure to change 

the setting, you can change locks only when show advanced

options is set to 1. The setting takes...

Try:

ALTER TABLE tablename

NOCHECK CONSTRAINT constraint_name

I agree with stacenic.  Look for why your package is returning an error.  If all of the steps that are supposed to run in the package are completing...

if putting quotes around your path will solve your problem, then:

""" & "c:\program files\etc\" & """

should do the trick.

Try something like:

DELETE FROM TableX x

WHERE x.DateFields < GetDate() - 21

You may have to do some formatting of your date field if it contains time.

Select GetDate() - 21 yields 2004-03-24...

Make sure you are running the same service pack for Analysis Services as is on the server.  Also, Analysis Services Manager caches some logon info, it's amazing what rebooting the...

Try installing the latest version of MDAC.

Try vbSendMail (freeware).  Its always worked great for me.

Hi Andre, Try Editing the procs that are performing the insertions, updates, deletes on your production server to include NOLOCK in the select statements, e.g.,

Insert Into TableX(a,b,c,d)

Select a,b,c,d From...

I've been challenged by this exact problem.  The VFP OLE-DB Driver does seem a bit janky.  I've had some success using the dBase 5 driver.  Try that.

Have you tried the SEEK method of the recordset object?  i.e., rs.Seek

The wildcard character in Access is '*' and not '%' like SQL Server or Oracle.  See if this helps.

Pete

It sounds like a permission issue.  Since you are using Trusted_Connection, make sure that the logged in user has the appropriate permissions to access the Data Source.  You may also...