General information
Forum:
Microsoft SQL Server
Title:
Problems with Access 2000 and SQL 2000
I have a question that maybe someone could help me with I will start out by saying that a client of mine had a Access 97 client with a Oracle 8 database they were not real happy with the way it worked and have had a lot of problems with it going down so we decided to convert that Oracle to SQL 2000 and then upgrade the access 97 client to access 2000. With all of this going on everything has went along very good and we are getting close to going live but I have one problem that I can not figure out and this is the problem. I have a form with a sub form in it and as it open up it gets three different numbers from the form that opens it up and relates it to the actual trip the sub form is a Continuous Form with six combo boxes in it when I use the combo box if it seems like it is putting the info in but if I go to close out or try to put information in the next row I get this error. [microsoft][odbc sql server driver][sql server]cannot insert the value null into column 'groupid',table 'CTI_sql.dbo.roommates': column does not allow nulls, Insert fails. (#515) [Microsoft][odbc sql server driver][sql server] the statement has been terminated.(#3521) Does anyone have any ideas what this could be. I do not get this with 97 to oracle.
Thanks for all the help
Bill
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only