Re: Run-Time Error 3219

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Peter Hoyle (peter.hoyle_at_ntlworld-NOT.com)
Date: 03/16/04


Date: Tue, 16 Mar 2004 15:53:53 -0000


> I found a KB article 208379 on this error, but don't understand how I need
to change my code to fix it. I didn't have a problem until I split my
database. Below is the problem code. Can someone show me how to fix this?

> Set rs = db.OpenRecordset("tblPassword", dbOpenTable)

Looking at KB208379 it seems like the above line is causing the problem.

Try

Set rs = db.OpenRecordset("tblPassword")
Or
Set rs = db.OpenRecordset("tblPassword", dbOpenDynaset)

Cheers,
Peter

-- 
http://www.peterhoyle.co.uk/


Relevant Pages

  • Re: CursorAdapter, MySQL - View definition has been changed.
    ... I can fix the fixed length fields by casting the static text to a fixed ... In my MySQL database the Comment ... I am not sure what is causing this error. ... this error message? ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Renaming control breaks module ?
    ... This seems like the kind of problem that a decompile might fix. ... Office Button | Access Options | Current Database | Name AutoCorrect ... Compact the database to get rid of this junk: ... Uncheck any references you do not need. ...
    (microsoft.public.access.formscoding)
  • Re: Third party tool required
    ... How does this fix data corruption? ... wrote our own table header repair utility because they would ... > What's so hard about writing your own database rebuild utility. ... > In our app we call this utilty installDB. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Existing Database - Create new or Fix existing?
    ... If you have spent lots of time developing the app, ... fix the issues you can (such as ensuring all ... I downloaded the free 'database checker' utility from ... Do I trawl through the report page by page and try to fix the issues one ...
    (microsoft.public.access.queries)
  • Re: Existing Database - Create new or Fix existing?
    ... that's one way to learn about how to build a database. ... data - forms, subforms, combos, list boxes, reports, and so on. ... I built the app in 1997 and have been adding to it ever since. ... Can I fix it or should I leave it ...
    (microsoft.public.access.queries)