[libreoffice-users] Large Database

[Patrick]

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


-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Large Database

[Alan B]

On Thu, Feb 26, 2015 at 9:06 AM, Patrick  wrote:

> 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
>

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.

-- 
To unsubscribe e-mail to: users+unsubscr...@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