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.

I don't know Access programming, maybe you need to create an ODBC data source first. It's a common solution when you access a database on another computer or with another language. For example: I can create a data source for an Access file and access it with Java.

To create a data source, select "Control Panel || Administrative Tools || Data Sources (ODBC)".

hurricane is on the right track i think.

Might i suggest however that you use mySQL for databases.. its much better than Access