Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 29th, 2003, 02:57 PM
Authorized User
Join Date: Aug 2003
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default error 7866 when using automation

I am trying to populate a menu with report names from an access database by using an instance of Access in a VB6 app and iterating the allreports collection like so -
' Transfer the contents of the AllReports collection to Reports
   strProgress = "iterate the AllReports collection"
   For Each objReport In objAccess.CurrentProject.AllReports
      ReDim Preserve arrReports(i)
      arrReports(i) = objReport.name
      i = i + 1
   Next objReport
End If
This is performed as a class method, on some machines I am getting an error 7866 (Non- existent database) although the database is where it should be and the permissions are set correctly, has anybody any thoughts

Similar Threads
Thread Thread Starter Forum Replies Last Post
Automation Error nagarajan123 Access 0 April 30th, 2008 09:22 AM
Automation Error in Activex Exe jawu VB Components 2 June 14th, 2005 04:40 AM
Outlook Automation Error www2004 Pro VB 6 4 August 12th, 2004 09:09 AM
Automation Error 430 Pls Help sumanmukherjee VB Components 0 September 5th, 2003 01:21 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.