Ok, got it. I switched from using DSN to a connectionstring with full path and it works fine now. For some reason the DSN wasn't keeping the path or something.

>A note:
>In DSN or connecstring is save full path to mdb file.
>
>MartinJ
>
>
>>I created a connection in my DBC for it. I even tried moving it to the same directory as my DBC and it still keeps asking me where it's at. I'll try a connection string and see if that works better.
>>
>>Randy
>>
>>
>>>How is you connectring?
>>>You use DSN or driver?
>>>Is define MDB file in DSN?
>>>
>>>MartinJ
>>>
>>>
>>>>I'm trying to create a view to a mdb file. The view gets created fine but every time I right click on view to modify, browse, etc. a dialog comes up and asks me for the mdb file. I don't normally create views on Access database so I was just wondering about this.