470,843 Members | 1,962 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,843 developers. It's quick & easy.

Error 3021 - Please Help!

I'm working with Access 2000 Version 9.0. I closed a Database that i was working on and on opening it up again an Error Message displayed "No Current Record" the Help File displays the Error Code as 3021.

How do i open the Database and retrieve my Data? I have in the database about 3000 Entries of Peoples Details. It took about two months to enter all of it and now i can't access it. Please Help.

Oseyo Ephraims
Aug 14 '08 #1
4 2306
1,134 Expert 1GB
Oh Oh......

Are you able to open the database in design mode?

If not, this may or may not work but you could try creating a new database and import everything from the orriginal into it. Do you have a backup of it somewhere?

Hopefully its only a minor issue.
Fingers crossed.
Aug 14 '08 #2
Thanks for your Response.

I'm not able to access the Database at all. Its not opening and i cannot be able to open in Design Mode.

Is there a way that i can use to Open the Database?
Aug 14 '08 #3
Below is the Message that the Help Command Gives: -

(No current record. (Error 3021)

This error occurs after the unsuccessful application of one of the Find methods or the Seek method, when the underlying Recordset contains no records or the record has been deleted. Move to or select another record, and try the operation again. If the Recordset is empty, you cannot position to a current record. Check the BOF and EOF properties.)

How can i Open the Database????
Aug 14 '08 #4
1,134 Expert 1GB
select the database
hold down the ctrl key
double click the database
keep ctrl key held down untill the database finishes loading

I am assuming, here, that the database has been set to not open in design mode!

If you can't get to the tables view, try my earlier suggestion.
Let us know how you go.
Aug 14 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Colin Graham | last post: by
9 posts views Thread by Robert Wing | last post: by
3 posts views Thread by windandwaves | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.