Here's what I use to add users to specific databases... it should get you started.

Function CreateNewSQLUser(NewUserName As String, SQLdbName As String)

On Error GoTo PROC_ERR

Dim bsSQL As String

...

Please try this:

In the mdb, go to the tools/options menu and make sure that "Hidden Objects" and "System Tables" are checked, so you can see them in the database window.

Then,...

If the same user on a different machine can perform the task than the problem is with the PC.

Suggestion:  Open the database on your machine, make the link there, and...

Can you create a dsn from the Control Panel (data source), completely outside of Access?

Can you retrieve data from that table in the SQL database from within Excel?

Have you...

Is this a new machine?  If so, sometimes not all the wizards get installed when installing Access.  You might try going to the add/remove programs and click change for the...

Okay, you may have to do a custom link tables instead of using the built-in one.  You would create a table listing the tables you want them to see, with...

I think if you open a new windows application and paste the .bas code into it, making the appropriate references to the DTS Com components, it should be close to...

In a standard (non-form) module, paste the following:

Option Compare Database

Option Explicit

Global myStart As Double

In your form, set the timer interval = 0.  In the afterupdate of your control, or form_current...

Do you want all elements to display this same sum from this total element?

If so, make the summation query as a separate query, perhaps "qryTotal".  Then, in your separate element...

You create a new project with that bas file.  Add references to these three libraries:

Microsoft DTS Custom Tasks Object Library

Microsoft DTSDataPump Scripting Object Library

Microsoft DTSPackage Object Library

You should then be able...

Ritesh, please read my reply in your question

"workgroups probs and security"

Hopefully, it will explain the situation better.

Thanks,

Metra

On the structure of your report, are ALL required tables temporary, or are you using some permanent ones? 

If you are using some permanent ones, have you tried making temporary...

The problem is that scheduled jobs run under the account that registered the SQL Server, not under the dbo account, not under the account in the connection string, etc.  This...

Can you check the permissions for the accounts running the task or transformation on the working machine and make sure you're using the same accounts on the non-working machine?  Oracle...

An ADP would only be of benefit here if ALL the tables used are from the same SQL database, there are no Jet tables in use, and no ODBC links...