access thread: Save a table under a unique name
Message #1 by ppana@q... on Fri, 17 May 2002 07:23:32
|
|
I want to save a table under a unique name. I have tried the following
code with no success. I keep on receiving the error message "The Object
isn't open" referring to line 3>. I do not want to rename the table, but
SaveAs.
1> DoCmd.OpenTable "OldTableName", acNormal, acReadOnly
2> DoCmd.Save acTable, "NewTableName"
3> DoCmd.close acTable, "NewTableName"
Please help.
Regards,
Paul
Message #2 by "Wesley Kendrick" <wez.k@n...> on Fri, 17 May 2002 09:25:17 +0100
|
|
Hi Paul, try the Copy Table method instead.
Regards, Wesley Kendrick
----- Original Message -----
From: <ppana@q...>
To: "Access" <access@p...>
Sent: Friday, May 17, 2002 7:23 AM
Subject: [access] Save a table under a unique name
> I want to save a table under a unique name. I have tried the following
> code with no success. I keep on receiving the error message "The Object
> isn't open" referring to line 3>. I do not want to rename the table, but
> SaveAs.
>
> 1> DoCmd.OpenTable "OldTableName", acNormal, acReadOnly
> 2> DoCmd.Save acTable, "NewTableName"
> 3> DoCmd.close acTable, "NewTableName"
>
> Please help.
>
> Regards,
> Paul
>
|
View Cart
