CopyObject Error

[EddiRae]

I have an application that is creating pivot tables for multiple users from a base form. This form is copied to create the users pivot form with their name as the form name.

What is happening is that if a user has the database open and has his form open, the next user gets an error on the copyobject:

The error I get is error 2501 - The CopyObject action was canceled.

The command is as follows:
DoCmd.CopyObject , strFlagChartName, acForm, "pvtFlagChart"

Is there a way to be able to do this?

Thanks for your help in advance.
Eddi Rae

 

[Uncle Gizmo]

Are you using the front end, backend type of multiuser database setup?

 

[EddiRae]

Yes. The only thing is that the form is on the Front End. Should I have it on the back end?

 

[Uncle Gizmo]

And each user has their own front end database on their own machine, In other words they are not simuiltaniously using one central copy of the front end?

 

[EddiRae]

No ... They are using the same front-end on the server. Is that where I am going wrong?

If I have changes to the front-end, how will all the users get the latest version?