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
service.
I hope I'm clearer this time.
Thank You for your help.
Steven
ECTISP
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." <steven@ectisp.net>
> To: "RadiusNT List" <radiusnt@iea-software.com>
> 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
> > ECTISP
> >
> >
> > For more information about this list (including removal) go to:
> > http://www.iea-software.com/support/maillists/liststart
> >
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart