Jump to content
Sign in to follow this  
olona

catastrophic failure i access ved kjøring av query

Recommended Posts

I got a problem with my access database. I'm using the code as below in a access function.

 

Heisann.

 

har et problem med min access database. Jeg bruker følgende kode for å kjøre en spørring.

 

Dim rst As ADODB.Recordset
Set rst = New ADODB.Recordset
strSQL = "select * from tbl1 where fldDate between #08/22/2005# and #08/28/2005#" 
rst.Open strSQL, CurrentProject.Connection, adOpenStatic

 

Problemet er at ved start av siste linje, så går access in i en "catastrophic failure". Det rare er at ved kjøring på andre maskiner så går dette smertefritt...

 

NOen som har vært borti det samme.

Share this post


Link to post

Jeppers.

 

Som jeg tenkte var det noe med versjonen jeg brukte. Etter å ha installert MDAC 2.8 SP1 så fungerte det fett som fjell!

 

:w00t:

 

O.

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...