I am using DoCmd.TransferDatabase to transfer 2 tables from one database to another. This works fine, however, the user permissions for those tables do not carry over with the table and I have to go into the database and set them as they were in the original database.

Simply, I want to allow complete access for all users to the tables in the second database.

Does anyone have a solution to this?

Thanks

Permissions are maintained in an YourDatabaseName.mdw, you external database has to have such a file also. If it does itn't exit, you can programmatically create it.

Litwin, Et's Access 2000 Handbook, Enterprise Edition has all the code you need. You can get it cheap on Amazon.com from a used book seller.

I bought a used second copy recently for my office for $15 on Amazon.com and the sller offered volunteered a 40% discount because he didn't have the CD that goes with the book.

I do have the Access Developers Handbook Enterprise Edition so I will check that out. Had no idea about the .mdw file.

Thanks.