>thanks but i got an error of couldn't find installable ISAM
>
>>>hi im using DAO
>>
>>Here it is:
>> 'Create a default workspace Object
>> Set mwspDefault = DBEngine.Workspaces(0)
>> 'Create a Database object
>> Set mdbMAJ = mwspDefault.OpenDatabase("C:\test.mdb", False, False, "MS Access;PWD=YourPasswordGoesHere")

Don't you use Access?

Try this instead:

Set mdbMAJ = mwspDefault.OpenDatabase("C:\test.mdb", False, False, "Access;PWD=YourPasswordGoesHere")