virgin? poor baby!! hahaha
----- Original Message -----
From: "Brian Mitter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 03, 2000 5:03 AM
Subject: Re: SQL Server Virgin seeks advice
> Thanks Andy,
> That was the way our Admin guy insisted he had imported the database
> and I assumed he had done it ok.....
> Anyway I got him to give me permissions to try later last night from home
> and lo and behold it worked first time. No idea what he was doing
> differently, if he was using the same procedure to import the database
could
> the different accounts/permissions (his and mine) cause this sort of
error?
>
> Thanks
> Brian
>
> ----- Original Message -----
> From: Andy Ewings <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, August 02, 2000 3:50 PM
> Subject: RE: SQL Server Virgin seeks advice
>
>
> > If I were you I wouldn't use the upsize wizard. I'd use the import data
> > facility within SQL (right click on tables, all tasks, import data) The
> > wizard is fairly self explanitory. Make sure you use the transfer data
> > option rather than using a query to select data.
> >
> > You also get much more flexibility using SQL rather than Access to move
> your
> > data like being able to specify where ther database file (mdf file) and
> the
> > log file are stored on the server which you can't do using the upsizing
> > wizard.
> >
> > -----Original Message-----
> > From: Brian Mitter [mailto:[EMAIL PROTECTED]]
> > Sent: 02 August 2000 15:31
> > To: [EMAIL PROTECTED]
> > Subject: SQL Server Virgin seeks advice
> >
> >
> > I'm (trying to!) upsize my first access db to a sql7 db but I'm having a
> > small problem which I *think* must be something basic but I can't get my
> > head around it at all.
> >
> > The upsize seems to go ok but when I view the data that has been
imported
> by
> > the wizard, three of the tables have no data imported and have this
error.
> >
> > "query based insertion or updating of BLOB values cannot be supported"
> >
> > I *think* it has something to do with the memo fields that each of these
> > tables have. The wizard has created the memo fields as ntext (16).
> >
> > Can anyone explain what is happening here and possibly how to fix/get
> round
> > this?
> >
> > I've searched MS technet for this error and the only thing I can find is
a
> > reference to visual interdev (which I am not familiar with at all) and
> left
> > me none the wiser. Apologies in advance for OT post.
> >
> > Thanks
> > Brian
> >
>
> --------------------------------------------------------------------------
> --
> > --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
>
> --------------------------------------------------------------------------
> ----
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
