joop123456
asked on
SQL Upsize error in table
Hi, these two tables are being skipped when upsizing to SQL Express, don't know how to solve it / where to look,...
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---
Table: tblT1VerkoopContract
Microsoft Access SQL Server
Table Name: tblT1VerkoopContract
Attached Table Name:
Aliasing Query:
Validation Rule:
Skipping table 'tblT1VerkoopContract'...
Server Error 102: Incorrect syntax near 's'.
Server Error 105: Unclosed quotation mark after the character string ' ,
OfferteID nvarchar (50) ,
Aanhef int ,
Afsluiting int ,
AanhefMEMO ntext ,
AfsluitingMEMO ntext ,
BevNieuw bit
DEFAULT 1 ,
)'.
Table: tblT2VerkoopContract
Microsoft Access SQL Server
Table Name: tblT2VerkoopContract
Attached Table Name:
Aliasing Query:
Validation Rule:
Skipping table 'tblT2VerkoopContract'...
Server Error 102: Incorrect syntax near 's'.
Server Error 105: Unclosed quotation mark after the character string ' ,
ArrivalNoticeTEXT1 int
,
AlleLoadordersVerstuurd datetime ,
Jaartal int
DEFAULT 2006 ,
HoofdItemID nvarchar (50) ,
HoofdItemrestrictieID int
,
Herkomst nvarchar (50) ,
ContractBevestigd bit
DEFAULT 0 ,
)'.
--------------------------
Table: tblT1VerkoopContract
Microsoft Access SQL Server
Table Name: tblT1VerkoopContract
Attached Table Name:
Aliasing Query:
Validation Rule:
Skipping table 'tblT1VerkoopContract'...
Server Error 102: Incorrect syntax near 's'.
Server Error 105: Unclosed quotation mark after the character string ' ,
OfferteID nvarchar (50) ,
Aanhef int ,
Afsluiting int ,
AanhefMEMO ntext ,
AfsluitingMEMO ntext ,
BevNieuw bit
DEFAULT 1 ,
)'.
Table: tblT2VerkoopContract
Microsoft Access SQL Server
Table Name: tblT2VerkoopContract
Attached Table Name:
Aliasing Query:
Validation Rule:
Skipping table 'tblT2VerkoopContract'...
Server Error 102: Incorrect syntax near 's'.
Server Error 105: Unclosed quotation mark after the character string ' ,
ArrivalNoticeTEXT1 int
,
AlleLoadordersVerstuurd datetime ,
Jaartal int
DEFAULT 2006 ,
HoofdItemID nvarchar (50) ,
HoofdItemrestrictieID int
,
Herkomst nvarchar (50) ,
ContractBevestigd bit
DEFAULT 0 ,
)'.
ASKER
tblT1VerkoopContract:
-------------------------- ---------- ---------- ---------- -------
VerkoopcontractAUTOID AutoNumber
VerkoopcontractID Text
Klant Text
KorteContractOmschrijving Text
tblStatus Text
VerkoopBevestigingGestuurd Yes/No
VerkoopbevID Text
VerkoopbevDatum Date/Time With default value: Now()
VerkoopbevAanhefMEMO Memo
VerkoopbevAfsluitingMEMO Memo
OfferteID Text
Aanhef Number
Afsluiting Number
AanhefMEMO Memo
AfsluitingMEMO Memo
BevNieuw Yes/No
- No spaces, quotes, underscores etc.
- Removing all relationships does bot change anything when upsizing
- Removed all "Select distinct" etc. (just to try..)
--------------------------
VerkoopcontractAUTOID AutoNumber
VerkoopcontractID Text
Klant Text
KorteContractOmschrijving Text
tblStatus Text
VerkoopBevestigingGestuurd
VerkoopbevID Text
VerkoopbevDatum Date/Time With default value: Now()
VerkoopbevAanhefMEMO Memo
VerkoopbevAfsluitingMEMO Memo
OfferteID Text
Aanhef Number
Afsluiting Number
AanhefMEMO Memo
AfsluitingMEMO Memo
BevNieuw Yes/No
- No spaces, quotes, underscores etc.
- Removing all relationships does bot change anything when upsizing
- Removed all "Select distinct" etc. (just to try..)
Upsizing to SQL Express using what tool?
ASKER
With the Access 2k3 upsize wizard..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
MS recommend using.......
Why on earth does this "Access upsize utility" exists then,...?!?!?
Or let the user somehow know that something better is available,... from the same company.....
Incredible... I've spend a couple of da... Nevermind.... :)
Allright, got zero errors but, but a big number of recommendations + info... Going to sort out that first..
Tnx for the help!
Why on earth does this "Access upsize utility" exists then,...?!?!?
Or let the user somehow know that something better is available,... from the same company.....
Incredible... I've spend a couple of da... Nevermind.... :)
Allright, got zero errors but, but a big number of recommendations + info... Going to sort out that first..
Tnx for the help!
No, surely the point here is that you're using SQL 2005. (SQL Express)
It'd be somewhat unfair to judge MS too harshly on this point - as SQL Server 2005 is substantially newer than Access 2003.
The upsizing wizards work "OK" for earlier versions. (But DTS was always better - but even DTS's replacement isn't present in 2005 Express)
I think it's actually cool that we have this tool to use with a high level of success in the mean time. :-)
It'd be somewhat unfair to judge MS too harshly on this point - as SQL Server 2005 is substantially newer than Access 2003.
The upsizing wizards work "OK" for earlier versions. (But DTS was always better - but even DTS's replacement isn't present in 2005 Express)
I think it's actually cool that we have this tool to use with a high level of success in the mean time. :-)
ASKER
Maybe a bit unfair, but on the other hand if there one softwarecompany who is good in 'your-version-aint-compati ble today'-popups then we both know who that is. (But of course I know where on the end the software, read my database, more or less is coming from.)
what is the table definition in Access for
tblT1VerkoopContract