the setting for the DecimalPlaces error in a ACC2003 project

[theking2]

When I open one table in a ACC2003 Project connecting to a SQLServer database
I always get the error "The setting for the DecimalPlaces property must be
from 0 through 15, or 255 for Auto (default)." If repaired the database
project and even recreated it. What can be the cause of this problem and how
to repair this?

 

[Mike Labosh]

When I open one table in a ACC2003 Project connecting to a SQLServer

database
I always get the error "The setting for the DecimalPlaces property must be
from 0 through 15, or 255 for Auto (default)." If repaired the database
project and even recreated it. What can be the cause of this problem and
how
to repair this?

This could be a difference between the way that SQL Server and Access have
the data types set for that column.

List for us, for the SQL Server column, and for the Access column, the Data
Type, Size, Precision and Decimal places.

Many of us in here have both SQL Server and Access, so if you post that
information, we can figure it out.
--


Peace & happy computing,

Mike Labosh, MCSD MCT
Owner, vbSensei.Com

"Veritas e aequitas; in nominae Patri, et Fili, et Spiritus Sancti."
-- The Boondock Saints

 

[theking2]

Thanks Mike, How simple your question sounds it is not that simple to answer.
As Access is (as normally) elusive in its error messages it does not disclose
which column is the cuplrit. So here goes the Access between «» the values
for size and decimal places:

ID int(4) «10/0»
BatchID int(4) «10/0»
ICCID char(19)
Ki32Hex char(32)
Pin char(4)
Puk char(8)
Pin2 char(4)
Puk2 char(8)
State char(1)
Notes nvarchar(50)

SqlServer
CREATE TABLE [dbo].[tblSim] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[BatchID] [int] NOT NULL ,
[ICCID] [char] (19) COLLATE Latin1_General_CI_AS NOT NULL ,
[Ki32Hex] [char] (32) COLLATE Latin1_General_CI_AS NULL ,
[Pin] [char] (4) COLLATE Latin1_General_CI_AS NULL ,
[Puk] [char] (8) COLLATE Latin1_General_CI_AS NULL ,
[Pin2] [char] (4) COLLATE Latin1_General_CI_AS NULL ,
[Puk2] [char] (8) COLLATE Latin1_General_CI_AS NULL ,
[State] [char] (1) COLLATE Latin1_General_CI_AS NOT NULL ,
[Notes] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL
) ON [PRIMARY]

is there a way of generating a design script for Access?