Re: [RadiusNT] Access to SQL (error when adding user account)

Steven E.Greenwalt Jr. ( (no email) )
Thu, 12 Oct 2000 09:24:42 -0500

I am using the Access database that was up sized, to add users and make
changes, Access is the interface to the SQL data, I am not using ISQL or
Enterprise Manager to make the changes.

The Access database works fine when it is a standalone, but after I up sized it
to SQL is when I stopped having the ability to add users. I can make changes to
the users that are in the database with no problem.

The SQL will let the user on to the service that were in the original database.

I know that the changes are being made to SQL because I have changed the
password of a few of the users and they were able to get back on to the

I hope I'm clearer this time.

Thank You for your help.


Josh Hillman wrote:

> If you're trying to insert (or update) the MasterAccounts.CustomerID field
> via ISQL or Enterprise Manager, you can't--it's an auto-incrementing number
> that's handled by SQL Server anytime a new row of data is added.
> Josh
> ----- Original Message -----
> From: "Steven E.Greenwalt Jr." <>
> To: "RadiusNT List" <>
> Sent: Wednesday, October 11, 2000 6:10 PM
> Subject: [RadiusNT] Access to SQL (error when adding user account)
> > Back Ground:
> > Radius 3.0.175
> > SQL 6.5
> > The Access database came from radius 3.0
> > The users that I had in the original database can login, thorough SQL
> >
> > What I am trying to do is move my access data into SQL. That went will.
> > But when I try to add a user through the SQL database I get this error.
> > (The column CustomerID in table dbo.billing may not be null (#233))
> >
> > It does show to be link in the relationship for the data to be added to
> > the billing table.
> >
> > I am filling in the Blank for billing.
> >
> > Has any one done what I am trying to do, and did you run into this
> > problem?
> >
> > Thank You
> > Steven
> >
> >
> > For more information about this list (including removal) go to:
> >
> >
> For more information about this list (including removal) go to:

For more information about this list (including removal) go to: