By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,503 Members | 2,821 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,503 IT Pros & Developers. It's quick & easy.

No Current Record

P: n/a
G'day Guru's,
A colleague at work has a Access 2002 DB which was up until last night,
working fine. However, now when he tries to open it, he gets an error
message "No current record". I have tried bypassing the start-up options,
compact and repair and importing into a new database but still get the same
message with each thing I try.

If I create a new DB and make an append query to this 'Corrupt' database, it
works fine but I can't link to it!!!

Has anyone and ideas on A) what caused this and B) how to fix it?

TIA,

Mark
Nov 13 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
On Fri, 29 Jul 2005 05:55:54 GMT, "Mark" <ma**********@ntlworld.com>
wrote:

Hit Ctrl+Break. Show us that section of code.
-Tom.

G'day Guru's,
A colleague at work has a Access 2002 DB which was up until last night,
working fine. However, now when he tries to open it, he gets an error
message "No current record". I have tried bypassing the start-up options,
compact and repair and importing into a new database but still get the same
message with each thing I try.

If I create a new DB and make an append query to this 'Corrupt' database, it
works fine but I can't link to it!!!

Has anyone and ideas on A) what caused this and B) how to fix it?

TIA,

Mark


Nov 13 '05 #2

P: n/a
I would if I could but that does nothing either. Like I said, I am bypassing
start-up options so no code is running but still get the same message!!!

Mark

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:jh********************************@4ax.com...
On Fri, 29 Jul 2005 05:55:54 GMT, "Mark" <ma**********@ntlworld.com>
wrote:

Hit Ctrl+Break. Show us that section of code.
-Tom.

G'day Guru's,
A colleague at work has a Access 2002 DB which was up until last night,
working fine. However, now when he tries to open it, he gets an error
message "No current record". I have tried bypassing the start-up options,
compact and repair and importing into a new database but still get the same
message with each thing I try.

If I create a new DB and make an append query to this 'Corrupt' database,
it
works fine but I can't link to it!!!

Has anyone and ideas on A) what caused this and B) how to fix it?

TIA,

Mark

Nov 13 '05 #3

P: n/a
Hello Mark,

Does it let you proceed normally after the error message? And what
does the following mean exactly:

"If I create a new DB and make an append query to this 'Corrupt'
database, it
works fine but I can't link to it!!! "

Does this mean you create a second database with linked tables to the
corrupted database?

Have you tried decompiling (see
http://trigeminal.com/usenet/usenet004.asp for more info) then compact
and repair?

Bruce

Nov 13 '05 #4

P: n/a
No it does not proceed normally. There is just the access container visible,
no database window.

I can't link to the database but if I create an append query (where you have
to select the source database and table) in a new database, I can append
data to the corrupt database!

I have not tried a decompile. If I can get to this option, I will give it a
go. Thanks for the suggestion!!

Mark

<br***@aristotle.net> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
Hello Mark,

Does it let you proceed normally after the error message? And what
does the following mean exactly:

"If I create a new DB and make an append query to this 'Corrupt'
database, it
works fine but I can't link to it!!! "

Does this mean you create a second database with linked tables to the
corrupted database?

Have you tried decompiling (see
http://trigeminal.com/usenet/usenet004.asp for more info) then compact
and repair?

Bruce
Nov 13 '05 #5

P: n/a
On Fri, 29 Jul 2005 18:07:39 GMT, "Mark" <ma**********@ntlworld.com>
wrote:

No, that's not true. If you shift-load the application, NOTHING
executes, so no error messages are generated.
On second thought, I guess it's possible that an add-in or another
referenced module (Tools/References) would load and take an error.
What happens if you load the Northwind sample application?

-Tom.

I would if I could but that does nothing either. Like I said, I am bypassing
start-up options so no code is running but still get the same message!!!

Mark

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:jh********************************@4ax.com.. .
On Fri, 29 Jul 2005 05:55:54 GMT, "Mark" <ma**********@ntlworld.com>
wrote:

Hit Ctrl+Break. Show us that section of code.
-Tom.

G'day Guru's,
A colleague at work has a Access 2002 DB which was up until last night,
working fine. However, now when he tries to open it, he gets an error
message "No current record". I have tried bypassing the start-up options,
compact and repair and importing into a new database but still get the same
message with each thing I try.

If I create a new DB and make an append query to this 'Corrupt' database,
it
works fine but I can't link to it!!!

Has anyone and ideas on A) what caused this and B) how to fix it?

TIA,

Mark


Nov 13 '05 #6

P: n/a
If you load the northwind or any other database, there's no problem at all.
I did add a reference to his app ("Microsoft DAO Object Library") but that
was some weeks ago. Do you think that this is the problem? Do you know how
to fix broken references?
Thanks,
Mark

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:qi********************************@4ax.com...
On Fri, 29 Jul 2005 18:07:39 GMT, "Mark" <ma**********@ntlworld.com>
wrote:

No, that's not true. If you shift-load the application, NOTHING
executes, so no error messages are generated.
On second thought, I guess it's possible that an add-in or another
referenced module (Tools/References) would load and take an error.
What happens if you load the Northwind sample application?

-Tom.

I would if I could but that does nothing either. Like I said, I am
bypassing
start-up options so no code is running but still get the same message!!!

Mark

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:jh********************************@4ax.com.. .
On Fri, 29 Jul 2005 05:55:54 GMT, "Mark" <ma**********@ntlworld.com>
wrote:

Hit Ctrl+Break. Show us that section of code.
-Tom.

G'day Guru's,
A colleague at work has a Access 2002 DB which was up until last
night,
working fine. However, now when he tries to open it, he gets an error
message "No current record". I have tried bypassing the start-up options,
compact and repair and importing into a new database but still get the
same
message with each thing I try.

If I create a new DB and make an append query to this 'Corrupt' database,
it
works fine but I can't link to it!!!

Has anyone and ideas on A) what caused this and B) how to fix it?

TIA,

Mark

Nov 13 '05 #7

P: n/a
On Sat, 30 Jul 2005 06:25:38 GMT, "Mark" <ma**********@ntlworld.com>
wrote:

It's unlikely that the DAO library caused the problem. If you select
Tools/References and don't see any Missing ones, you should be fine.
Be sure to compile your app (Debug/Compile).

-Tom.

If you load the northwind or any other database, there's no problem at all.
I did add a reference to his app ("Microsoft DAO Object Library") but that
was some weeks ago. Do you think that this is the problem? Do you know how
to fix broken references?
Thanks,
Mark

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:qi********************************@4ax.com.. .
On Fri, 29 Jul 2005 18:07:39 GMT, "Mark" <ma**********@ntlworld.com>
wrote:

No, that's not true. If you shift-load the application, NOTHING
executes, so no error messages are generated.
On second thought, I guess it's possible that an add-in or another
referenced module (Tools/References) would load and take an error.
What happens if you load the Northwind sample application?

-Tom.

I would if I could but that does nothing either. Like I said, I am
bypassing
start-up options so no code is running but still get the same message!!!

Mark

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:jh********************************@4ax.com. ..
On Fri, 29 Jul 2005 05:55:54 GMT, "Mark" <ma**********@ntlworld.com>
wrote:

Hit Ctrl+Break. Show us that section of code.
-Tom.

G'day Guru's,
A colleague at work has a Access 2002 DB which was up until last
night,
working fine. However, now when he tries to open it, he gets an error
message "No current record". I have tried bypassing the start-up options,
compact and repair and importing into a new database but still get the
same
message with each thing I try.

If I create a new DB and make an append query to this 'Corrupt' database,
it
works fine but I can't link to it!!!

Has anyone and ideas on A) what caused this and B) how to fix it?

TIA,

Mark


Nov 13 '05 #8

P: n/a
Tom van Stiphout <no*************@cox.net> wrote in
news:nm********************************@4ax.com:
It's unlikely that the DAO library caused the problem. If you
select Tools/References and don't see any Missing ones, you should
be fine. Be sure to compile your app (Debug/Compile).


Well, it *could* cause a problem if the order is such that DAO is
first in the list and the code is written for ADO, instead.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.