I've seen this too. Sometimes it is caused by Access not knowing what the primary key of the table is. You should designate the primary key when linking...

If these really are a group of INSERT statements with values supplied, you can just put them in a TSQL step in a scheduled job without using DTS. You could...

You'll have to make the change in BIDS. I suggest writing the log to a text file.

Steve's got your third option. If you use either SSIS or scripting, you'll have to create the database first on the destination computer.

You could start with the import/export wizard and save a package if you want to move the same data again. See "Importing data, SSIS package" in BOL. Also,...

The fixed server roles have only the permissions described in BookOnLine under "Roles" (you can also see them by right-clicking on the role in Enterprise Manager and selecting "properties"). ...

It looks like the package couldn't acquire a connection to the database specified in the source connection manager. The first thing that comes to mind is to check to...

Please be more specific about the problem you're having. Post any error messages you receive.

Thanks

So, you want to create a copy of the database without the users? I can think of two ways to do it.

1. Backup the database and restore it in...

Great! Glad to help.

Right-click on the database name -> select Tasks -> select Generate Scripts... Follow the Wizard until you get to the "Choose Script Options" screen where you can turn those options...

I haven't seen this error before. What version of SQL Server are you using? I found this on KnowledgeBase and it refers to using SQL 7.0: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q274716

Since there's no such thing as SQL Server only authentication, you'll have to change it to mixed authentication mode and remove the Windows login that the other DBA uses to...

What do you mean by "full data access"? Do you want this group to be able to select, update, delete data only or do you want them to...

Are we talking developers or end users? What database roles and object permissions do the users have? End users shouldn't be dbo or members of any administrative database...