Linking Access to an Oracle database

J

jbaldwin

I am trying to link an Oracle database to my Access tables. when I do so
Access is translating my Oracle table which is set to VARCHAR(412) to a memo
field. I actually only have about 150 characters in the field. I can't make
any changes to the Oracle database.

Can someone tell me how to get Access to truncate the field and set it to a
text field with a default value of 255 characters?

Thanks
 

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

Linking Access and Oracle Database 2
oracle fields exceed 255 3
Access Database Export trying to convert into Oracle 0
Linking to Oracle 5
Problem connecting Access to Oracle 0
Field Values When Linking to an Oracle Table 1
Linking to Oracle via ACCESS 1
Link table from Oracle database 0

Top