Linking numeric fields from Sequel 7 being converted to text

[Colin]

I hope someone out there can help:

We are currently using Access 2003 and linking to SQL files for data.
problem is that even though fields coded as numeric in Sequel, they come down
text in Access 2003 after being linked. So far we've discovered that the
Access Jatabase database engine brings all fields with more than 15
characters to text to protect info integrity. Thats nice but completely
doesn't help me since I have to do calculations on these feilds so I have to
convert back again to numeric.

Some of the info on the web said something about modifying Jetfix tables to
fix this problem, but can't find instructions how to do so.

So, to sum up: I want to be able to bring SQL numeric fields with more than
15 characters into Access 2003 as numeric fields - How do I do that at the
initial linking and not have to convert later in query?

Thanks for reading and I hope you can help!

 

[Jeff C]

--
Jeff C
Live Well .. Be Happy In All You Do

I hope someone out there can help:

We are currently using Access 2003 and linking to SQL files for data.
problem is that even though fields coded as numeric in Sequel, they come down
text in Access 2003 after being linked. So far we've discovered that the
Access Jatabase database engine brings all fields with more than 15
characters to text to protect info integrity. Thats nice but completely
doesn't help me since I have to do calculations on these feilds so I have to
convert back again to numeric.

Some of the info on the web said something about modifying Jetfix tables to
fix this problem, but can't find instructions how to do so.

So, to sum up: I want to be able to bring SQL numeric fields with more than
15 characters into Access 2003 as numeric fields - How do I do that at the
initial linking and not have to convert later in query?

Create a temporary table to bring the data into via an append query. For the
problem field specify Decimal, Precision 19, scale 0.

When you append the data the SQL number should be appended in the correct
format.

 

[Colin]

Thanks Jeff. I'll try but I was trying to come up with something that
converts number directly from SQL since most of the users of this file are
not that sophisticated and bringing table in, then appending into new table
with properties already converted may be beyond them (even though its simple).

I'm still exploring possibility of changing Access jet database controls to
accept fields with lengths greater than 15. If we can do this, then it will
be invisible to all other users

 

[cristiano talon]

I hope someone out there can help:

We are currently using Access 2003 and linking to SQL files for data.
problem is that even though fields coded as numeric in Sequel, they come
down
text in Access 2003 after being linked. So far we've discovered that the
Access Jatabase database engine brings all fields with more than 15
characters to text to protect info integrity. Thats nice but completely
doesn't help me since I have to do calculations on these feilds so I have
to
convert back again to numeric.

Some of the info on the web said something about modifying Jetfix tables
to
fix this problem, but can't find instructions how to do so.

So, to sum up: I want to be able to bring SQL numeric fields with more
than
15 characters into Access 2003 as numeric fields - How do I do that at the
initial linking and not have to convert later in query?

Thanks for reading and I hope you can help!