As I was mucking through support documents at Microsoft, I came accross some<BR>articles dealing with Access databases linked accross a network. The<BR>solution to solve some of these other problems also solved my "Optional<BR>Feature Not Implemented" error when trying to establish an ADODB connection <BR>to an SQLBase database.<BR><BR>The solution..<BR><BR>1. Use 3.5 or better ODBC Drivers for SQLBase (supporting threads)<BR>2. Open the Microsoft Management Console<BR>3. Edit the Properties page of the application<BR>3. Under the Directory Security tab, Edit "Anonymous Access and<BR>Authentication Control."<BR>4. Edit the "Account used for Anonymous Access:"<BR>5. Clear the "Enable Automatic Password Synchronizaton" check box.<BR>6. Run your ASP.<BR><BR>Here is my code snippet..<BR><BR>Dim objConn<BR>Dim CmdSimpleSelect<BR>Dim MySQL<BR>Dim MyString<BR><BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR>Set CmdSimpleSelect = Server.CreateObject("ADODB.Recordset")<BR>objConn. Open "DSN=ADP;DB=PAY4WIN;SRVR=SERVER1;UID=sysadmin;PWD= OMITTED"<BR>MYSQL = "SELECT * FROM REPORTS.V_EMPLOYEE"<BR>CmdSimpleSelect.Open MYSQL, objConn, adOpenStatic, adLockReadOnly<BR>Do while Not CmdSimpleSelect.EOF<BR> MyString = CmdSimpleSelect.Fields("FIRSTNAME") & " " &<BR> CmdSimpleSelect.Fields("LASTNAME") & "<BR>"<BR> Response.Write MyString<BR> CmdSimpleSelect.MoveNext<BR>Loop<BR>CmdSimpleSelec t.Close<BR>Set CmdSimpleSelect = Nothing<BR>objConn.Close<BR>Set objConn = Nothing<BR><BR>Here was the article..<BR><BR>PSS ID Number: Q189408<BR>Article last modified on 02-22-2000<BR>WINDOWS:2.5,3.5; winnt:4.0,5.0<BR>WINDOWS winnt<BR>========================================= =============================<BR>----------------------------------------------------------------------------<BR>---<BR>The information in this article applies to:<BR>- Active Server Pages<BR>- Microsoft ODBC Driver for Access, version 3.5<BR>- Microsoft Internet Information Server versions 4.0, 5.0<BR>- Microsoft Data Access Components version 2.5<BR>----------------------------------------------------------------------------<BR>---<BR>SYMPTOMS<BR>========<BR>Failures occur when Active Server Pages (ASP) code accesses a file-based<BR>resource over the network. Examples would include the following:<BR><BR>- Using the Scripting.FileSystemObject to access a file stored on a network<BR>share. Here is the resulting error message:<BR>Server object error &#039ASP 0177:800a0046&#039<BR>Server.CreateObject Failed...The operation completed successfully.<BR><BR>- Accessing a local Microsoft Access database linked to a table where the<BR>table linked to is in an Access database on a network server. Here is the<BR>resulting error message:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039<BR>[Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet<BR><BR>Database engine cannot open the file &#039******&#039. It is already opened<BR>exclusively by another user, or you need permission to view its data.<BR><BR>CAUSE<BR>=====<BR><BR>This behavior occurs when password synchronization is enabled for the IIS<BR>4.0 application. In situations where Access is linked to Access tables across the network,<BR>this is caused by a combination of password synchronization being enabled and a bug<BR>in the Odbcjt32.dll version 3.51.1029.<BR><BR>RESOLUTION<BR>==========<BR><BR> Disable password synchronization for the Internet Information Server 4.0<BR>application. Use the following steps to disable password synchronization:<BR><BR>1. Open the MMC.<BR>2. Edit the Properties page of the application.<BR>3. Under the Directory Security tab, Edit "Anonymous Access and<BR>Authentication Control."<BR>4. Edit the "Account used for Anonymous Access:"<BR>5. Clear the "Enable Automatic Password Synchronization" check box.<BR>In situations where Access is linked to Access tables across the network,<BR>disable password synchronization, see the following article in the Microsoft<BR>Knowledge<BR><BR>Base:<BR>Q180815 BUG: IIS 4 Fails When Using a UNC to Microsoft Access<BR>STATUS<BR>======<BR>This behavior is by design. The Anonymous logon performed when Password<BR>Synchronization is enabled is a non-interactive logon which improves the<BR>performance of Anonymous logons.<BR><BR>This problem does not occur with IIS 5.0/Windows 2000 because changes in the<BR>security architecture ensure that noninteractive logons do not fail on network<BR>access.<BR><BR>Additional query words:<BR>======================================== ==============================<BR>Keywords : kberrmsg kbADO kbASP kbWinOS2000fix kbSecurity kbWebServer<BR>kbGrpASP kbODBC350bug kbGrpMDAC kbDSupport kbMDAC250 kbiis400bug kbiis500fix<BR>kbFileSysObj kbGrpASPDB<BR><BR>Version : WINDOWS:2.5,3.5; winnt:4.0,5.0<BR>Platform : WINDOWS winnt<BR>Issue type : kbbug<BR>Solution Type : kbfix<BR>========================================= ===================================<BR>=<BR>Copyri ght Microsoft Corporation 2000.<BR><BR><BR><BR><BR><BR><BR>