# MSAccess file size **URL:** \ **Category:** Archived Topics\ **Created:** [January 6, 2010, 4:29pm UTC](https://forum.inductiveautomation.com/t/msaccess-file-size/1425 "2010-01-06T16:29:07Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Justin](https://avatars.discourse-cdn.com/v4/letter/j/3ab097/32.png) [@Justin](https://forum.inductiveautomation.com/u/Justin)\ **Post date:** [January 6, 2010, 4:29pm UTC](https://forum.inductiveautomation.com/t/msaccess-file-size/1425/1 "2010-01-06T16:29:07Z")
Would like to find out what the maximum recommended file size of a MSAccess db file should be when running an SQL query in a table. I am trying to view data from a db file that is around 2 gig and that is apperently too big for FactoryPMI. I always get an error after timing out. I have a similar setup reading from a db file that is around 750k in which there isn’t any trouble. ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [January 6, 2010, 6:15pm UTC](https://forum.inductiveautomation.com/t/msaccess-file-size/1425/2 "2010-01-06T18:15:02Z")
We don’t really have a good idea as to a recommendation for a maximum size for an Access database, since we don’t fully support the use of MS Access. We should be able to get you connected, but beyond that, its really out of our hands. It doesn’t surprise me that a large access database’s performance isn’t acceptable, since Access really isn’t a capable relational database. ---
**Author:** ![chris\_d\_sanders](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/chris_d_sanders/32/3359_2.png) [@chris\_d\_sanders](https://forum.inductiveautomation.com/u/chris_d_sanders)\ **Post date:** [July 19, 2011, 4:10pm UTC](https://forum.inductiveautomation.com/t/msaccess-file-size/1425/3 "2011-07-19T16:10:06Z")
Carl, I am having trouble even figuring out how to connect to an Access DB. We are running ignition on Ubuntu Server Edition. The DB I want to connect to is located on another server. How do I go about adding the connection? ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [July 19, 2011, 5:25pm UTC](https://forum.inductiveautomation.com/t/msaccess-file-size/1425/4 "2011-07-19T17:25:18Z")
You cannot connect to MS Access from a Linux machine. To connect to MS Access on a Windows machine you need to setup a System DSN (ODBC) connection. ---
**Author:** ![nathan](https://avatars.discourse-cdn.com/v4/letter/n/c5a1d2/32.png) [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Post date:** [July 20, 2011, 11:16am UTC](https://forum.inductiveautomation.com/t/msaccess-file-size/1425/5 "2011-07-20T11:16:11Z")
I remember seeing a 3rd party access JDBC driver that might work on Linux. It’s very much a use at your own risk application. ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [July 22, 2011, 10:32pm UTC](https://forum.inductiveautomation.com/t/msaccess-file-size/1425/6 "2011-07-22T22:32:40Z")
There is now a pure-java type-4 JDBC driver for access: [hxtt.com/access.html](http://www.hxtt.com/access.html) I’ve never used it, so let us know how it goes. ---
**Author:** ![joseph.hermo](https://avatars.discourse-cdn.com/v4/letter/j/f9ae1b/32.png) [@joseph.hermo](https://forum.inductiveautomation.com/u/joseph.hermo)\ **Post date:** [December 3, 2020, 8:42pm UTC](https://forum.inductiveautomation.com/t/msaccess-file-size/1425/7 "2020-12-03T20:42:54Z")
Hi @Justin, I would like to know if you found a solution the problem with the file size read timed out error for MS access? We experienced the same thing with read timed out which occurs inconsistently, our db size is just around 1GB. But I tried to do a similar setup with a lower file size and it works just fine.