Re: Error 3265 mystery error

will f wrote:
The environment is VB6.

I'm not using ADOX in the app. I just created an ADOX Catalog object
as part of my debugging to see if ADOX would see the table.

I did check the database window in MS Access, and the table is there.

I'll check out the link you sent me regarding Jet Delayed-Write --
I'm not familiar with it.


It's not relevant. It might have been relevant if this was a dynamically
created table.

I'm more inclined to go with the "reserved keyword" theory: check your
field names against the list of reserved words in that link I cited.

If it's not a reserved keyword issue, then try exporting your table to
another database and see if it can be opened in the test database. If it
can, then we have a "corrupt database" issue. If not, send me the test
database via email and I'll see if i can reproduce your error.


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: creating a database subset in vba
    ... There is no way in ADOX to do things like setting the DisplayControl of the ... That's why I say you have to use both ADOX and DAO ... in my database copy have the columns rearranged. ... stripped out blank template in far less time than I have already spent ...
    (microsoft.public.access.modulesdaovba)
  • Re: Error 3265 mystery error
    ... I'm not using ADOX in the app. ... I did check the database window in MS Access, ... Have you dynamically created tblTest (you mentioning of ADOX in your OP ... "tblTest" to some other table in the database, it opens fine. ...
    (microsoft.public.data.ado)
  • Re: creating a database subset in vba
    ... I did spend some time playing with ADOX to copy the structure ... in my database copy have the columns rearranged. ... stripped out blank template in far less time than I have already spent ... all the proerties right with just DDL, so copying the file will be much ...
    (microsoft.public.access.modulesdaovba)
  • Re: refreshing linked tables: NO DAO
    ... we use ADOX to relink password database at a specific location. ... setting property for password "Jet OLEDB:Link Provider String". ... Dim objFECatalog As ADOX.Catalog ...
    (microsoft.public.access.modulesdaovba)
  • Re: Linking tables via ADO?
    ... Properties for user-level security on an ADOX Table object, ... syntax that works just fine for an ADO Connection object, ... to connect to an Access database with ADO after it has been secured with ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.tablesdbdesign)