Need help please.. DAO To ADO Code

[marvin67]

Hi,

I'm trying to convert this code on my access database. This is a mapping code that transfer fields info to another table using a map table.

I'm getting a runtime error 3265 when executing the code that points to the fields on the map as below

Do Until rstMap.EOF
rstOrd(rstMap!targetfieldname) = rstCust(rstMap!sourcefieldname)
rstMap.MoveNext

It's run fine on DAO. I'm no expert in programming. I've learned simple coding through experience.

Please help.

Thanks

 

[boblarson]

If is has run fine on DAO, why are you changing to ADO?

 

[marvin67]

Because I am trying to move my tables to mysql server. My understanding is DAO won't work on server environment. So i have to recode my dao to ado before going to the server route.

 

[Banana]

That's not true. I've developed an application with MySQL using DAO.

My belief is that it's good sense to use linked table/DAO for most of cases where you want simple table binding to the form, and use ADO where we require an interface that's more complex and either not easily expressed in DAO or requires stored routines while keeping the form fully updatable. So I actually mix DAO and ADO as the needs dictate.

 

[boblarson]

That's not true. I've developed an application with MySQL using DAO.

My belief is that it's good sense to use linked table/DAO for most of cases where you want simple table binding to the form, and use ADO where we require an interface that's more complex and either not easily expressed in DAO or requires stored routines while keeping the form fully updatable. So I actually mix DAO and ADO as the needs dictate.

Good statement of what I was thinking as well.

 

[marvin67]

Thanks for enligthening me on this one. I have exported my tables in mysql and link the tables to my front end, but this code didn't work. I think it is something to do with adding record in the table if it has an autonumber field on it.

I will try to run again the code and check what is the error code. I am not at work at the moment. i'll post the error tomorrow.

Cheers