http://www.windowsitpro.com/authors/author/author/5777283/rsscomment/5777283en-USSun, 27 May 2012 07:13:55 GMTSun, 27 May 2012 07:13:55 GMThttp://www.windowsitpro.com/article/internet/use-microsoft-access-97-and-peer-web-services-to-create-searchable-databases#commentsAnchorTue, 10 Aug 1999 14:29:50 GMT
Thanks to Simon Hook’s December 1997 article, “Use Microsoft Access 97 and Peer Web Services to Create Searchable Databases,” we can use wild card searches from anywhere in the plant to query our Access database. The article’s instructions were clear and concise, opening a new range of possibilities for our intranet. Thanks again for the help.
--Mike Mahan]]>Mike Mahan Tue, 10 Aug 1999 14:29:50 GMThttp://www.windowsitpro.com/article/internet/use-microsoft-access-97-and-peer-web-services-to-create-searchable-databases#commentsAnchorhttp://www.windowsitpro.com/article/internet/use-microsoft-access-97-and-peer-web-services-to-create-searchable-databases#commentsAnchorTue, 10 Aug 1999 13:18:23 GMT
Simon Hook’s December 1997 article, “Use Microsoft Access 97 and Peer Web Services to Create Searchable Databases,” couldn’t have been more timely. I got the example to work, but I have questions. I’m running Windows NT 4.0 Workstation on an NT 4.0 Server-based network and want to use the NT Workstation as a Web server for my small department intranet. The workstation has Peer Web Services (PWS) running with Service Pack 3 (SP3) per the article. Hook does not specify where to put the dmc.mdb file. If I put it in the C:\inetpub\scripts directory on the workstation where the YearQuery_1.xxx files are, I can get everything to work exactly the way the article showed. However, I’d rather have the dmc.mdb file on our network server, which gets backed up more frequently. If I set the dmc.mdb database in a directory on the network server and reestablish the Open Database Connectivity (ODBC) requirement to point to that file and run the example, I get the following error: >[State=S1000][Error=-1032] [Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet database engine cannot open the file ‘(unknown)’. It is already opened exclusively by another user, or you need permission to view its data. I checked permissions on the dmc.mdb file on the server, and I should have access to it. The file is not open. I get the same error when I log on as a domain administrator. Any ideas?
--Chuck Lob

Try this fix. On the server, place the file in a shared directory that you can access from the workstation. On the domain, create an account with access to the file on the server and to the workstation. Replace the account that Peer Web Services uses with the domain account. Create a new datasource that points to the file on the server. Specify the location to the database as \\machinenamesharename\etc. If you don’t follow this step, you need a permanent connection to the shared drive as a network drive. By the way, this fix works only if you haven’t installed the NT 4.0 Option Pack. (For an overview of the Option Pack, see Ken Spencer, “The NT 4.0 Option Pack,” January 1998.) If anyone knows a solution with the Option Pack installed, send it our way.
--Simon Hook]]>Chuck Lob Tue, 10 Aug 1999 13:18:23 GMThttp://www.windowsitpro.com/article/internet/use-microsoft-access-97-and-peer-web-services-to-create-searchable-databases#commentsAnchor