can you modify linked table properties

T

TracyG

I have an sql table linked with ODBC. Access is making the assumption that
the field property for a decimal field is currency and it needs to be a
general decimal number instead. How can you modify table/field properties on
a linked table? It's a sql table if that makes a difference.
 

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

Excel does not accept text format! 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Link table field format puzzle 1
Problems With Precision while Linking Tables 4
Excel - Wich Function should I use? 1
Linked SQL Tables don't report Cascading Updates and Deletes 2
Mail Merge - displaying a conditional number of decimals 5
Manage ODBC 2

Top