ADODB vs. ADOX

From: Mike Mertes (mike.mertes_at_resservices.com)
Date: 01/27/05 

Date: Thu, 27 Jan 2005 10:04:54 -0500

Platform: I'm writing ADO for MSAccess using VBA behind MSExcel.

I read that creating tables in a database is most easily accomplished using
ADOX.Catalog and ADOX.Table's properties and methods. Fine, that's easy.
However, I have already been using the ADODB.Connection object to return
record sets from the same database.

Can I set the ADOX.Catalog object to point to the ADODB.Connection that I
have already established? I'd rather not have to open two connections to the
same database if I don't have to. Nor would I like to rewrite my code for
ADOX...

Any help or suggestions you can offer would be appreciated. Thanks everyone. 

-- 
-Mike Mertes
Airtron, Tampa Bay

Relevant Pages

  • Re: Possible Project Bug: All Projects in Database are Deleted upon Save
    ... best practices and Project VBA ... > Only Project1 is saved into the database. ... >> prompts with Append or overwrite message. ... >> For Microsoft Project companion projects, ...
    (microsoft.public.project.vba)
  • Re: What happens when data in control is updated
    ... When I developed my concept database file I tended to look at what ... changes expected appearing on the form itself) and not going through the VBA ... > if the primary key field is Text data type, rather than numeric, the ... >>> make sure that a requery is necessary to achieve whatever your aim is. ...
    (microsoft.public.access.formscoding)
  • Re: Forms not saving
    ... I must have had some VBA code attached to these forms somewhere along the way ... Make sure the folder where your database reside is added to the trusted ... Office Button | Access Options | Trust Center | Trust Center Settings ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.forms)
  • RE: "Module" option does not show up when setting permissions.
    ... It's by design. ... Access 2000 introduced the separate VBA ... Project for handling the code (notice the separate code window (VB Editor) ... an MDE database file out of it if you want to hide the source code from ...
    (microsoft.public.access.security)
  • Re: Problem with a template from the MS Office website
    ... noted and have resolve them and reposted them the updated db to our web. ... database. ... I suspect it will be ages before my Access and VBA ... and controls so that the Invoice Report ...
    (microsoft.public.access.reports)