I have created a form based on a shared ms access database. When I try to run a query on another computer using this form I get :

Please enter MSJET ole db initialization information - it then asks for a password and eventually gives me the message 'cannot connect to datasource'.

I have seen this problem asked about previously but so far no answers.