I use Access for a front end and Sql for a backeend. Often, I need to create temp tables for the individual user in order to connect the linked...

This brings up another question (mainly to Andy). If you have a single front end app and a set of different tables for user's based on their location, what's...

OK, I think I found the problem. This database creates user-owned tables and if I de-select them, do the DTS without any perms, add perms later as a script,...

Ok, it still gets errors when I unmark all permissions under Security options.

NT LOGINS are used. I'm still getting the errors on this one database. HELP!

On exporting all objects, I don't see where you'd mark where NOT to copy users. Actually, I'd want to transfer user perms too. In the backup database, I...

Andy, I'm on SQL2000 doing TRANSFER OBJECTS (all). It works on all other databases but this one and I wonder if it's because it has some PUBLIC permissions.

A MILLION thanks! You just saved tons of time! XOXOXOX!