Results 1 to 14 of 14
  1. #1
    Join Date
    May 2002
    Posts
    395

    Angry Unanswered: Re: Why did the adp file shrink?

    Good Morning to all,

    I like to find out why the adp file size reduced drastically after moving from SQL Server 7.0 to SQL Server 2000. It was 17000 kb but now is only 2500 kb. I would appreciate if anyone has an explanation for this. Thanks!

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    What adp file? Are you talking about Access or MDF (SQL)?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    May 2002
    Posts
    395

    Unhappy Re: Why did the adp file size shrink?

    Thanks for your reply.

    We have recently updated from SQL Server 7.0 to SQL Server 2000. I re-created Access FE(adp file) base on the SQL Server 2000 as the BE. Now the Access file size only 2500 kb but the Access FE for SQL Server 7.0 is 17000 kb. Would you have an explanation for this?

    Thanks!

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I am pretty sure the file will grow and may possibly reach 17MB shortly. Many operations within Access result in data coming from your backend to be temporarily stored locally in adp, which forces it to grow. If adp sits on a share and is used by more than 1 user then intensity of connections also affects its size.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    May 2002
    Posts
    395

    Re: Why did the adp file shrink?

    Hi,
    Again, thanks for your reply.

    You said the file will grow. Are you saying once the database is actively in use the file will grow? I created db last week and file size was 35MB and still has not grown.
    Thanks an explanation.

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    In the previous post you said that the new file size is 2.5MB...I am confused...
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  7. #7
    Join Date
    May 2002
    Posts
    395

    Unhappy Re: Why does adp file size shrinK?

    Hi ,

    When I created the new FE last Monday it was 3.5MB when I checked the same adp file today is showing 2.5MB. This Access file was not being used til last Thursday and only by one user. This user does make changes to two tables. Could you explain this strange behavior?

    Thanks!

  8. #8
    Join Date
    May 2002
    Posts
    395

    Re: why did the adp file shrink?

    Thanks for your explanation, Rdjabarov.
    The file size has gotten larger.
    Thanks!

  9. #9
    Join Date
    May 2002
    Posts
    395

    Re: Why did the adp file shrink?

    Hi rdjabarov,

    You mentioned MDF (SQL) previously. Could you explain what that is?
    Thanks much!

  10. #10
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    i'm gonna step in for robert(dont tell him)
    the default datafile file extension for Ms Access is the MDB file it contains forms reports tables queries macros modules etc..

    the default data file for SQL Server is MDF it contains tables and indexes.
    all of the definitions of the objects that exist within a sql server database (stored procedures, Views, Functions, Triggers, constraints, etc...) are contained within system tables in each database and in the master and msdb database.

    Books Online {Physical Database Files and Filegroups}

  11. #11
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Quote Originally Posted by Ruprect
    i'm gonna step in for robert(dont tell him)
    Why are you ignoring me? I asked you if you were going to this "get-together-for-local-wannabe-dbas" and you didn't say a word!..And she asked me, not you!
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  12. #12
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    Quote Originally Posted by rdjabarov
    Why are you ignoring me? I asked you if you were going to this "get-together-for-local-wannabe-dbas" and you didn't say a word!..And she asked me, not you!

    i knew i could get your attention
    i didnt see the "get together" post sorry i will try to stay sharper.

  13. #13
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Well, about time!!!!
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  14. #14
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    "oooooooooooooooohhhhhhhhhh I hate that rabbit!!!"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •