Re: Error 3265 mystery error

So that 3265 seems to be behaving as if I am referencing a field that does
not exist in the table. But, as you can see, I am not specifically
referrencing any fields at all.

But you are - indirectly that is.
If you do "SELECT * FROM tblTest", a meta-data lookup on tblTest has to
occur to find the fields that correspond to "*".

As far as the recordset being properly initiated, when I change "tblTest"
to
some other table in the database, it opens fine.

Also, I have run a database compact/repair on the database before doing
the
whole operation, so I don't think the db is corrupted - but I could be
wrong.

Any ideas?

Well yes. More information

1. Version of MDAC installed.
2. I would check to see what version of the Jet Provider you have installed
and make sure it is the latest - it no longer comes with MDAC. You need to
install seperately
3. Some checking on your Access databases. Is this one the same version as
the others?

To me, it looks like a database corruption issue or possibly configuration
issue.

Cheers

Stephen Howe



.

Relevant Pages

  • How to build a VAX/VMS emulator on Fedora Core 3 Linux
    ... make install the libpcap for ethernet support on VAX emulator ... Is the OpenVMS media ready to be mounted? ... * Do you want to install the MSGHLP database? ... Message from user AUDIT$SERVER on NEWBB ...
    (alt.os.linux.redhat)
  • Re: Need technique to programatically update back end structure / relationships
    ... Yes, that should work, Bob. ... Install the new one. ... > have the user rename the current production database (after taking a ... > final step of the installation process, I would ask the user to execute ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Error: Cannot find a valid Windows XP Embedded database installed
    ... Both the database and tools are Eval or Retail? ... Microsoft Windows XP Embedded Test Team ... Well, in fact it has a network connection, and it's working without any ... if I install everything in the same computer (tools and ...
    (microsoft.public.windowsxp.embedded)
  • Re: MDE-File
    ... A main database ... >> When I install the runtime-version, ... And they should be the same for mdb as mde, ... >> refresh the link and use dbHiddenObject to hidden IT. ...
    (microsoft.public.access.developers.toolkitode)
  • Re: User Rights Assignment - not available - Resolved
    ... Then copy the security file from the \windows\repair ... If none of that works I would try an upgrade/repair install ... shows user rights and use the Resource Kit command line tool NTrights to ... This operation may find that this database is corrupt ...
    (microsoft.public.windowsxp.security_admin)