Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with Access 2000 and SQL 2000
Message
From
29/05/2001 17:04:02
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Problems with Access 2000 and SQL 2000
Miscellaneous
Thread ID:
00512420
Message ID:
00512420
Views:
42
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
Map
View

Click here to load this message in the networking platform