Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KevMull
Starting Member
11 Posts |
 Posted - 2005-02-11 : 17:02:42
|
| I have three linked tables, all one to many in a typical Orders db...Users > Orders > Order ItemsTable Orders just won't upsize, it fails everytime.Even if I break it's link and try to upsize it on it's own!It's fields are as follows....UserID2 (Long Int, foreign key)OrderID (AutoNum, PK)OrderTitle (text)OrderDate (no format specified).It will upsize th etable on either side of it.I've a feeling it has something to do with the PK field, buttable Users has one and upsizes ok.I'm doing a simple 'upsize and link tables' to MSDE from Access 2000 and not creating a project file.Any ideas?Many Thanks |
|
|
Auric
Yak Posting Veteran
70 Posts |
Posted - 2005-02-11 : 18:21:38
|
| Ok...silly question, do you have proper primary key fields setup? JoshSelect * from users where clue > 0 |
 |
|
|
KevMull
Starting Member
11 Posts |
Posted - 2005-02-11 : 18:28:20
|
| By 'proper' do you mean autonumbers?If so then yes, Users and Orders have autonumber (PK) fields.I've just tried something else....If I break th elink between Users and Orders then Orders and Items will upsize OK, so the problem seems to be in the link between Users and Orders(?) |
|
|
|
KevMull
Starting Member
11 Posts |
Posted - 2005-02-11 : 20:46:25
|
Update....Now it won't upsize at all if I break the links, however it will upsize if I change the table name  |
|
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2005-02-14 : 06:45:15
|
| bit of a wild guess but perhaps either the word Order or Items in your Order Items table are reserved words somewhere within the Upsize process and thus 'confuses' the upsizing wizard ?!====Paul |
|
|
|
|
|
|
Problems Upsizing To MSDE With Linked Tables