Dismiss Notice
You are browsing this site as a guest. It takes 2 minutes to CREATE AN ACCOUNT and less than 1 minute to LOGIN

Ms access with VB6 help

Discussion in 'Tech, Gadgets & Science Forum' started by Eliah, Aug 11, 2010.

  1. E

    Eliah Member

    #1
    Aug 11, 2010
    Joined: Jun 8, 2009
    Messages: 32
    Likes Received: 0
    Trophy Points: 13
    JF's i have develop an application of Managing Books in Library using Ms access and VB6 and it is currently in use where the Librarians are dairy using it to insert books in that database using the vb interface.but guys I'm worried because right now the program is working fine but im worried later on that when the no of books in that access database becomes many about 30thousands will the program run smoothly regardless no. of users accessing the same database at a time? If there will be a problem can someone advice me? and what about migrating Ms access db to sql server is it costly? help pliz'
     
  2. Buswelu

    Buswelu JF-Expert Member

    #2
    Aug 11, 2010
    Joined: Aug 16, 2007
    Messages: 1,975
    Likes Received: 22
    Trophy Points: 135
    Hey Bro...where are u sitting at the moment...not cost that much..but u need to have time..as long as u have arleady set ur self to do that...u have time.....I have book here with me which will take you through step by step....Migrating Access db to SQL Few things you need to have..which I have for you Hommie...I like the way you have express urself...!!I have done that Migrating from Datashed connecting to SQL 2000 to acQuire connecting to SQL.2005
     
  3. Buswelu

    Buswelu JF-Expert Member

    #3
    Aug 11, 2010
    Joined: Aug 16, 2007
    Messages: 1,975
    Likes Received: 22
    Trophy Points: 135
    The easiest way to convert an Access database to SQL Server is to use the Upsizing Wizard.
    • Preserves database structure, including data, indexes, and default settings.
    • Automatically converts Access validation rules and default settings to the appropriate SQL Server equivalents.
    • Maintains table relationships and referential integrity after you upsize.
    To run the Upsizing Wizard in Access 2000, on the Tools menu, point to Database Utilities, and then click Upsizing Wizard.
    Use SQL Server Data Transformation Services (DTS) to import the data from your Access database to a SQL Server database. For more information about DTS and the DTS Import Wizard, see the "Data Transformation Services" and "Using the Import and Export Wizards"

    Cont....tmr
     
  4. JuaKali

    JuaKali JF-Expert Member

    #4
    Aug 14, 2010
    Joined: Nov 14, 2007
    Messages: 783
    Likes Received: 0
    Trophy Points: 33
    Yes, yu should be worried, since MS access db is not intended for large databases and concurences access. I would advice you start working on SQL Server 2008 is very robust and easier to work with it has so many built in tools that make life little bit easier. I work on SQL2008 thats why I recommend u to migrate to it, otherwise jump onto Oracle.
     
  5. Mtazamaji

    Mtazamaji JF-Expert Member

    #5
    Aug 15, 2010
    Joined: Feb 29, 2008
    Messages: 5,972
    Likes Received: 27
    Trophy Points: 0
    Simple SDLC procedures ni za muhimu kufuata ukiwa ukiwa unataka develop au kuchange system yako.
    Umesema system yako inatumiwa na libraian kuisert vitabu.

    • Je hii tu ndo function ya system yako. au ina data pia za loan, members, nk.
    • what is approximated maximum size ya kila info ya kitabu kimoja una table/entity ngapi?
    • Je current size ya system ni MB ngapi kwa sasa? na %ge ya growth ni ngapi kwa mwezi 1ja au miezi mitatu? OR current system ina rekodi ngapi? Kwa wiki au mwezi mnaingiza rekodi ngapi mpya?
    • Ni kweli Ms acesss ina size limitation je unajua size limitation yake? Hope umefanya home wark yako.
    Usiwe worried wakati uwezo wa statistics za mahitaji ya system yako unazo. Unaweza kukuta kwa %ya growth ya system yako labda itafikia limit capacity mwaka 2015.

    Maswali haya ukiyapatia jibu utapata jibu if and when u need to migrate/ upgrade . Hiyo ni moja ya issue au problem zako .That was about database growth

    Issue/Problem nyingine naona unaongelea concurrent acesss kwa watumiaji sijui approximated maximum number ya concurrent user kwa system yako inaweza kuwa ngapi?
    .
    System yako iko katika Client/server archteture na iko katika two-tiers. Hope one of powerful PC inaweza kuwa server na client hapo hapo . Watumiji wengine kwenye desktop zao watakuwa na hiyo VB interface inayowaunganisha kwenye server. SQL inayo tool inatwa Client network utility itakusaidia kwa hilo.

    Lakini uki google utaona hata Ms Acess ina wezo kuhimili 10 concurrent ODBC user connections.

    Vile Vile jiulize maswali na upate majibu ya maswali mengi iwezekanavyo kabla ya kuhama. Nin mana Database analytical questions.

    • Kuna watumiaji zaidi ya Mmoja wenye PC tofauti wanatakiwa kutumia system hiyo? Je ni wangapi?
    Je watumiaji hao watafanyaza kazi za aia moja au kila moja ana aceess right zake?

    • Je system yako ya mwanzo ina Authentication za kutofautisha watumiji sababu concurrent database acces inaadamana na issue nyingine. Kama.Lost updates, na nyingine . Just google( Database concurrent problem) uone vitu vya msingi kivujua ukiwa una desing database inayotakkiwa kuhandle concurrent user . Hili ni jambo la muhimu sana
    Je ipo LAN? is it wired LAN au Wireless LAN
    UPGRADE and MIGRATION
    Sijawaii fanya migration ya database from acesss to SQL . But najua kumigrate data za acess kwenda kwenye SQL ni kazi rahisi kuna tool za kuexport na kuimpot data kwenye SQL kuna mjumbe kaitaja inaitwa DTS( Data Trasnformation Services)

    Ambacho sijui wataaalamu wanaweza kutusaidia ni kutupa elimu ni kumigrate Database structure ya acees kwenda SQL serverambayo nadhani ukifikia uamuzi wa kumigrate kama si kuupgrade unaweza kutumia SQL server express 2005 Edition ambayo ni free

    Eliah thanks for your assignment imenifanya imenifanya nipekue pekoe mambo niliyokuwwa nayajua zamani lakini sijayafanyia kazi kwa muda mrefu na hivyo kuyasahau kabisa
     
Loading...