Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1589

Re: Can't append a record to SQL Server table because of OLE field

Show all headers | View raw

Tony (bluestealth94@hotmail.com) writes:
> I am trying to append from Access to a SQL Server table - one record.
> I am told the problem is because of the OLE datatype in the sql table.
> We used to be able to do it but for the last few years the sql server
> has not let us.  Does anybody have any ideas on what can be the cause
> of this problem?

I think this question is better asked in an Access forum. They might
know what the "OLE datatype" is. All I know is that there is no such
type in SQL Server.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next | Find similar

Thread

Re: Can't append a record to SQL Server table because of OLE field Erland Sommarskog <esquel@sommarskog.se> - 2011-02-08 00:09 +0100

csiph-web