Re: Dim db As Database doesn't work

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks Paul,
That fixed it and it is running fine now. All I need to do now is figure
out how to copy a table (for backup) using VBA. But I'll do my homework
first before yelling help here. By the way, I cannot find any MS Access
specific discussion groups here. Others have suggested a newsgroup but my
company blocks access to all newsgroups. I only have access to
support.microsoft.com.
Regards,
Bill

"Paul Clement" wrote:

> On Wed, 29 Jun 2005 06:57:01 -0700, "Bill Howell" <BillHowell@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> ¤ Doug,
> ¤ I followed your steps and the Database type is now recognized but I get a
> ¤ "type mismatch" error on the following code**:
> ¤ Dim thisDB As Database
> ¤ Dim rsCtl As Recordset
> ¤ Set thisDB = CurrentDb
> ¤ Set rsCtl = thisDB.OpenRecordset("qryControlDate") **
> ¤ I don't remember DAO being this fussy. :-)
> ¤ Thanks again for your help.
> ¤ Bill
> ¤
>
> To avoid confusion with ADO (which also has a Recordset object), fully qualify the database object
> types:
>
> Dim thisDB As DAO.Database
> Dim rsCtl As DAO.Recordset
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)
>
.

Relevant Pages

  • Re: ado.net create a table
    ... The database is not in the virtual directory, ... iss accounts to the folder as well as the database. ... I would really appreciate any help paul.. ... > ¤ Full access is given for everyone to the folder and to the database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Copying access objects using .net
    ... Paul, ... I have 11 users for this app, ... The test database contains new queries that are used by new reports. ... > ¤ How do I program vb.net to copy a query or table from one MS Access database ...
    (microsoft.public.dotnet.framework)
  • Re: ado.net create a table
    ... The database design of an Access/Jet database can not be modified unless it ... > Paul Clement wrote in message ... >> ¤ Hi Paul, ... I looked into the link u gave me, which says impersonation would solve ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ado.net create a table
    ... Thanks Paul, ... everything to a new access database and it worked like a charm. ... if i have tested in some other database, ... >> ¤ I am still struggling to get the solution. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ado.net create a table
    ... I have not imposed any security to my access 2002 database. ... > ¤ Hi Paul, ...
    (microsoft.public.dotnet.framework.adonet)