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 <[email protected]> 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: [email protected] 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
