[THIN] Re: Publishing Large Access Databases

  • From: "Greg Reese" <GReese@xxxxxxxxxxxxxxxx>
  • To: <thin@xxxxxxxxxxxxx>
  • Date: Tue, 4 Feb 2003 15:38:46 -0500

Have you run a repair and compact on them?  That may bring the size down =
to reality. =20

If all the tables are linked and there are not any local tables, then =
the database should not be all that big.  It can, but it would be odd.

-----Original Message-----
From: Jacob Walker [mailto:ctxrulez@xxxxxxxxxxx]
Sent: Tuesday, February 04, 2003 3:26 PM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Publishing Large Access Databases



The extremely terse explanation I received from the project manager does =

agree with what you describe below.  However, it looks like there are a =
lot=20
of tables, linked tables, and queries within the Access database.  There =

don't appear to be any forms, and there are just a handful of reports.  =
So,=20
at over 1GB in size, I guess they are storing data in Access, too.

>-----Original Message-----
>From: Greg Reese [mailto:GReese@xxxxxxxxxxxxxxxx]
>Sent: Tuesday, February 04, 2003 3:10 PM
>To: thin@xxxxxxxxxxxxx
>Subject: [THIN] Re: Publishing Large Access Databases
>
>
>
>yuck.  Sounds messy.=3D20
>
>So the access databases are just forms and reports that connect to db2 =
=3D
>and Informix tables?
>
>Greg
>
>-----Original Message-----
>From: Jacob Walker [mailto:ctxrulez@xxxxxxxxxxx]
>Sent: Tuesday, February 04, 2003 3:03 PM
>To: thin@xxxxxxxxxxxxx
>Subject: [THIN] Re: Publishing Large Access Databases
>
>
>
>My understanding is that these Access database files are arranged with =
a =3D
>
>front end and back end database.  I believe the back end database from =
=3D
>which=3D20
>it pulls data uses a DB2 client connecting to an Informix database.





_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. =20
http://join.msn.com/?page=3Dfeatures/virus

********************************************
This Week's Sponsor: triCerat Inc.
Let triCerat simplify the administration=20
of your Terminal Servers.
http://www.triCerat.com
********************************************

For Archives, to Unsubscribe, Subscribe or=20
set Digest or Vacation mode use the below link:
http://thethin.net/citrixlist.cfm
********************************************
This Week's Sponsor: triCerat Inc.
Let triCerat simplify the administration 
of your Terminal Servers.
http://www.triCerat.com
********************************************

For Archives, to Unsubscribe, Subscribe or 
set Digest or Vacation mode use the below link:
http://thethin.net/citrixlist.cfm

Other related posts: