OLE Object data type error...

R

Ramesh

Hi,
I (Created) MSAccess 2000 database using SqlServer Exportdata.
In one of my table in SQL server has column data type as Image.When i
export data from SQL to MSAccess it converted the data type as OLE
Object.When i tried to view the data contents using MSAccess forms I always
used to get the following error.
"A problem occurred while Microsoft Access was communicating with OLEServer
or MSAccess"
Is there any other way to know whether data is properly exported from SQL to
MSAccess or should i do any other selection while exporting data from SQL to
MSAccess.
Please advice me!!!!
Thanks in Advance!!!!
Regards,
Ramesh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OLE object data type error. 0
OLE Object data type error.... 0
Causing timeouts querying SQL Server 2
SQL Server over the Internet...big picture questions 15
Securing Access data? SQL 2000 alternative? 1
Table Format Property > not recognized cuasing no data to be displ 4
error activex ole server on load 0
ODBC error on linked SQL server table, by Access 2003 0

Top