Please Help Me With Access 2002 DB Problem if you can

Message Bookmarked

Bookmark Removed

Hi guys!

Need help. Foolishly we're using an access DB and one record is corrupt and now it buggers everything up (attempts to repair database would crash Access).

Fuck.

I'm attempting to resolve this by using VBA to pull out the records one at a time, to figure out which line is broken and skip it somehow if possible.

But to my horror it seems that all the stuff I knew for Access 97 are now different (all the DAO stuff now replaced with some crazy ass ADODB.omg.wtf stuff). All I want is to open the current db as a recordset and just scroll through.

Can anyone here help?

Ken

― ken c (ken c), Tuesday, 3 May 2005 09:36 (twenty years ago)

oh i did that thing where i signed off with my name like an email again.

― ken c (ken c), Tuesday, 3 May 2005 09:36 (twenty years ago)

ok i've actually figured it out now.. and miraculously fixed this bithc.

i feel like a fucking genius.

― ken c (ken c), Tuesday, 3 May 2005 11:46 (twenty years ago)

this thread has been really good for me to focus my thoughts.. i'm going to use this more often whenever i get into a dilemma.

― ken c (ken c), Tuesday, 3 May 2005 15:46 (twenty years ago)

You must be logged in to post. Please either login here, or if you are not registered, you may register here.