-
This is a reminder of 3 IMPORTANT RULES:
1- External self-promotion websites or apps are NOT allowed here, like Discord/Twitter/Patreon/etc.
2- Do NOT post in other languages. English-only.
3- Crack/Warez/Piracy talk is NOT allowed.
Breaking any of the above rules will result in your messages being deleted and you will be banned upon repetition.
Please, stop by this thread SoccerGaming Forum Rules And Guidelines and make sure you read and understand our policies.
Thank you!
MS Access editing Thread
- Thread starter Alex
- Start date
???Any ID can add a player properly, except the IDs that are above 54999! That's the limit, 54999. don't cross it.
the last ID is 53330, so that leaves us to add 1670 new players.
if you IDs start somewere between 1 and 53330, it is possible that some ID could overwrite and allready made player. Bc there are some "free holes" in the players table... for instance there is ID 1, 2 , but no 3, 4, 5.. then again 5, 6,7... comes up. be carefull, I would recomend to all to use the 53330 IDs...
cya
the last ID is 53330, so that leaves us to add 1670 new players.
if you IDs start somewere between 1 and 53330, it is possible that some ID could overwrite and allready made player. Bc there are some "free holes" in the players table... for instance there is ID 1, 2 , but no 3, 4, 5.. then again 5, 6,7... comes up. be carefull, I would recomend to all to use the 53330 IDs...
cya
It is MUCH easier, to just go Tools-Relationships, and delete the relationship between Players, and Link_PT.
Then go to Players, and change ID to a number, not an autonumber. Now go back to Relationships, rebuild the relationship (dragging from Players->ID to Link_PT->Player) (Select the Force Integrity box or whatever it is, when the box pops up).
Now u can add players with ANY id that isnt already used.
Easy!
Cheers
sKIp_E
nice....
but when the PlayerID is Autonumber, you'll get the new number automatic. If you change it to Number, each time you add a new player you will have to type inn the wanted ID. and that is anoying and hard to keep track of which ID is free and which isn't.
that's my tought tho.....
but when the PlayerID is Autonumber, you'll get the new number automatic. If you change it to Number, each time you add a new player you will have to type inn the wanted ID. and that is anoying and hard to keep track of which ID is free and which isn't.
that's my tought tho.....
Yeah, but if u go to table view, and sort by ID, than it is quite easy to see what ID's havent been used.
I still only use the ID's 53300 and above (which Ill keep doing until I get to 55000, and players become "created", but using the number/autonumber method to do this, is just the easiest way.
In access, you cant really change where an auto-number starts, it just goes by what it is up to.
Cheers
sKIp_E
starhannes
Youth Team
so how to change captain?
yeah ive added teams.
The problem is with adding teams, that the game crashes on loading if u use an unused, low teamID (so the game doesnt detect it as a new team). I assume because their is no art for that team.
Also, if u use a hgiher ID (the autonumber), the game runs, BUT u get a team that loses its team lineup, and player numbers etc.
BUT with the latest findings (that the CC creates seperate dbi files) it may be possible to import the needed art, to the teams added with the lower ID's.
Im not sure yet, I havent tried it, but it seems more likely to work now.
Ill check later
Cheers
sKIp_E
d
I have succesfully added 10 teams, and they have everything they need and they work fine in the game.
The thing is that you have to add them to an existing league cause they dont appear as CC Created Teams.
So I just addedd them to the rest of the world section and then I can create a league in CC and add select the teams from that section.
just add the flags and kits with your team's ID to the data folder and thats it.
there's no need for anything else to try the teams in the game. of course that the places where your team logo goes will be empty and the field logo will be, for some extrange reason, Real Madrid's.
and my team's IDs go from 1999 to 2008 with autonumeric
Originally posted by sKIp_E
yeah ive added teams.
The problem is with adding teams, that the game crashes on loading if u use an unused, low teamID (so the game doesnt detect it as a new team). I assume because their is no art for that team.
Also, if u use a hgiher ID (the autonumber), the game runs, BUT u get a team that loses its team lineup, and player numbers etc.
BUT with the latest findings (that the CC creates seperate dbi files) it may be possible to import the needed art, to the teams added with the lower ID's.
Im not sure yet, I havent tried it, but it seems more likely to work now.
Ill check later
Cheers
sKIp_E
I have succesfully added 10 teams, and they have everything they need and they work fine in the game.
The thing is that you have to add them to an existing league cause they dont appear as CC Created Teams.
So I just addedd them to the rest of the world section and then I can create a league in CC and add select the teams from that section.
just add the flags and kits with your team's ID to the data folder and thats it.
there's no need for anything else to try the teams in the game. of course that the places where your team logo goes will be empty and the field logo will be, for some extrange reason, Real Madrid's.
and my team's IDs go from 1999 to 2008 with autonumeric
