not sure.....if he gave you the same permissions that he has (which should
be dbo) then there shouldn't be any difference.
-----Original Message-----
From: Brian Mitter [mailto:[EMAIL PROTECTED]]
Sent: 03 August 2000 10:03
To: [EMAIL PROTECTED]
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.
