Table missing is ADOX that actually exists

Tech-Archive recommends: Speed Up your PC by fixing your registry

I'm having a strange problem looping through toe ADOX.catalog object. I'm
looking for a series of tables whcich I'm copying from another database. I
refresh the catalog by deleteing the object as recreating it after copying
the tables (which I've noticed is necessary). Six of the seven tables show
up fine. The seventh doesn't isn't in the Tables collection (it's actually #
5 in the sequece of seven). The table DOES exists, and WAS copied
successfully. I verified this when the debugger breaks by checking the
tables.

Anybody experienced this?

Details: It's a linked databse using a direct (non_ODBC) connection, actually
connecting to the databse I'm running it from, but that's posed no problems
(except having to close the editor before running it to avoid a lockout).

Any help appreciated! Thanks!
.

Relevant Pages

  • Re: Table missing is ADOX that actually exists
    ... looking for a series of tables whcich I'm copying from another database. ... It's a linked databse using a direct connection, ...
    (microsoft.public.access.formscoding)
  • Re: Network Question on Cluster - Windows 2003 Enterprise R2 server
    ... are you opening the SMB connection using NetBIOS or DNS name resolution? ... I tried a copying data from one node to another server, which both servers should use the public network connection but this does not happen. ...
    (microsoft.public.windows.server.clustering)
  • Re: Help needed!
    ... the WinXP Dial Up Connection thingy has the facility ... I always suggest Copying & Pasting things like that, ... It might be an idea to Copy & Paste the Info - Server Names, ... Cos you already have your NTL Account Set up (on the NTL Servers ...
    (uk.people.silversurfers)
  • Multiple question sets
    ... I want VBA code for copying 5 questions from each file & paste it in new ... I tried to record but could not succeed as one question is lengthy to fit ... Option1 - Connection within a building. ...
    (microsoft.public.word.vba.general)