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

OK, a supplementary if I may!

I am accessing the remote MySQL database using com.mysql.jdbc.Driver.
When I access the data by opening the table or using the form it is
read-only. Any ideas again?

John

On 17 October 2012 20:25, John Clegg <john.clegg@nailsea.net> wrote:

> 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