Access 2003 is not compatible with Access 2000?

[franksirvent]

Hi

I have a database done in Access 2000
Although it runs ok with Access 2003, I get the following error:
"DLL Library Error"
it happens when it reaches the following code:
Set dbs = CurrentDb() <<<STOPS HERE WITH THE ERROR
SQLLINE = "SELECT [No de Facturas].Id, [No de Facturas].[No] FROM [No de Facturas];"

I am sure it must be some Reference which I need to tick, however I have ticked every reference I can think of and still doesn't work...

Any ideas what i need to do ?

thanks

 

[bubba100]

What references have you selected?

 

[Remou]

Have you referenced the Microsoft DAO x.x Library? Also, make sure the reference to this library is moved as far up the list of reference libraries as it will go. You should also say:
Dim dbs As DAO.Database

 

[franksirvent]

ok thanks for info

I will try later today your ideas and let you know

Thanks for your input and help!