Access Problem

[VBOfficer]

Dim ReadUsers As New OleDb.OleDbCommand("SELECT * FROM Emails WHERE GroupID = '" + MyID + "'", GroupConnection)
Dim MyReader2 As OleDbDataReader = ReadUsers.ExecuteReader
While MyReader2.Read
...
End While

Hello,

I have a critical problem in reading data from database!

But the above code reads all the fields, I wanna split it to 4 sections and if for example there are 1000 fields, I wanna read once the first 250 fields, next time 2nd 250 fields, next time 3rd 250 fields, next time last 250 fields, how can I apply this filter in SELECT command?

Can anyone help me plz? :confused:

[PlausiblyDamp]

The Emails table has a 1000 columns? Other than listing the 250 columns in one query and then the next 250 in another I can't think of an easy way.

 

Personally I would avoid SELECT * anyway, but then again I would tend to avoid tables with a 1000 columns as well.

 

In all honesty it might be easier if you could split the table into multiple tables with each table containing related bits of information. Out of interest what are these columns generall used for?