Access 2003 db (a form having some back code) doesn't work under 2007

L

LevT

Hi Allen, thanks for your anwser.

There are no broken references. The checked ones are:

VBA
Access 12.0 Object Lib
ADO 2.1
OLE Automation


Is it right? Sometimes ago I've been programming acceess (97 and 2000), as I
remember there should be DAO not ADO..
 
A

Allen Browne

DAO is commonly needed, but it depends on what code you have.

Also, you may not need ADO and OLE Automation, depending on what code you
are using.

Choose Compile on the Debug menu (in the code window) to verify it all
compiles okay.

Hopefully the trust center settings got your code going.
 
L

LevT

The compilation is OK even if there are only two references :) the trust
settings I've set up correctly

My form does not show any data; having "Break on all errors" I get Run-time
error 2105 (localized message means like "can't go to given record") on this
line: DoCmd.GoToRecord , , acNext
 
A

Allen Browne

Okay, so the code is running then.

Naturally enough you can't go the the next record when there are no records,
so the error makes sense.

If you think the form should have records, you will need to track down
what's going on in its RecordSource. Trace it back.
 
L

LevT

That was a problem with form's data source. Old setting - localized
"customers" (table's name) didn't works. Changed it to "SELECT çàêàç÷èê.*
FROM çàêàç÷èê;" and it helps for me.
 
Top