Ask Your Question
0

HOW CAN I ADD TO OBJECTS THAT I HAVE IMPORTED FROM ACCESS

asked 2015-08-18 14:50:03 +0100

JOHNJDEC gravatar image

updated 2015-08-21 15:42:57 +0100

Alex Kemp gravatar image

I HAVE [Connected via SDBC Driver] ACCESS TO LIBRE BASE; VERSION 4.4.5.2; BUT I CANNOT ADD ANY NEW FIELDS TO ANY OBJECTS.

ATTACHED PLEASE FIND DATABASE FILE: NEW DATABASE 1

ASLO, I CANNOT INCREASE THE SIZE OF THE FORM ON THE SCREEN

ANY HELP WOULD BE GREATLY APPRECIATED

USING WINDOWS 7 HOME PREMIUM

[edit: added lo4 + win7 tags]

edit retag flag offensive close merge delete

Comments

I have edited the question to clarify that the LO database is connected via SDBC driver to MS Access, meaning that Access/the driver is providing back-end functions.

doug gravatar imagedoug ( 2015-08-18 23:56:35 +0100 )edit

the database was emailed offline. Since I do not have the back-end Access mdb I only receive a message when opening that LO cannot open the back end. There are no objects saved in the LO database front end, and all of the menu commands that would provide for those functions are greyed-out, meaning they are inactive.

doug gravatar imagedoug ( 2015-08-18 23:59:34 +0100 )edit

Without the Access database it is not possible to test. As this may be commercially sensitive (from the db name) can you get a copy of the Access db with all data removed posted here - just the empty tables?

peterwt gravatar imagepeterwt ( 2015-08-19 22:47:39 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2015-08-18 23:52:15 +0100

peterwt gravatar image

I don't know of a way to directly convert an MS Access database to a LO Base database.

Do not see any database attached to this post.

You can create a Base database and create an ODBC connection to an Access database. This will allow you to see the Tables in the Access database but you cant see the Forms, Queries, or Reports in the Access database. You can modify the design or create new tables and carry out data entry on the attached Access Tables. You can create Forms, Queries, and Reports in the Base database to operate on the Access Tables. Any changes you make to the Tables will of course be modifying the Access database, If you wish to have a stand alone version of the Access database you can create another Base database, not linked to the Access one, and with both open copy the Tables from the Access linked one to the stand alone one.

To change the size of the form on the screen open the Form in edit mode, drag the sides to the size you require, and click on Save when you close it.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-08-18 14:50:03 +0100

Seen: 118 times

Last updated: Aug 21 '15