adp size

[Honza]

Hi,
my adp file conected to SQL server datebase include about 10 little
forms but the size is about 50MB.

Does anybody know why is adp file so big and how to decrease his size.

Thanks a lot

H.

 

[Uwe Ricken]

Hi Jan,

The increasement is a result of multiple changes and storages
of the forms. Another reason can be the use of bitmaps in your
forms, etc...

Compress the database ;-)

HTH ;-)

--
Gruß, Uwe Ricken
MCP FOR MS ACCESS DEVELOPMENT
GNS GmbH, Frankfurt am Main
http://www.gns-online.de
http://www.memberadmin.de
http://www.conferenceadmin.de
____________________________________________________
APP: http://www.AccessProfiPool.de
dbdev: http://www.dbdev.org
FAQ: http://www.donkarl.com/AccessFAQ.htm

 

[Honza]

Hi Uwe,

thanks for replay, but unfortunately "Compress database" doesn´t help too
much, saving just about 5 MB. Used bitmaps together takes about 1MB.
Forms are really very simple. Could be the reason that adp is connected to
big database on SQL server? If yes, do you know why?

thanks a lot

Jan

 

[Uwe Ricken]

Hi Honza,

Forms are really very simple. Could be the reason that adp is connected to
big database on SQL server? If yes, do you know why?

Definitly NO - I suppose the bitmaps will cause that enlargement.
Try as follows:

1. Create an new empty adp
2. Import all objects from the old adp
3. Check the size of the adp

If the size is nearby the same as the old adp try the same but without
the images in the forms/reports. You will be suprised ;-)

HTH ;-)

--
Gruß, Uwe Ricken
MCP FOR MS ACCESS DEVELOPMENT
GNS GmbH, Frankfurt am Main
http://www.gns-online.de
http://www.memberadmin.de
http://www.conferenceadmin.de
____________________________________________________
APP: http://www.AccessProfiPool.de
dbdev: http://www.dbdev.org
FAQ: http://www.donkarl.com/AccessFAQ.htm

 

[SF]

I faced this problem once without knowing any reason. Try to create a new
database and import everything from your old to new one. See if the size is
reduce.

SF

 

[Honza]

I´ve already tried, but it doesn´t help....

I faced this problem once without knowing any reason. Try to create a new
database and import everything from your old to new one. See if the size is
reduce.

SF