MS Access editing Thread

Discussion in 'FIFA 2003 Forum' started by Alex, Nov 8, 2002.

  1. Alex

    Alex sKIp_E Staff Member Administrator

    Joined:
    Oct 20, 2001
    Messages:
    13,762
    Likes Received:
    12
    Location:
    Sydney, NSW, Australia
    I have read lots of reports on editing the DB thru MS Access, and have also read that when u add players, u cant do things like decide his team etc.

    Ive experimented, and the truth is u can do EVERYTHING. You can add players to teams, u can add new players all together (and decide their team), change player numbers, etc etc.

    U can change team formations, player positions and appearance and anything else u want to change!

    I have also found that obviously the position numbers correspond to the order they are listed in, in the CC. (they can also be found in one of the other tables in the Access DB).
    But they are:
    0-GK
    1-SW
    2-RWB
    3-RB
    4-RCB
    5-CB
    6-LCB
    7-LB
    8-LWB
    9-LDM
    10-LCDM
    11-CDM
    12-RCDM
    13-RDM
    14-RWM
    15-RM
    16-RCM
    17-CM
    18-LCM
    19-LM
    20-LWM
    21-RAM
    22-RCAM
    23-CAM
    24-LCAM
    25-LAM
    26-LF
    27-CF
    28-RF
    29-LS
    30-ST
    31-RS
    32-Sub
    34/35-Reserve


    Cheers
    sKIp_E
     
  2. lukas_svoboda

    lukas_svoboda Senior Squad

    Joined:
    Mar 29, 2001
    Messages:
    2,170
    Likes Received:
    0
    Location:
    Prague, CZ
  3. SpideurMane

    SpideurMane Club Supporter

    Joined:
    Oct 30, 2002
    Messages:
    39
    Likes Received:
    0
    Location:
    Soon
    Wrong Custom league calendar !

    OK here is the problem :
    When you create a custom league inside FIFA2003, have you noticed that the calendar is all ****ed up ?!?!

    For instance, some teams will have already played 8 matches as others just 2 !!! It seems to be random and it continues like that till the end...

    This is completely stupid as you cannot keep track of the real league positions of teams... would there be a way to correct that.... ANYBODY ?? It would be great !!

    THANX
     
  4. Alex

    Alex sKIp_E Staff Member Administrator

    Joined:
    Oct 20, 2001
    Messages:
    13,762
    Likes Received:
    12
    Location:
    Sydney, NSW, Australia
    Yeah but those threads are huge, and about more than just Access. They often discuss XML and other things. Their is also lots of talk there about ppl not being able to add new players, and decide what teams they are in etc.
    I think that now we know of the technique, that a clean thread is needed to discuss what is involved, and anything new that ppl find out about the technique. Things like what the different formation numbers are.

    Newer ppl to editing would just get confused at the other thread.

    SpideurMane, could u plz, stick to the MS Access topic. This is just generally about the CC, or about FIFA...Posts like this are why we need a thread JUST for Access, to much of this confused things at the other thread ;)

    Cheers
    sKIp_E
     
  5. Paul

    Paul Fan Favourite

    Joined:
    Jan 7, 2002
    Messages:
    7,338
    Likes Received:
    0
    Location:
    Australia
    yeah, sKIp_E asked me to watch this thread ....

    keep it primarily to MS Access ... any other irrelivant posts will be deleted by a mod :)
     
  6. ^^Snoop^^

    ^^Snoop^^ Club Supporter

    Joined:
    Nov 1, 2002
    Messages:
    62
    Likes Received:
    0
    Location:
    Liverpool, England
    Any of you guys know why my squad numbers and lineup is wrong when I created Sheff Utd in Access? I checked the player links were all correct and the right players were linked with the correct positions. Lukas says it ain't possible to add players in Access, is this correct?
     
  7. Alex

    Alex sKIp_E Staff Member Administrator

    Joined:
    Oct 20, 2001
    Messages:
    13,762
    Likes Received:
    12
    Location:
    Sydney, NSW, Australia
    It is definatley possible to add players using access, and setup their numbers, and positions. But whether u can do this with teams u have added, im not sure.

    When u add the team, make sure that its formation is setup to the right number (get this from a team with the same formation), than make sure that no players have the same number as each other, and that the positions are EXACTLY as FIFA lists them (if it says RWB in FIFA, put it down as RWB, not RB ;))

    Finally when u import the file, dont do anything but the following in the CC.

    Package->Uninstall
    File->New
    File->Save As (whatever u want)
    Package->Install

    If that doesnt work, than im not sure, but just check that u haev evrything right in access ;)
     
  8. ^^Snoop^^

    ^^Snoop^^ Club Supporter

    Joined:
    Nov 1, 2002
    Messages:
    62
    Likes Received:
    0
    Location:
    Liverpool, England
    I'll do another double-check again later, thanks for the tips Skip :D
     
  9. Hans

    Hans How big is YOUR penis?

    Joined:
    Sep 19, 2002
    Messages:
    6,350
    Likes Received:
    0
    Location:
    Between the legs . . .
    Dude, I`ve asked this on the previous thread, but there are no satisfying answer, could you help me ?
    1. I`m about to use the CC now to install it, will it delete or in any way disaccess me from my saved games ?
    2. Would I be able to edit it as many time as I want and reinstall it again without fear of a messed up FIFA 2003 ?
    Say, for example : I change things here and there, save it, install it using the CC. Then I go play some matches in season mode, then I realised something`s not right, so I save, quit the game. Then I go opening the database again with access, change and make correction again, then reinstall it again using the CC, would that be possible ? And would the changes I made in the second time, directly applied in my saved games ? BTW if I want to install it using CC, then I must save it as PKG file first, am I right ? Or I can directly install it ?

    Could you explain here the step by step instalation for changing the database using the Access way. Thanks for all the answer, and any clues will be greatly apreciated.
     
  10. ^^Snoop^^

    ^^Snoop^^ Club Supporter

    Joined:
    Nov 1, 2002
    Messages:
    62
    Likes Received:
    0
    Location:
    Liverpool, England
    Oh, another thing I noticed. I added Wayne Rooney to the Everton squad and although he's number 18, and has been assigned that in Access, he's being given number 14 in FIFA. The reason likely being that 14 was the next free number. It seems the only way around that is to add another player and give him the number 14 ... making the game unrealistic as Everton no longer have a number 14 :(
     
  11. mark77

    mark77 Transfer Guru

    Joined:
    Nov 9, 2002
    Messages:
    8,708
    Likes Received:
    0
    MS Access XP

    Can I use MS Access XP version to edit FIFA 2003?

    Thanks
     
  12. ManUGrobar

    ManUGrobar Youth Team

    Joined:
    Oct 7, 2002
    Messages:
    443
    Likes Received:
    0
    Location:
    NYC/Orlando, USA/Belgrade, Serbia
    Where is the tag located for chanigng player numbers when you are using access???
     
  13. Maniac

    Maniac Reserve Team

    Joined:
    Jan 15, 2001
    Messages:
    551
    Likes Received:
    0
    Location:
    Oslo, born in Sarajevo
    hi all

    I made a team in the CC. I opened the Access file, and I couldn't find my team anywhere!! why?, Do I have to bulid the team all over again trough access??


    thanks
     
  14. butcher

    butcher Youth Team

    Joined:
    Nov 9, 2002
    Messages:
    145
    Likes Received:
    0
    Location:
    there
    Seems that I can't change my own teams through excel (or access for that matter)...if I uninstall the package and install the one with access_all_data in it will I still have the teams I made with cc? it'd be a shame to lose them...
     
  15. vze4b78y

    vze4b78y Youth Team

    Joined:
    Aug 27, 2002
    Messages:
    367
    Likes Received:
    0
    Location:
    my own private hell
    where do u download the ms access??
     
  16. Hakeem

    Hakeem Superman

    Joined:
    Jan 21, 2002
    Messages:
    16,275
    Likes Received:
    0
    Location:
    Uruguay
    .

    you cant DL Access.

    and about the saved games problem, I think that those game will be lose, but you can always back them up (and also the original dbis) and check.

    BTW: as it seems that we DO can add new players as Alex said: whats the first number ID we have to give to the first player we create???
    and has somebody tryed to create new teams or players yet??
     
  17. yim87

    yim87 Senior Squad

    Joined:
    Mar 31, 2002
    Messages:
    2,398
    Likes Received:
    0
    Location:
    :)
    try adding a random player then add wayne rooney..then delete the random player..
     
  18. Paul

    Paul Fan Favourite

    Joined:
    Jan 7, 2002
    Messages:
    7,338
    Likes Received:
    0
    Location:
    Australia
    if i have to say this twice it'll kill me the second time.

    Microsoft Access is apart of Microsoft OFFICE !!!!!!
     
  19. Haukur Gudnason

    Haukur Gudnason ::President Scouser::

    Joined:
    Nov 7, 2000
    Messages:
    7,197
    Likes Received:
    0
    Location:
    L4
    juz a question..
    where do u download the ms access?




    grassy..grassy? GRASSYY!!
    oH no..i've KILLED grassy...!!

    Oh Goddess
    There is great sadness
    A cherished one has gone

    Emptiness engulfs me
    Loss languishes within
    Help me bear this grief

    Accompany their spirit
    Comfort we who grieve
    Let us rejoice in their life
     
  20. Paul

    Paul Fan Favourite

    Joined:
    Jan 7, 2002
    Messages:
    7,338
    Likes Received:
    0
    Location:
    Australia
    yay, lets all be a retard like Haukur Gudnason :rolleyes: :hump:

    seriously, it was one of the dumbest questions i've seen all year.
     
      

Share This Page