It is currently Wed Jul 30, 2014 1:15 pm




Post new topic Reply to topic  [ 6 posts ] 
 MSAccess file size 
Author Message
Private
Private

Joined: Fri Dec 11, 2009 11:52 am
Posts: 30
Location: Palatine Il
Post MSAccess file size
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.


Wed Jan 06, 2010 8:29 am
Profile
Moderator
Moderator

Joined: Sun Apr 02, 2006 2:46 pm
Posts: 4046
Location: Sacramento, CA
Post Re: MSAccess file size
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.

_________________
Carl Gould
Co-Director, Software Engineering
Inductive Automation


Wed Jan 06, 2010 10:15 am
Profile WWW
Major
Major

Joined: Tue Sep 23, 2008 5:07 am
Posts: 115
Location: Ardmore, Oklahoma
Post Re: MSAccess file size
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?

_________________
Christopher Sanders

Michelin North America
1101 Michelin Rd
Ardmore, OK 73401
(580)222-1406


Tue Jul 19, 2011 8:10 am
Profile YIM WWW
Moderator
Moderator

Joined: Sun Apr 02, 2006 2:46 pm
Posts: 1982
Location: Sacramento, CA
Post Re: MSAccess file size
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.

_________________
Travis Cox
Inductive Automation
Technical Support Rep.


Tue Jul 19, 2011 9:25 am
Profile WWW
Moderator
Moderator

Joined: Thu Mar 30, 2006 10:08 pm
Posts: 1190
Post Re: MSAccess file size
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.

_________________
Nathan Boeger, CISSP-ISSAP, CCNP Voice, VCP
Not Another Industrial Blog - My SCADA software blog
"Design Simplicity Cures Engineered Complexity"


Wed Jul 20, 2011 3:16 am
Profile WWW
Moderator
Moderator

Joined: Sun Apr 02, 2006 2:46 pm
Posts: 4046
Location: Sacramento, CA
Post Re: MSAccess file size
There is now a pure-java type-4 JDBC driver for access: http://www.hxtt.com/access.html

I've never used it, so let us know how it goes.

_________________
Carl Gould
Co-Director, Software Engineering
Inductive Automation


Fri Jul 22, 2011 2:32 pm
Profile WWW
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: