After you've installed Gatsby Database Explorer you'll also need to update the permissions of the Gatsby registry key. Gatsby Database Explorer maintains configuration information in the LOCAL_MACHINE hive of the registry. Unlike prior versions of Windows, Windows 2000 configures the default permissions of the LOCAL_MACHINE hive of the registry to read-only. To update the permissions of the Gatsby registry key:
Run Regedt32.exe
Click the "Start" button on the Windows Task Bar. Select "Run". Enter "regedt32.exe" and click "OK".
Navigate to the Gatsby registry key
Select "HKEY_LOCAL_MACHINE on local machine" from the "Window" menu. Double-click "SOFTWARE". Click on "Gatsby" to select it.
Update Gatsby registry key permissions
Select "Permissions" from the "Security" menu. Click "Add". Double-click the account name that begins with "IUSR_" to select it. Click "OK". Check the "Allow" box in the "Full Control" column. Click "Apply". Repeat this process for the account name that begins with "IWAM_". Click "OK". Exit regedt32.exe.
Gatsby Database Explorer will keep Microsoft Access databases open on the Web server until your session times out. This time varies depending upon your Web server settings. You can close the session immediately by clicking the Exit button.
A Gatsby-friendly database is nothing more than a well designed relational database. One of the best resources we've found for learning about the fundamentals of relational database design is a book called Database Design for Mere Mortals by Michael J. Hernandez. You can find more information about Mr. Hernandez's book and other useful database design tips at: http://www.datatexcg.com.
Gatsby Database Explorer contains no known Y2K compliance issues. However, since Gatsby Database Explorer interacts with Microsoft Access databases, make sure you are using Access in a Y2K compliant fashion. For more details on Access Y2K compliance, please visit: http://www.microsoft.com/technet/year2k/product/user_view11257EN.htm
The error is occurring in the Microsoft Access Data Engine (Jet). The solution is to install an update to Jet that is available on the Microsoft Web site at:
Privacy
