Linking to Oracle 9i through Access 97

G

Guest

When I view a linked Oracle table through Access in design view, the Oracle
Number datatype fields show up as Text and the VB code expects a number, a
Long. The VB app is an old, but stable one and I hate to change its code if
I don't have to (especially since it's on schedule to be rewritten next
year). But for the sake of an interface several of the tables need to reside
in an Oracle database. Any suggestions?
 
G

Guest

I figured it out. When I specified the Oracle Number data type to be 6, it
worked fine.
 

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

Top