Base - Problems loading rows from MS Access 2003 DB

asked 2016-08-24 17:51:44 +0100

JBCastro gravatar image

updated 2016-08-24 17:54:55 +0100

Hi there,

I've created a odb file to connect to a MS ACCESS 2003 DB.

Queries show up as tables, no data appear in some of them, but that is the least.

The big problem for me is that the main table which contains 490+ rows only shows up partially. At first 90 rows appear, as I scroll down up to 200+, but no more.

Queries created in the odb file appear empty, even with a simple reasonable set of criteria.

Is there any way I can fix this?

Thank you!

Windows Vista LibreOffice 5.

edit retag flag offensive close merge delete

Comments

Don't have a real answer for you but maybe it's the connection type. I just set up a connection to a '97 Access.mdb using UCanAccess as a JDBC connection. Had no queries to move but all tables came across fine - some with thousands of records. Can run new queries without problem. Did this on xubuntu v16.04 using LO v5.2

Ratslinger gravatar imageRatslinger ( 2016-08-24 20:34:29 +0100 )edit