31) 12/14/2003 163002163002  163002.html">HOWTO: Open an Access Database with User Security
(163002) - This article demonstrates how to open and view the contents of a secured Access database using Visual Basic. The steps below outline this process: Secure the database: From Microsoft Access, set the appropriate user and group permissions to secure the...

32) 12/13/2003 178880178880  178880.html">INFO: Identifying the Jet Database Engine Components
(178880) - DAO is a COM wrapper around the Jet Engine, which is used by Microsoft Access, Excel, Project, Visual Basic, and the Microsoft Foundation Classes (among others). It can be confusing which version of Jet you are using because so many applications may...

33) 12/12/2003 162851162851  162851.html">ACC97: "Couldn't find object" Error Checking Out Table/Query
(162851) - Advanced: Requires expert coding, interoperability, and multi-user skills. This article assumes that you are familiar with using the client side capabilities of Visual SourceSafe. For more information about Visual SourceSafe, please refer to the...

34) 1/30/2004 163653163653  163653.html">ACC97: Example Using the Internet Transfer ActiveX Control
(163653) - This article shows you two examples of how to use the Microsoft Internet Transfer ActiveX Control that is included with the Microsoft Office Developer Edition 97. This article assumes that you are familiar with Visual Basic for Applications and with...

35) 1/30/2004 162745162745  162745.html">ACC: How to Convert Julian Days to Dates in Access and Back
(162745) - This article shows you how to create a sample procedure that converts Julian days to dates in Microsoft Access, and a sample procedure that converts Microsoft Access dates to Julian days. You can change the Julian day format used in the examples to a...

36) 1/29/2004 195947195947  195947.html">ACC: Error Deleting OLE Object Field from Replicable Database
(195947) - In a replicable Microsoft Access database, if you try to delete an OLE Object field in the Design view of a table, you may see the following alert Couldn't find field 'Table1' followed by the message: Errors were encountered during the save operation.

37) 1/29/2004 163509163509  163509.html">ACC97: Object Description Property Not Saved in SourceSafe
(163509) - Advanced: Requires expert coding, interoperability, and multiuser skills. When you create a database from a Microsoft Visual SourceSafe project, the Description property of your database objects does not appear. This also happens when you perform a...

38) 1/21/2004 159325159325  159325.html">ACC97: Server and Browser Requirements for Publish to Web Wizard
(159325) - Microsoft Access 97 provides features that enable you to publish data from your database as Web pages. You can create both static and dynamic Web pages; however, each type of Web page may have different requirements for the server that stores the page...

39) 1/19/2004 167420167420  167420.html">ACC: Form Is Editable Even When AllowEdits Property Set to False
(167420) - When you open a Microsoft Access form that has the AllowEdits property set to No (False), you can still edit the fields on that form. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access...

40) 12/14/2003 182355182355  182355.html">PRB: Jet Text IISAM Truncates Trailing Spaces
(182355) - When importing delimited data from a text file into a Jet database, trailing spaces are dropped from fields.

41) 12/14/2003 182354182354  182354.html">PRB: Jet Text IISAM Driver Drops Leading Spaces
(182354) - When importing a delimited text file into a Jet database, leading spaces are truncated from field data.

42) 12/14/2003 171652171652  171652.html">HOWTO: Retrieve Individual Bytes from a Multi-Byte Type in VB
(171652) - This article demonstrates how to copy the individual bytes of data in a multi-byte data type, such as a long integer or a single-precision floating- point number, into a byte array. It also illustrates how to take an array of bytes and turn it into a...

43) 12/14/2003 173163173163  173163.html">ACC97: Transaction in ODBCDirect Workspace Causes Corrupted Index
(173163) - A Visual Basic for Applications procedure that uses ODBCDirect to create and populate a table in another Microsoft Access database also creates corrupted unique indexes in that table. This behavior occurs if the procedure performs the following steps...

44) 12/14/2003 252666252666  252666.html">ACC97: Inconsistent Results Are Returned from a Query That Is Based on Linked Visual FoxPro Tables
(252666) - Some queries that are based on one or more linked ODBC Microsoft Visual FoxPro tables may return inconsistent results each time that you run the queries. Examples of queries that might exhibit this behavior are queries that are based on one or more...

45) 12/12/2003 164238164238  164238.html">ACC97: Duplicate Relationships Multiply in Back-End Database
(164238) - Advanced: Requires expert coding, interoperability, and multi-user skills. You notice duplicate relationships appearing in a data (back-end) database under one or both of the following conditions: When you import tables into a new database, and the...