Two databases

C

Clyde Thorne

I am using MS Access 2003. During my queries I can bring up all the
information needed from my tables. When I start another query, I will add
the smaller, previous query to the 2nd query in the design view. When I run
the query, not all of the information from the 1st query will transfer over
to the larger query. The larger query is 140,000KB. Any ideas why the data
won't move over. I'm suspecting that Access can't hold that much data.

Can you help? Thanks.
 
M

[MVP] S.Clark

You're explanation is too vague. Please provide more exact examples. For
SQL Query specific questions, try using the access.queries newsgroup.
 
C

Clyde Thorne

I'll try again. I make 4 small queries to extract all of the information I
need from different tables. Then, I'll create another large query using the
information from the previous smaller queries. When I run the new large
query, not all of the information will pass over. This data from the small
query
"SLAB;TWO(D8R2SLAB;ONE(S10~E9~E9~N10~L18)R18R2RPO;ONE(R15U1U5L15D6)U6R15U10L17UBM;ONE(U12L12D12R12)L12L8D8)
SLAB;ONE(L10U2UBM;ONE(L18U34R18OH(U2R37D2UBM;TWO(R14WOD(U8R25D23GAT(D28L29U5U10U13R4R25)L25U15)D15L4D13
L17U12L12D12L8U4L10U10R8U14R29)L29L8)R8D14L8D10D10)U10R10D4D8)RPO;RPO(D8L10U8R10)FBM(1800)
" will get cut off about 2/3 of the way into the larger query. All of this
information sits in one cell. It fits in one cell in the smaller query but
not in the larger query. I don't understand why. Any ideas?

clyde thorne




[MVP] S.Clark said:
You're explanation is too vague. Please provide more exact examples. For
SQL Query specific questions, try using the access.queries newsgroup.
Click to expand...
 
C

Clyde Thorne

I'll try again. I make several small queries to extract all of the
information I need from existing tables that have been imported in. I do
this because I need to concatenate some of the cells before I moved them
over to the larger query. One of the cells of the smaller query have this
information in it,
"SLAB;TWO(D8R2SLAB;ONE(S10~E9~E9~N10~L18)R18R2RPO;ONE(R15U1U5L15D6)U6R15U10L17UBM;ONE(U12L12D12R12)L12L8D8)
SLAB;ONE(L10U2UBM;ONE(L18U34R18OH(U2R37D2UBM;TWO(R14WOD(U8R25D23GAT(D28L29U5U10U13R4R25)L25U15)D15L4D13
L17U12L12D12L8U4L10U10R8U14R29)L29L8)R8D14L8D10D10)U10R10D4D8)RPO;RPO(D8L10U8R10)FBM(1800)
". When I make my larger query, and transfer all of the information from
the smaller queries into the larger query, I lose about 1/3 of the
information in that one cell. Any idea why I would lose this information.
Hope this is a better explanation.

clyde




[MVP] S.Clark said:
You're explanation is too vague. Please provide more exact examples. For
SQL Query specific questions, try using the access.queries newsgroup.
Click to expand...
 
J

John Vinson

I'll try again. I make several small queries to extract all of the
information I need from existing tables that have been imported in. I do
this because I need to concatenate some of the cells before I moved them
over to the larger query. One of the cells of the smaller query have this
information in it,
"SLAB;TWO(D8R2SLAB;ONE(S10~E9~E9~N10~L18)R18R2RPO;ONE(R15U1U5L15D6)U6R15U10L17UBM;ONE(U12L12D12R12)L12L8D8)
SLAB;ONE(L10U2UBM;ONE(L18U34R18OH(U2R37D2UBM;TWO(R14WOD(U8R25D23GAT(D28L29U5U10U13R4R25)L25U15)D15L4D13
L17U12L12D12L8U4L10U10R8U14R29)L29L8)R8D14L8D10D10)U10R10D4D8)RPO;RPO(D8L10U8R10)FBM(1800)
". When I make my larger query, and transfer all of the information from
the smaller queries into the larger query, I lose about 1/3 of the
information in that one cell. Any idea why I would lose this information.
Hope this is a better explanation.
Click to expand...

A Text field is limited to 255 characters. Are you putting this into a
Text field or a (much less limited) Memo field?

John W. Vinson[MVP]
 
C

Clyde Thorne

A Text Field. Is there a way to increase this field. In a query it all
shows up, but not in the table/query. Thanks.
clyde
 
J

John Vinson

A Text Field. Is there a way to increase this field. In a query it all
shows up, but not in the table/query. Thanks.
Click to expand...

Use a Memo field. A text field is 255 bytes... tops; it cannot be
enlarged.

John W. Vinson[MVP]
 
Top