Large Database

users
#1

ok i am hours new to Libreoffice so hopefully i dont sound too off here.so
i use a large database in access that has several tables that have 80-100k
lines in them. iam looking for a way to have access to this database while
i am away from my work computer. i thought i could use base on a thumb
drive and just drag a copy of the access program to the drive also. so i
could always have access to the program but i keep runing into problems
when i try and open it. it says that it can not establish a connection and
the message below,

SQL Status: HY000

any advise? or should i be looking at another way? and my company does not
allow us to open up links so sharing access to the database is out fo the
question

#2

Patrick if your need is to use the data in the tables Base can access it
with an ODBC connection to the Access database.

If you need to use the database program, any forms used to enter/edit data,
or reports to display or print the data, Base cannot use those.

In the first case the following links provide information how to read the
data. Only the first link is specific to LibreOffice Base. The other two
refer to Apache OpenOffice so not all the information there may be
applicable.
https://wiki.documentfoundation.org/Faq/Base/How_to_connect_to_a_Microsoft_Access_database
https://www.openoffice.org/FAQs/ms-access/ms-access.html
https://wiki.openoffice.org/wiki/Connecting_to_Microsoft_Access

Another option, if your company allows, would be a remote connection to
your computer get at the database when you're out of the office.