Assuming you are running AK2 in the modules you need a reference to the
Microsoft DAO 3.6 Object Library
So open any VB module
Goto Tools->References and select the Microsoft DAO 3.6 Object Library
Phil
"Bj?rn Keil" <abgrund@silberdrache.net> wrote in message
news:e8ef0c96.0311210655.79a6192e@posting.google.c om...[color=blue]
> Hi,
> first of all I have to say I'am new to MS Access, I'm used to database
> systems like Oracle or MySQL.
> I created a simple database consisting of a single table and a form to
> fill in new entrys and search for existing entrys. But the search
> function that Access generates as I created the proper button is way
> to simple, I need a function that enables to search in several
> columns.
> I saw a few quite simple examples where this was done by DAO, but this
> doesn't work with a .mdb database, does it? (Access allways replies
> 'Unknown user datatype' once it gets to the line: 'Dim db As
> Database')
> Now, is it possible to generate a new query for .mdb file from a form,
> or at least with CurrentData Object, or not?
> And if it is possible with the CurrentData Object is it still a
> database request then or would it be faster to search through a text
> file?
>
> Regards,
> Björn Keil[/color]
MS Access Database Query 
