Re: Limitation of 255 fields
From: Tom Lake (tlake_at_twcny.rr.com)
Date: 11/05/04
- Next message: Van T. Dinh: "Re: Query not working in code"
- Previous message: nir020: "Search Engine"
- In reply to: SANJAY SHAH \(MICROBRAIN Computers Pvt. Ltd.\): "Limitation of 255 fields"
- Next in thread: Duane Hookom: "Re: Limitation of 255 fields"
- Reply: Duane Hookom: "Re: Limitation of 255 fields"
- Reply: at: "Re: Limitation of 255 fields"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 5 Nov 2004 07:33:08 -0500
"SANJAY SHAH (MICROBRAIN Computers Pvt. Ltd.)" <microbrain@hathway.com>
wrote in message news:uG%23IqONwEHA.3872@TK2MSFTNGP11.phx.gbl...
> Dear Sir,
>
> In Access 2000, it is having limitation of 255 fields in Table & in
> Recordset. But In database like Clipper 5 it was having facility to 1024
> fields.
>
> If I want more than 255 fields in one recordset generated using query then
> how I can do using Access 2000.
>
> Sanjay Shah
Create tables with a one to one relationship for the overflow. I had a
survey with 300 questions on it and
that's what I did. One table had a user ID and the first 150 questions.
The second table had the user ID
and the last 150 questions and the tables were linked with a one to one
relationship. It worked OK.
Tom Lake
- Next message: Van T. Dinh: "Re: Query not working in code"
- Previous message: nir020: "Search Engine"
- In reply to: SANJAY SHAH \(MICROBRAIN Computers Pvt. Ltd.\): "Limitation of 255 fields"
- Next in thread: Duane Hookom: "Re: Limitation of 255 fields"
- Reply: Duane Hookom: "Re: Limitation of 255 fields"
- Reply: at: "Re: Limitation of 255 fields"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
