Data Access Page Error

[brduran]

I'm knew to Access 2000/2002. I like the idea of being
able to access a database from a remote location. So to
start off I'm experimenting with a 'Data Access Page'
based on a 'Form' that in order was created based
on 'Tables'.

The problem is that I'm stuck on an error message that
doesn't go away nomatter what I do. It says 'Data
provider could not be initialized' and continues 'The
Microsoft Jet database engine cannot open the
file "name". It is already open exclusively by another
user, or you need permission to view its data.'

It happens even when the database is not open on the
server, so if is not open at all, why the exclusively...
As to setting permissions, I fooled around with
permissions under Tools/Options/Tables or Queries, but
nothing...

Any ideas please?

 

[marty]

Don't know if this will work or not but it's worked for me
in the past. Click TOOLS > MACRO > Visual Basic Editor.
Right click on the Modules object select ODBC Properties
(you may have to know the password). That will bring up
an ODBC Properties dialog box. Click the Protection tab.
10 to 1 says the "Lock Project For Viewing " is checked.
Uncheck it, click OK, then try the Data Access Page.

Marty