missing references?? in 2003 - worked in 2000

[PizMac]

I have some old code that has worked for years (up til 2000) but now gives me "invalid procedure call or argument" in 2003

Dim dbs As Database, rst As Recordset
I have tried DAO.Database/Recordset and still get the error

I have the same references as before including
Microsoft DAO 3.6 Object Libray at #3

Any ideas please?
Thanks
Judith

 

[mp9]

Make sure you DAO reference takes precende over any ADO reference (i.e. is listed above it in your list of references).

http://www22.brinkster.com/accessory/

 

[PizMac]

I have
Visual Basic for Applications
Microsoft Access 11.0 Object Library
Microsoft DAO 3.6 Object Library

and the first 2 can't be moved (the arrows are dimmed) so I can't move it any higher.....

 

[PHV]

Which line of code is highlighted when in debug mode ?
Does the DB compiles properly ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PizMac]

dbs as recordset" is the code highlighted and it doesn't compile - the message in question is given at compile time.....

 

[PHV]

And this ?
Dim dbs As Database
Dim rst As DAO.Recordset

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PizMac]

sorry no - thanks for trying but - the error comes on
Dim dbs As Database
with "dbs As Database" highlighted

 

[PHV]

"invalid procedure call or argument"
with "dbs As Database" highlighted
You confirm the above ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PizMac]

yes

 

[PHV]

Could you please post the lines above and below the highlighted one ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PizMac]

as of this morning it works- no idea why! - haven't changed anything, but a reboot seems to have sorted out Access - Ah well....... Thanks for your time

 

[PizMac]

I've just realised - I removed an OLE library reference and that must have cleared the problem! - though why - who knows!