[libreoffice-users] Base - need to re-point a form

I have a base file attached to a MySQL database on a remote server. I have
a form that I use to view and edit the data in one table.

Others also access the database, and I need to experiment with the data in
that table without molesting the master copy.

One solution would be to make a complete copy of the database, but as I
want to make copies of the main table many times a day that would be a
laborious solution

It is easy to make a duplicate of the main table within the database, and
also easy to make a copy of the form in the base file, but what I need to
do now is point the copy of the form at the copy of the table.

I thought it might be possible to open the odb file as a zip file and find
the form data containing the table name somewhere in it, and edit it to the
copy table name, but I haven't succeeded yet.

Does anybody know if this is possible - or even if there is a much easier
way?

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted