Access VBA Statement (Access 2000 - Vb 6.0) "Dim MyDB As Database"

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Henry Jordan (HenryJordan_at_discussions.microsoft.com)
Date: 03/08/05 

Date: Tue, 8 Mar 2005 07:11:05 -0800

 I am trying to implement Article ID 31881 -How to use a record set to send
Outlook e-mail to multiple receipients in Microsoft Access.

I have copied the code suggested into a new module. However the compiler
does not like the first statement. (Access 2000, VB 6.0)

Dim MyDB As Database

The second statement is accepted!

Dim MyRS As Recordset

It looks like the "As Database" is not acceptable.

Can anyone help me as to what is incorrect in VB

Relevant Pages

  • Re: Access 2002 command line options.
    ... > database Opens the specified database. ... > /excl Opens the specified database for exclusive access. ... > /user user name Starts Microsoft Access using the specified user name. ... To compact to a different name, specify a target ...
    (microsoft.public.access.developers.toolkitode)
  • Re: Cant access code
    ... See http://www.QBuilt.com for all your database needs. ... See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. ... Create a new database file and import all objects except the corrupt form. ... If you have a recent backup, import this form from the backup and check ...
    (microsoft.public.access.modulesdaovba)
  • Re: Communication Log
    ... Tony Toews, Microsoft Access MVP ... May I send you copy of the database that I made? ... Dropdown box (I can select a value to store in the ... The above controls are set up in a page using te tab control. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Advice needed for a growing Access 2000 project
    ... However, it turned out that quite a few of those were "leftovers" from previous releases, no longer accessible from anywhere but the database window, and, thus, no longer used. ... But that certainly isn't the _norm_ -- without any 'heroic' measures, there are routine reports of split Access DBs ... Finally, in my opinion, for "Windows apps", that is, individual-user applications, modest-sized multiuser applications, and client-server applications of any size, Dot Net does NOT "help along" any of these issues. ... The post I reference was in reference its self to the MS Access Help file under "Microsoft Access database general specifications" ...
    (comp.databases.ms-access)
  • RE: error 3011-msaccess
    ... When you open a Microsoft Access version 1.x database in Microsoft Access ... following error message: ... The backquote character, which is ASCII ...
    (microsoft.public.access.gettingstarted)