Copy a form from one protected database to another

[VBAjedi]

This should be stupidly easy, but it isn't working. I want to copy a form and a query from one Access 2003 database to another. Each database has User-level security applied, and they use separate .mdw workgroup files.

With both databases open (logged in to each as an admin/full permissions user), I've tried both copy/pasting and dragging the form across between them, but I get an "You do not have the necessary permissions to use the 'Source database filepath.mdb' object." error.

What gives? Can you not copy objects between databases that don't share the same .mdw workgroup file?

VBAjedi

 

[MajP]

What about exporting to an intermediate unsecured database then importing from there?

 

[VBAjedi]

Good idea, but when I tried copying the form to an unsecured database I got the same error. So that at least narrows the issue down to being something to do with the source database.

I've confirmed that the "Admin" group has Open/Run, Read Design, Modify Design, and Administer rights for the form I'm trying to copy. I also tried assigning those same rights to the individual login I'm using. Still get the error...



VBAjedi

 

[VBAjedi]

Ok, it wouldn't let me COPY objects to another database, but I just discovered that it will let me EXPORT them (interestingly, it let me push them straight into the other protected database even though it was closed - maybe because I left that instance of Access open after I closed the database).

Problem solved!


VBAjedi