suddenly get empty fields

[nickname]

Hello

I made an application in VB6-MS Access and it works great.. till today..

suddenly I dont see any data

Till a few weeks ago, when I last used the application, everithing woked fine.. And now, if I open a record, the txt's just keeps empty in stead of filling them with the data...

To logon in the application the username from the PC is compared with the database, so the connection works fine..

really strange, on other PC's it works fine, and on mine it doesn't..

Does it has to do somethig with the fact that I'm developing in Access AND MySQL...

tnx in advance

nickname

[RhinoBull]

You'd have to be much more specific about HOW you do things and perhaps present some code.

[dglienna]

Have you changed anything on the PC?

[nickname]

I dont think posting code would help.. The code works fine on all other PC's..

The program is 6 months old, and worked fine on mine too, till now..

on the line "txt.Text = rs!field" it just doesn't fill the txt..

greetz

nickname

[dglienna]

It's pretty hard to do anything but guess unless you tell us what is different, or post some code so that we can see what you are doing. It could be something as simple as a password being wrong, to an update messing things up. If it happened to you, though, it probably happened to one of us here. Thats why we share information.

Can you open the db in Access? (or MySQL ?)

[erickwidya]

"txt.Text = rs!field"

have u check the value of field in related table? i guess it have null value..
don't know from where it comes if u certain not from prog then it could be other try to add manually and forgot to enter the value..

if u wish to do it whether it have null value or not..try this line

txt.text = rs!field & vbnullstring

The code works fine on all other PC's..

like dglienna question..have the pc is changed since last the program work well?

Does it has to do somethig with the fact that I'm developing in Access AND MySQL...

never try it before..but if after u installed it and get the error..it could be the reason..

[carlovfrimily]

Mayb u can post ur coding here,else the analysis is quite wide for this problems...many things can happen to it.

[nickname]

The only thing I changed (that I know of) is the install of MySQL drivers, for all my other programs.. Those programs works fine..

No, I have installes the MDAC again, I thought it would help, but it didn't..
Also an aother program with MS Access works fine, its just that one program that suddenly wont work (empty fields)..

Here is the code how I fill the datagrid (by clicking on a calandar)

strSqlSch = "select * from tblSchepenzaal where dag = '" & strKeuzeDatum & "' order by begin"
adoSch.CommandType = adCmdText
adoSch.RecordSource = strSqlSch
adoSch.Refresh

When I look into the database, the fields are filled! That is fore sure

This code works fine on all PC's, but not on mine, the one I develop on..

[dglienna]

I wonder if MySql took over the associations of Access files? Maybe not mdb's but something else that is required. Sounds like Access is not being used for the query. Maybe you could re-install Access (or repair)?

[nickname]

I wonder if MySql took over the associations of Access files? Maybe not mdb's but something else that is required. Sounds like Access is not being used for the query. Maybe you could re-install Access (or repair)?

This option has been checked.. And... other programs on Acces work fine..

strange, but I keep on searching..

nickname