346) 2/26/2002 Q285353Q285353  Q285353.html">ACC2002: How to Find a Record from a Drop-down List in a Data Access Page (Q285353)
This article shows you how to find a record in a data access page based on an entry that you select from a drop-down list.

347) 2/26/2002 Q283849Q283849  Q283849.html">ACC2002: How to Troubleshoot and Repair a Damaged Access 2002 Database (Q283849)
There are several things that can happen, both inside and outside of Access, that may leave your database file damaged (corrupted). The symptoms of a corrupted database can range from #Deleted appearing in certain records, to you being unable to open

348) 3/22/2002 Q304181Q304181  Q304181.html">ACC2002: Unexpected Write Conflict Error When You Close a Form (Q304181)
When you edit data that uses multiple forms that have the same record source, you may receive the following error message: This record has been changed by another user since you started editing it. If you save the record, you will overwrite the

349) 3/22/2002 Q305542Q305542  Q305542.html">ACC2002: Understanding the Role of Workgroup Information Files in Access Security (Q305542)
This article explains the role and relationship of the workgroup information file in Microsoft Access security.

350) 3/22/2002 Q304418Q304418  Q304418.html">ACC2002: How to Programmatically Create an AutoNumber Field and Set Its NewValues Property to Random (Q304418)
This article demonstrates how to programmatically create an AutoNumber field in a Microsoft Access table and set this field's New Values property to Random .

351) 3/12/2002 Q304408Q304408  Q304408.html">ACC2002: How to Shut Down a Custom Access Application Remotely (Q304408)
Sometimes, you may have to perform maintenance tasks on a Microsoft Access database, such as compacting or repairing, making backup copies, or making design modifications. Many of these operations require that all users exit the database. H

352) 2/28/2002 Q308312Q308312  Q308312.html">ACC2002: How to Use Application Roles with Access Projects and SQL Server 2000 Desktop Edition (Q308312)
This article explains the capabilities, the limitations, and the workarounds for using Microsoft SQL Server Application roles in a Microsoft Access project (ADP).

353) 2/28/2002 Q289533Q289533  Q289533.html">ACC2002: Where to Find Information About Designing a Database in Access (Q289533)
If you decide to store the data for your solution in an Access database or in another relational database, designing the database structure is likely to be the most challenging part of building the solution. Although it is fairly easy to mo

354) 2/26/2002 Q286828Q286828  Q286828.html">ACC2002: Implementing Query By Form in an Access Project (Q286828)
This article shows you how to use a Microsoft Access form to specify the query criteria in an Access 2002 project.

355) 2/26/2002 Q285822Q285822  Q285822.html">ACC2002: How to Determine Who Is Logged onto a Database by Using Microsoft Jet UserRoster (Q285822)
This article shows you how to use Microsoft Visual Basic for Applications to output a list of users who are logged onto a database.

356) 2/26/2002 Q285866Q285866  Q285866.html">ACC2002: DLookup() Usage, Examples, and Troubleshooting (Q285866)
This article shows you how to use the DLookup() function, and includes examples and tips. The following topics are addressed in this article: The DLookup() function syntax and usage. The following DLookup() function

357) 2/26/2002 Q286153Q286153  Q286153.html">ACC2002: Error Message: There Isn't Enough Disk Space or Memory (Q286153)
When you perform an operation on a table, you may receive the following error message if the operation creates a large number of page locks: There isn't enough disk space or memory. There isn't enough disk space or memory. If you run an

358) 2/26/2002 Q286238Q286238  Q286238.html">ACC2002: Sample Expressions to Extract Portion of Text a String (Q286238)
This article lists sample expressions that you can use to extract a portion of a text string. These expressions are commonly used in the Update To line of an update query to place a portion of a larger field into a new field. You can adapt these

359) 2/26/2002 Q283874Q283874  Q283874.html">ACC2002: How to FIND a Record Using ADO and Jet OLE DB Provider (Q283874)
This article demonstrates how to use ActiveX Data Objects (ADO) and OLE DB to find records in a Microsoft Jet database .

360) 2/26/2002 Q285329Q285329  Q285329.html">ACC2002: Access Does Not Import Attribute-Centric XML (Q285329)
When you import an XML document, at least one blank table is imported or not all of the data is imported. Depending on the structure of the XML document, more than one table may actually be imported.