I'm pretty new to Access but I just cannot figure this one out to be honest.

When I run a sample .mdb file that comes with access 2000 everything is fine. When I make my own .mdb file is when the problem starts.

I cannot using the following code within a form's module or anywhere for that matter.

Dim X as Database
Set X = currentDb()

This means I cannot use :

Set Y = X.OpenRecordset(.....)

For some reason the Database object doesn't exist - it keeps saying that it cannot find the user-defined object. When I try and use the Access Help a bizzar thing happens. I cannot access any information on Databases.

Have I a setting that is not working, am I doing something stupid or what is it ???

Any help would be seriously appreciated.

Search here for missing references, the topic comes up for discussion with regular monotony.

Cheers Rich - much appreciated - all working now. I was going a little mad to be honest.