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

[LevT]

Where should I read about how to start fixing it?

TIA

 

[Allen Browne]

First thing would be to ensure the folder where the database is is a trusted
folder. Add it under:
Office Button | Access Options | Trust Center | Trust Center Settings

You may also need to check references:
http://allenbrowne.com/ser-38.html

 

[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..

 

[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.

 

[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

 

[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.

 

[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.