User profile for fraudh8er

I see what you mean, I turned it on and noticed a difference. Then turned it back off and say the synch numbers go down because it was not looking at that. For some reason I still have one field in one table that doesnt want to pay attention to that option. Apparently it is special or something, not sure. Honestly doesnt make any sense. Well I guess it is 2 fields in 2 tables, but whatever, I suppose I can get around that, the problem would lie in if I did a bigger database and had more of this problem? Any thoughts..? / comments

I see what you mean, I turned it on and noticed a difference. Then turned it back off and say the synch numbers go down because it was not looking at that. For some reason I still have one field ...

0 votes

Yep, it worked thank you. / comments

Yep, it worked thank you.

0 votes

This issue has been resolved, Thank you. But I would like to know if you company is aware of a program that will do what this program does for MS Access Mdb's. Thank you, you can email me directly if you would like. / comments

This issue has been resolved, Thank you. But I would like to know if you company is aware of a program that will do what this program does for MS Access Mdb's. Thank you, you can email me directl...

0 votes

This is Error Number One This is Error Number Two This is Error Number Three: The following error message was returned from the SQL Server: [515] Cannot insert the value NULL into column 'SDate', table 'SSLeSueurCopy.dbo.Jail_Record_Suicide'; column does not allow nulls. UPDATE fails. The following SQL command caused the error: ALTER TABLE [dbo].[Jail_Record_Suicide] DROP COLUMN [ID] ALTER TABLE [dbo].[Jail_Record_Suicide] ALTER COLUMN [Jail_ID] [int] NOT NULL ALTER TABLE [dbo].[Jail_Record_Suicide] ALTER COLUMN [SDate] [datetime] NOT NULL ALTER TABLE [dbo].[Jail_Record_Suicide] ALTER COLUMN [STime] [datetime] NOT NULL This is Error Number Four The following error message was returned from the SQL Server: [515] Cannot insert the value NULL into column 'ID', table 'SSLeSueurCopy.dbo.tmp_rg_xx_IR_Statement'; column does not allow nulls. INSERT fails. The following SQL command caused the error: INSERT INTO [dbo].[tmp_rg_xx_IR_Statement]([Case_ID], [Case_Number], [SSQ], [SDate], [STime], [SLocation], [SName], [DOB], [Age], [SSN], [SAddress], [SCity], [SState], [SZip], [SPhone], [SEmployer], [Officer], [Officer_ID], [SNarrative], [Complete_Date], [Complete_Time], [WitnessA], [WitnessB], [MNI_No], [SType]) SELECT [Case_ID], [Case_Number], [SSQ], [SDate], [STime], [SLocation], [SName], [DOB], [Age], [SSN], [SAddress], [SCity], [SState], [SZip], [SPhone], [SEmployer], [Officer], [Officer_ID], [SNarrative], [Complete_Date], [Complete_Time], [WitnessA], [WitnessB], [MNI_No], [SType] FROM [dbo].[IR_Statement] This is Error Number Five The following error message was returned from the SQL Server: [515] Cannot insert the value NULL into column 'UCR_CHECK_ID', table 'SSLeSueurCopy.dbo.tmp_rg_xx_List_Box_UCR_Check'; column does not allow nulls. INSERT fails. The following SQL command caused the error: INSERT INTO [dbo].[tmp_rg_xx_List_Box_UCR_Check]([ERRORDER]) SELECT [ErrOrder] FROM [dbo].[List_Box_UCR_Check] The following messages were returned from the SQL Server: Error Six The following error message was returned from the SQL Server: [515] Cannot insert the value NULL into column 'Action', table 'SSLeSueurCopy.dbo.tmp_rg_xx_Menu_List'; column does not allow nulls. INSERT fails. The following SQL command caused the error: INSERT INTO [dbo].[tmp_rg_xx_Menu_List]([ID], [ReportName], [ReportType], [Report_Description], [City], [State], [User_Level], [PreFunction], [Identifier], [Order]) SELECT [ID], [ReportName], [ReportType], [Report_Description], [City], [State], [User_Level], [PreFunction], [Identifier], [Order] FROM [dbo].[Menu_List] / comments

This is Error Number One This is Error Number Two This is Error Number Three: The following error message was returned from the SQL Server: [515] Cannot insert the value NULL into column 'SDate', t...

0 votes

So know I know which columns in which tables are causing the problem. I cannot set the coumns in the tables to allow NUlls because they are Primary Keys. Can I tell the program to disregard just that field in that table. Or would I have to do this via editing the escript. Thank you Neil / comments

So know I know which columns in which tables are causing the problem. I cannot set the coumns in the tables to allow NUlls because they are Primary Keys. Can I tell the program to disregard just ...

0 votes

Can I get the report to just show me the difference, the current report lists all the fiels for the table even if it only has one field that is different. I would like to see just the one field that is different. This is making out reports longer than they should be. If this is not possible, do you have any other ideas? / comments

Can I get the report to just show me the difference, the current report lists all the fiels for the table even if it only has one field that is different. I would like to see just the one field th...

0 votes

Do you want a copy of the database before or after the sync is done? / comments

Do you want a copy of the database before or after the sync is done?

0 votes

it is on it way Thank you Neil / comments

it is on it way Thank you Neil

0 votes

Do you want me to send you both databases, I dont get the error until I do that sync. The datanases work fine before the sync is done. Do you still want to databases? / comments

Do you want me to send you both databases, I dont get the error until I do that sync. The datanases work fine before the sync is done. Do you still want to databases?

0 votes

Object cannot be cast from DBNull to other types Is this similar to the topis above, and it not how do I solve this error when trying to do a comparison. Thank you / comments

Object cannot be cast from DBNull to other types Is this similar to the topis above, and it not how do I solve this error when trying to do a comparison. Thank you

0 votes

How can we help you today?

fraudh8er

Comments