General Access FAQ 1

[elizabeth]

Following is a Table of Contents for FAQs on the Microsoft Site. If you've landed here as the result of a search, please check below to see if your answer is already answered at these locations.<br>
<br>
<b>Table of Contents for Access 2000 Frequently Asked Questions</b><br>
<A HREF="

http://support.microsoft.com/support/access/content/faq/faq2000.asp"

TARGET="_new">

http://support.microsoft.com/support/access/content/faq/faq2000.asp</A><br>

<br>
1. Why do I get the error, &quot;Microsoft Access can't open or convert this previous version<br>
database&quot;, when I try to convert a secured Access database?<br>
2. Why do I get the error, &quot;The Visual Basic for Applications project in the database is<br>
corrupt&quot;, when I try to convert my database to Access 2000?<br>
3. How do I install the Microsoft Data Engine (MSDE)?<br>
4. Why aren't the changes that I made to a custom toolbar saved?<br>
5. Why do I get the error, &quot;You do not have exclusive access to the database at this time&quot; or &quot; A link to this data access page could not be created because the database cannot be<br>
exclusively locked&quot;, when I try to save design changes.<br>
6. How do I migrate from Microsoft® Data Access Objects (DAO) to Microsoft ActiveX® Data Objects (ADO) or get information about using ADO with the OLE DB Provider for Microsoft Jet (Jet Provider).<br>
<br>
<b>Table of Contents for various Access 97, although some materal also relates to other versions:</b><br>
<A HREF="

http://support.microsoft.com/support/access/content/faq/faq97.asp"

TARGET="_new">

http://support.microsoft.com/support/access/content/faq/faq97.asp</A><br>

<br>
Setup and Conversion<br>
<br>
1. What are the hardware requirements for Microsoft Access 97?<br>
2. Can I install and run Microsoft Access 97 on the same computer as Microsoft Access for Windows 95 or an earlier version?<br>
3.I do not see any drivers for Paradox, Lotus 1-2-3, or Microsoft Exchange/Outlook™. How can I install them?<br>
4. Can Microsoft Access 97 open or convert databases created with earlier versions of<br>
Access?<br>
5. Can I run my Microsoft Access 97 database in an earlier version of Access?<br>
6. How do I convert 16-bit API calls to 32-bit API calls?<br>
7. How do I convert from the Data Outline control to the Treeview ActiveX control?<br>
<br>
Internet Features<br>
<br>
1. Can I publish my Microsoft Access 97 database to the World Wide Web?<br>
2. When I publish Access objects to the Web, which browser and server must I use to view and store the pages?<br>
3. How can I install ASP on my Web server?<br>
4. How can I verify that ASP is installed correctly on my Web server?<br>
5. What

http://WWW Directory

Access permissions are required to view HTML, IDC, or ASP files on my Web server?<br>
6. What permissions do I need on my Internet Information Server (IIS) to use Internet Database Connector (IDC) files or Active Server Page (ASP) files from a Access database?<br>
<br>
General Usage<br>
<br>
1. How should I design my database?<br>
2. How can I optimize queries to get the best performance?<br>
3. How can I create an expression to extract a portion of a text field?<br>
4. How do I store calculated values in a table?<br>
5. How can I delete duplicate records from a table?<br>
6. How do I update one table with information from another table?<br>
7. How can I calculate Date/Time data to display specific dates or elapsed time?<br>
8. How do I use a combo box or list box to find a record in a form?<br>
9. How do I use a multi-select list box to filter a form?<br>
10. How can I have a second combo box that lists certain items based upon what I select in the first combo box?<br>
11. How do I create a button on a form that will print the current record?<br>
12. How do I create a button on a form that will print the filtered records?<br>
13. How can I get the value of a field from the next or previous record?<br>
14. How do I sum a calculated control in a report?<br>
<br>
Interoperability<br>
<br>
1. How can I control Access from another application?<br>
2. How can I send the current record to a Microsoft Word document?<br>
3. How can I send the current record to a Microsoft Excel spreadsheet?<br>
4. How can I link to a Microsoft Outlook or Microsoft Exchange folder?<br>
5. How can I run Microsoft Outlook from Access?<br>
6. How can I add an appointment to Microsoft Outlook from Access?<br>
7. How can I add a task/reminder to Microsoft Outlook from Access?<br>
8. Which ODBC driver do I use, and where can I get it?<br>
9. How can I get the best performance when using Open Database Connectivity (ODBC) data sources with Access?<br>
10. How can I create an SQL pass-through query in code?<br>
<br>
Troubleshooting<br>
<br>
1. How can I resolve the &quot;This feature isn't installed&quot; or the &quot;Microsoft Access Can't 2. Find the Wizard..&quot; error message that I get when trying to use a wizard?<br>
2. I receive #Error? in a control when I run my form or report. What does this mean?<br>
3. Why is my calculated control blank?<br>
4. I am using the DLookup() function to look up a value in a table or query, but it is not<br>
5. working correctly. How can I troubleshoot this expression?<br>
6. How do I debug my Visual Basic for Applications code?<br>
<br>
Microsoft Office 97 Developer Edition (ODE)<br>
<br>
1. What is the Microsoft Office 97 Developer Edition (ODE)?<br>
2. What are the differences between the retail and run-time versions of Microsoft Access?<br>