Not sure in you read my follow up of your response.
Thank You Again
Steven E. Greenwalt Jr.
ECTISP
"Steven E. Greenwalt Jr." wrote:
> 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
> 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
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart