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
8  4296 
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
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
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
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
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
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: John |
last post by:
Hi
Is there a way to print/e-mail the current record as it appears on a form?
Thanks
Regards
|
by: Tony |
last post by:
I have a form in access that has 5 fields for a certain record: 1)Date
mailed, 2)Date received, 3)Date completed 4)Foreign Content amount and
5)record number. If the foreign content (FC)is >15% of...
|
by: Tony |
last post by:
Hello,
I am having difficulty in getting the current record of the current
form to show after pressing a command button that takes me to another
form. The command button takes me to another...
|
by: DBQueen |
last post by:
I have a subform which is in Continuous Forms view.
I have added a button to the bottom of the page to move to the next record
using the button wizard (result: DoCmd.GoToRecord , , acNext).
I...
|
by: Richard Coutts |
last post by:
I have a Continuous Form where each record has a button that activates
another form that simplifies entering values into the record. The
activated form has the equivalent of a "Done" button. I'd...
|
by: Maria |
last post by:
Is there another way to delete the current record in a subform from the main
form, another subform or a sub-subform other than setting focus on a field
in the subform and using run command...
|
by: hebandgene |
last post by:
When I delete a record in a subform I get the warning that I'm about to
delete a record, followed by an error "No current record." When I
click OK obviously the record is deleted and it goes to...
|
by: Zlatko Matić |
last post by:
There is a form (single form) and a combobox. I want that current record of
the form is adjusted according to selected value in the combobox. Cuurrent
record should be the same as the value in the...
|
by: 4004 |
last post by:
I would like to open a columnar form (so I can see all the details)
from a datasheet form (so I can see what is there) but keep the same
recordset and current record.
I can do the recordset set...
|
by: Jeff Karli |
last post by:
I think I now understand how to use this forum. I hope I am following the rules now. I am a college student working on a database project that requires some VBA coding for the Event Procedures and...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
