Can open access file but.....

[twinlizards]

I am having alittle trouble, I can open my access program in VB6.0 but am having trouble seeing the work or data displayed, it is in grid format and can see the grid and each row or column's heading but no data!? How do I get my data from my access database file to this VB? How do get it to show me?

 

[CCLINT]

What is the grid's data source?

An ADO Data Control or a ADO recordset object variable?

If Data Control, the what property settings do you have for CommandType and RecordSource?

If ADO, then what is the SQL SELECT statement?

 

[twinlizards]

It is an ADO Data control....command type = adcommandtable

recordsource = characters

 

[twinlizards]

which would be the better grid data source, it gives me these options when i am using VB wizard to load in my database.

 

[CCLINT]

>and can see the grid and each row

Change the ForeColor of the grid to a non-system color.

 

[twinlizards]

I can see the grid and the headings on the colomns but not the info(?). When I use the wizard (VB) it shows the info as I am going through the steps to create, but when finished, nothing. Thats where I get stuck....

 

[twinlizards]

Ok, when I use my VB wizard to open the database that I want and am going through the steps of creating this form, I can see the information listed in my database when I am configuring the wizard. My image file data actually reads "?????Aa??", so I do see the information, but when complete it shows nothing but the grid and it's headers. If and when I create with form wizard what should I use, ADO data control or ADO recordset object variable? They give me a choice when using.

 

[CCLINT]

Use ADO recordset object variable

When you said: "and can see the grid and each row... but no data" What do you mean?

Each row as in a blank white row with row line seperators, or just a grid with headers and a grey back ground.

Also, what are the types of fields you are trying to retreive?
You say "...image file data ...". You mean pictures are stored in the database?

 

[twinlizards]

I can see each line and white backround with all the headers with the name of eah from my database. The database has text fields and image fields, i can alter the text fields but the problem is altering or placing in image files to get me this long binary data i am seeking.If I could see the field or info then I can alter, fix, insert whatever info I need, but for some reason I am not seeing my data