Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Integration with MsAccess and Limitations

Discussion in 'Information Technology' started by Sachin Vedpathak, Jul 28, 2006.

  1. Sachin Vedpathak

    Sachin Vedpathak
    Expand Collapse
    Guest

    hi all,

    Which are best ways to integrate with ms access.

    I have a Access Database size around 800MB and every month the size get's
    increasing by about 200MB. so i am worried that some or other day it will get
    crash.
    Can it be better to shift to oracle or any solutions for existing MsAccess
    Database

    what are the limitations of using ms access database
    How stable it is to use access database. When can it get crash.

    Thanks
    Sachin Vedpathak
     
  2. Loading...

    Similar Threads Forum Date
    Punjab Division will Lead to Disintegration of Pakistan (Video) Punjab, Punjabi, Punjabiyat Jul 8, 2013
    Integration of Out-castes in Sikhism Sikh Sikhi Sikhism Sep 10, 2009
    Sikh News India moving towards full integration of 8,500 Afghan refugees (New Kerala) Breaking News Sep 13, 2006
    IBM Offers Cell Processor Integration (AP) Interfaith Dialogues Mar 31, 2005

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    2GB is the limit for Access.
    So yes you have to upsize in time
    Compact the Db often to avoid Crashes (will take time with your Db)

    Pieter

    "Sachin Vedpathak" <Sachin Vedpathak@discussions.microsoft.com> wrote in
    message news:70F8FC9B-8F69-415D-B31C-36C381F07341@microsoft.com...
    > hi all,
    >
    > Which are best ways to integrate with ms access.
    >
    > I have a Access Database size around 800MB and every month the size get's
    > increasing by about 200MB. so i am worried that some or other day it will
    > get
    > crash.
    > Can it be better to shift to oracle or any solutions for existing MsAccess
    > Database
    >
    > what are the limitations of using ms access database
    > How stable it is to use access database. When can it get crash.
    >
    > Thanks
    > Sachin Vedpathak
     
  4. Valentín Playá

    Valentín Playá
    Expand Collapse
    Guest

    Hi Sachin,

    the maximum size of an mdb file is 2 GB (including system objects) but
    you can split your your tables in more than one mdb file if necesary,
    and link all tables to the same front end mdb in such a way that the
    size all mdb is less than 2.000 MB.

    If you have no other concerns and you can solve the size problem,
    Access is as stable as other databases specialy if using the aplication
    from one system. If using it in a LAN, the Access stability will depend
    of the number of users, the reliability of the net, the database
    design, etc.

    Regards,

    Valentín Playá Serra
    Sonotronic S.A.
    Madrid, España
     
  5. PC Datasheet

    PC Datasheet
    Expand Collapse
    Guest

    Go to Tools - Database Utilities and try a Compact and Repair on your
    database. You most likely will get a big surprise.

    Look for what is causing your database to rapidly escalate in size. Some
    likely causes are ---
    * Routinely deleting and reentering data in your database tables
    * Adding and storing images directly in the database


    --
    PC Datasheet
    Your Resource For Help With Access, Excel And Word Applications
    Over 1175 users have come to me from the newsgroups requesting help
    resource@pcdatasheet.com



    "Sachin Vedpathak" <Sachin Vedpathak@discussions.microsoft.com> wrote in
    message news:70F8FC9B-8F69-415D-B31C-36C381F07341@microsoft.com...
    > hi all,
    >
    > Which are best ways to integrate with ms access.
    >
    > I have a Access Database size around 800MB and every month the size get's
    > increasing by about 200MB. so i am worried that some or other day it will
    > get
    > crash.
    > Can it be better to shift to oracle or any solutions for existing MsAccess
    > Database
    >
    > what are the limitations of using ms access database
    > How stable it is to use access database. When can it get crash.
    >
    > Thanks
    > Sachin Vedpathak
     
  6. StopThisAdvertising

    StopThisAdvertising
    Expand Collapse
    Guest

    "PC Datasheet" <NoSpam@Spam.Com> schreef in bericht news:Lbkcg.5333$x4.3178@newsread3.news.pas.earthlink.net...
    > Go to Tools - Database Utilities and try a Compact and Repair on your
    > database. You most likely will get a big surprise.
    >
    > Look for what is causing your database to rapidly escalate in size. Some
    > likely causes are ---
    > * Routinely deleting and reentering data in your database tables
    > * Adding and storing images directly in the database
    >
    >
    > --
    > PC Datasheet
    > Your Resource For Help With Access, Excel And Word Applications
    > Over 1175 users have come to me from the newsgroups requesting help
    > resource@pcdatasheet.com
    >


    To Steve:
    Spamming innocent people also causes bloat ...
    Would you please get yourself 'compacted' on a regular basis ??

    No-one wants your advertising/job hunting here!
    'Resource ???? 1175 users ???? Are you kidding ????
    ==>> You mean that 1175 users have been spammed by you ??

    To the original poster:
    Most people here have a common belief that the newsgroups are for *free exchange of information*.
    But Steve is a notorious job hunter in these groups, always trying to sell his services.

    He is known here as a *shameless liar*, with *no ethics at all*.
    If you provided a valid email address he might even spam you with an offer for payed help

    Before you intend to do business with him look at:
    http://home.tiscali.nl/arracom/whoissteve.html
    Over 875 !! users (rapidly increasing..) from the newsgroups have visited the website to read about this fake 'resource'

    Arno R
     
  7. PC Datasheet

    PC Datasheet
    Expand Collapse
    Guest

    Go kiss John Marshall's A$$ you stupid A$$!!!!!!!




    "StopThisAdvertising" <StopThisAdvertising@DataShit> wrote in message
    news:4471d264$0$2017$ba620dc5@text.nova.planet.nl...

    "PC Datasheet" <NoSpam@Spam.Com> schreef in bericht
    news:Lbkcg.5333$x4.3178@newsread3.news.pas.earthlink.net...
    > Go to Tools - Database Utilities and try a Compact and Repair on your
    > database. You most likely will get a big surprise.
    >
    > Look for what is causing your database to rapidly escalate in size. Some
    > likely causes are ---
    > * Routinely deleting and reentering data in your database tables
    > * Adding and storing images directly in the database
    >
    >
    > --
    > PC Datasheet
    > Your Resource For Help With Access, Excel And Word Applications
    > Over 1175 users have come to me from the newsgroups requesting help
    > resource@pcdatasheet.com
    >


    To Steve:
    Spamming innocent people also causes bloat ...
    Would you please get yourself 'compacted' on a regular basis ??

    No-one wants your advertising/job hunting here!
    'Resource ???? 1175 users ???? Are you kidding ????
    ==>> You mean that 1175 users have been spammed by you ??

    To the original poster:
    Most people here have a common belief that the newsgroups are for *free
    exchange of information*.
    But Steve is a notorious job hunter in these groups, always trying to sell
    his services.

    He is known here as a *shameless liar*, with *no ethics at all*.
    If you provided a valid email address he might even spam you with an offer
    for payed help

    Before you intend to do business with him look at:
    http://home.tiscali.nl/arracom/whoissteve.html
    Over 875 !! users (rapidly increasing..) from the newsgroups have visited
    the website to read about this fake 'resource'

    Arno R
     
  8. John Marshall, MVP

    John Marshall, MVP
    Expand Collapse
    Guest

    Does A$$ stand for ASteveSantos?
     
  9. BruceM

    BruceM
    Expand Collapse
    Guest

    You know, if you just provided a website link in the signature line of
    messages, and maybe a few sample databases there to which you could direct
    people from time to time (as others do), I doubt you would hear much
    criticism. I have checked your web site a few times out of curiosity.
    Excel/Access tips have been "Coming Soon" for rather a while. Maybe it's
    not such a good advertisement.

    "PC Datasheet" <NoSpam@Spam.Com> wrote in message
    news:BGocg.456$Sf2.323@newsread1.news.pas.earthlink.net...
    > Go kiss John Marshall's A$$ you stupid A$$!!!!!!!
    >
    >
    >
    >
    > "StopThisAdvertising" <StopThisAdvertising@DataShit> wrote in message
    > news:4471d264$0$2017$ba620dc5@text.nova.planet.nl...
    >
    > "PC Datasheet" <NoSpam@Spam.Com> schreef in bericht
    > news:Lbkcg.5333$x4.3178@newsread3.news.pas.earthlink.net...
    >> Go to Tools - Database Utilities and try a Compact and Repair on your
    >> database. You most likely will get a big surprise.
    >>
    >> Look for what is causing your database to rapidly escalate in size. Some
    >> likely causes are ---
    >> * Routinely deleting and reentering data in your database tables
    >> * Adding and storing images directly in the database
    >>
    >>
    >> --
    >> PC Datasheet
    >> Your Resource For Help With Access, Excel And Word Applications
    >> Over 1175 users have come to me from the newsgroups requesting
    >> help
    >> resource@pcdatasheet.com
    >>

    >
    > To Steve:
    > Spamming innocent people also causes bloat ...
    > Would you please get yourself 'compacted' on a regular basis ??
    >
    > No-one wants your advertising/job hunting here!
    > 'Resource ???? 1175 users ???? Are you kidding ????
    > ==>> You mean that 1175 users have been spammed by you ??
    >
    > To the original poster:
    > Most people here have a common belief that the newsgroups are for *free
    > exchange of information*.
    > But Steve is a notorious job hunter in these groups, always trying to sell
    > his services.
    >
    > He is known here as a *shameless liar*, with *no ethics at all*.
    > If you provided a valid email address he might even spam you with an offer
    > for payed help
    >
    > Before you intend to do business with him look at:
    > http://home.tiscali.nl/arracom/whoissteve.html
    > Over 875 !! users (rapidly increasing..) from the newsgroups have visited
    > the website to read about this fake 'resource'
    >
    > Arno R
    >
     
  10. PC Datasheet

    PC Datasheet
    Expand Collapse
    Guest

    Go kiss Arno R's A$$ you stupid A$$!!!!!!!

    You are an embarassment to what MVP stands for!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


    "John Marshall, MVP" <lancucki@stonehenge.ca> wrote in message
    news:O6PDYVefGHA.3888@TK2MSFTNGP04.phx.gbl...
    > Does A$$ stand for ASteveSantos?
    >
    >
     
  11. BruceM

    BruceM
    Expand Collapse
    Guest

    Why would you list participation in newsgroups among your resources on your
    web page? Do you really want somebody to search newsgroups for your
    postings?

    "PC Datasheet" <NoSpam@Spam.Com> wrote in message
    news:yfDcg.5632$x4.1885@newsread3.news.pas.earthlink.net...
    > Go kiss Arno R's A$$ you stupid A$$!!!!!!!
    >
    > You are an embarassment to what MVP stands
    > for!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    >
    >
    > "John Marshall, MVP" <lancucki@stonehenge.ca> wrote in message
    > news:O6PDYVefGHA.3888@TK2MSFTNGP04.phx.gbl...
    >> Does A$$ stand for ASteveSantos?
    >>
    >>

    >
    >
     
  12. Arno R

    Arno R
    Expand Collapse
    Guest

    "PC Datasheet" <NoSpam@Spam.Com> schreef in bericht news:yfDcg.5632$x4.1885@newsread3.news.pas.earthlink.net...
    > Go kiss Arno R's A$$ you stupid A$$!!!!!!!
    >
    > You are an embarassment to what MVP stands for!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


    'Coming soon' Steve ?? or just breathing heavily ... ??

    Arno R
     
  13. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    Sachin Vedpathak <Sachin Vedpathak@discussions.microsoft.com> wrote:

    >I have a Access Database size around 800MB and every month the size get's
    >increasing by about 200MB. so i am worried that some or other day it will get
    >crash.


    That's a huge increase on a monthly basis. Any particular reasons
    why? Such as embedding graphics or other files? Lots of records?

    >Can it be better to shift to oracle or any solutions for existing MsAccess
    >Database


    SQL Server would be better as it would upsize nicer and integrate
    better.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  14. PC Datasheet

    PC Datasheet
    Expand Collapse
    Guest

    Go play with your young boys, you STUPID A$$!!!!!!!!!!!!!!!!!!


    "Arno R" <arraNOcomSPAM@tiscali.nl> wrote in message
    news:44731729$0$2022$ba620dc5@text.nova.planet.nl...

    "PC Datasheet" <NoSpam@Spam.Com> schreef in bericht
    news:yfDcg.5632$x4.1885@newsread3.news.pas.earthlink.net...
    > Go kiss Arno R's A$$ you stupid A$$!!!!!!!
    >
    > You are an embarassment to what MVP stands
    > for!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


    'Coming soon' Steve ?? or just breathing heavily ... ??

    Arno R
     

Share This Page