Second table, very similar.
/****** Object: Table [dbo].[Event Staff Payroll Alterations 2] Script
Date: 06/23/2009 16:52:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Event Staff Payroll Alterations 2](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Group Sort] [int] NULL,
[Item Sort] [int] NULL,
[User] [varchar](50) NULL,
[Group] [varchar](50) NULL,
[Extra2] [varchar](50) NULL,
[Tick] [bit] NULL,
[DropDown1] [varchar](50) NULL,
[DropDown2] [varchar](50) NULL,
[Receipt] [bit] NULL,
[Fine] [float] NULL,
[Fee] [float] NULL,
[Date] [datetime] NULL,
[Event ID] [int] NULL,
[Staff ID] [int] NULL,
[Group Filter] [varchar](50) NULL,
[Notes] [varchar](max) NULL,
[CurrentReprimandFlag] [varchar](50) NULL,
[SSMA_TimeStamp] [timestamp] NOT NULL,
CONSTRAINT [PK_Event Staff Payroll Alterations 2] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Event Staff Payroll Alterations 2] WITH NOCHECK ADD
CONSTRAINT [SSMA_CC$Event Staff Payroll Alterations 2$Group
Filter$disallow_zero_length] CHECK ((len([Group Filter])>(0)))
GO
ALTER TABLE [dbo].[Event Staff Payroll Alterations 2] CHECK CONSTRAINT
[SSMA_CC$Event Staff Payroll Alterations 2$Group
Filter$disallow_zero_length]
GO
ALTER TABLE [dbo].[Event Staff Payroll Alterations 2] ADD DEFAULT ((0)) FOR
[Group Sort]
GO
ALTER TABLE [dbo].[Event Staff Payroll Alterations 2] ADD DEFAULT ((0)) FOR
[Item Sort]
GO
ALTER TABLE [dbo].[Event Staff Payroll Alterations 2] ADD DEFAULT ((0)) FOR
[Tick]
GO
ALTER TABLE [dbo].[Event Staff Payroll Alterations 2] ADD DEFAULT ((0)) FOR
[Receipt]
GO
ALTER TABLE [dbo].[Event Staff Payroll Alterations 2] ADD DEFAULT ((0)) FOR
[Fine]
GO
ALTER TABLE [dbo].[Event Staff Payroll Alterations 2] ADD DEFAULT ((0)) FOR
[Fee]
GO
ALTER TABLE [dbo].[Event Staff Payroll Alterations 2] ADD DEFAULT
(CONVERT([datetime],CONVERT([varchar],getdate(),(1)),(1))) FOR [Date]
GO
ALTER TABLE [dbo].[Event Staff Payroll Alterations 2] ADD DEFAULT ((0)) FOR
[Event ID]
GO
ALTER TABLE [dbo].[Event Staff Payroll Alterations 2] ADD DEFAULT ((0)) FOR
[Staff ID]
GO
Post by Rick Byham, MSFTAnything in common for the problem tables? Do the tables share an unusual
data type?
--
Rick Byham, MSFT
(Implies no warranty or rights)
Post by JohnPK is there and I undid and redid it just to be sure. Records are all in
and seem to be OK in cursory browsing in Management Studio. All tables
have thousands of records so hard to check all manually.
Thanks
Regards
Post by Tony Toews [MVP]Post by JohnI have upsized an Access 97 database to sql server 2008 using Microsoft SQL
Server Migration Assistant 2008 for Access. Migrated tables were linked to
the Access 97 database front end by the Assistant. Most of the tables have
migrated fine. However, a handful of tables when opened in access give the
error 'ODBC--call failed' and all fields show #Name? as values. What is the
problem and how can I fix it?
Some possibilities might be to ensure those tables have a primary key
and RowVersion aka TimeStamp field specified.
Can you open up those tables in the Management Tools and does the
layout look reasonable and are there records in the table?
Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/