#1.  Please don't double post.  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=17&messageid=203884

#2.  This is due to the fact that whomever is running the application from another computer doesn't have permissions.  Assumption:  You are running in...

IF you have foreign keys looking at that column you won't be able to do this.  You will need to remove them, change the column(s), re-add the FKs.  Other than...

Does the person have FILE SYSTEM access to wherever the LOG is created??

Assumption:  This DTS package is being opened and ran manually.

IF assumption accurate:  Does the person who is logged in to the PC that the DTS package is failing on have...

probably public for master and EXEC on the proc

1.  I would ensure that EVERY UPDATE, INSERT, DELETE query inside the Access database has "Use Transaction" property = FALSE/NO.  This will DRAMATICALLY INCREASE the size of your DB if...

Can you provide what the error (if any is)?  What is EM doing that you are not expecting?

I think you will need to run the above SP with AUTOFIX option..

If you need to IMPORT with TRANSFORMATION you will need to use DTS AFAIK.

Gram,

I think the error is also pointing to the fact that your "Current" database is NOT master which could be why the GRANT failed.

For Laughs ONLY (not intentionally making fun of anyone from Idaho)...

CREATE TABLE dbo.tblPotatoMonitoring

POPULATE TABLE

1x Potato, 2x Potato, 3x Potato, 4, ....

IF you have groups/roles (or even just have users created) set-up AND not everyone is in DBO arena THEN you need to GRANT permissions EXPLICITLY to be able to INSERT/UPDATE/DELETE.

Remi,

Here I thought my solution was ingenious and then (as usual) I see your's and go WOW.....

In addition to Remi's sage advice,

Is the index fragmented? Is there proper fill factor, How often is index maintenance performed to ensure NON-Fragmented indexes?

I know this is more maintenance-wise...

One IMPORTANT ITEM.

NEVER name your stored-procedures sp_ ....  This will cause performance problems and you will start getting confused as to what did I create v. Microsoft create.