HELP! Access upsize problem

[Ken Schaefer]

You need to connect to SQL Server with the appropriate priveleges (eg
Database Owner) -or- if you are getting an error, you need to tell us what
it is.

Cheers
Ken


"Mini Me" <mini@me.com> wrote in message
news:MPG.1965cfbf2230ce0989727@news-east.giganews.com...
: Enterprise Manager won't let me modify an existing column. I can only
: delete a column.
:
: I ended up having to remove the table and re-create it with the proper
: data types, then re-import the data for that table.
:
:
:
: In article <O3k4PQ7ODHA.1748@TK2MSFTNGP11.phx.gbl>,
: [email]kenREMOVE@THISadOpenStatic.com[/email] says...
: > Identity is a constaint that you put on a column, eg an integer column.
: >
: > In SQL Server Enterprise Manager, goto the table definition, and set
: > Identity = Yes for the integer column in question.
: >
: > "Mini Me" <mini@me.com> wrote in message
: > news:MPG.19646847a4d07a7a989726@news-east.giganews.com...
: > : I imported an access database into SQL Server 2000 and it did not
: > : properly convert the datatypes in my database.
: > :
: > : I have an "Autonumber" field that it converted into an Integer instead
: > : of an IDENTITY.
: > :
: > : Can I change the datatype of an existing field/column in Access 2000?
: > :
: > : If not, can I delete the column then insert a new column with the
: > : correct data type?
: > :
: > : I don't care if all of the data for the field/column is lost.

[Dave Navarro]

Ken,

It was "operator error" on my part. I am able to change data types
using the Enterprise manager. However, I still had to delete many of
the tables and re-create them simply because they were set up wrong to
begin with.

I've taken Aaron's advice from ASPFAQ and re-created all of the tables
so that none of the columns support NULL. The original Access database
had a LOT of NULL values that prevented me from modifying the existing
tables.

It took all weekend, but I got it done.

Now I just need to get my DATETIME problems resolved in the ASP code.

--Dave

In article <u#4Qc4qPDHA.2636@TK2MSFTNGP10.phx.gbl>,
[email]kenREMOVE@THISadOpenStatic.com[/email] says...

> You need to connect to SQL Server with the appropriate priveleges (eg
> Database Owner) -or- if you are getting an error, you need to tell us what
> it is.
>
> Cheers
> Ken
>
>
> "Mini Me" <mini@me.com> wrote in message
> news:MPG.1965cfbf2230ce0989727@news-east.giganews.com...
> : Enterprise Manager won't let me modify an existing column. I can only
> : delete a column.
> :
> : I ended up having to remove the table and re-create it with the proper
> : data types, then re-import the data for that table.