|
 |
access thread: HELP! "operation invalid without current index"
Message #1 by "Tim Maher" <tim.maher@s...> on Thu, 13 Mar 2003 14:23:55 +0000
|
|
Hi,
Im going to be unemployed soon if i cant get this fixed!!
Im trying to open a very large database and im getting :
"Operation Invalid without current index"
Somebody please tell me I can fix this!!!!!!!!!!!!
TIA
Tim
This e-mail transmission is strictly confidential and intended solely
for the person or organisation to who it is addressed. It may contain
privileged and confidential information and if you are not the
intended recipient, you must not copy, distribute or take any action
in reliance on it.
If you have received this email in error, please notify us as soon as
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however,
Swansea NHS Trust accept no responsibility for infection caused by
any virus received on the recipients system.
Message #2 by Lonnie Johnson <prodevmg@y...> on Thu, 13 Mar 2003 06:27:32 -0800 (PST)
|
|
What does the database do when it first opens? Is there an autoexec macro, or a form loaded in the startup program? We need to know
this. Can you open it by holding down the shift key?
Tim Maher <tim.maher@s...> wrote:Hi,
Im going to be unemployed soon if i cant get this fixed!!
Im trying to open a very large database and im getting :
"Operation Invalid without current index"
Somebody please tell me I can fix this!!!!!!!!!!!!
TIA
Tim
This e-mail transmission is strictly confidential and intended solely
for the person or organisation to who it is addressed. It may contain
privileged and confidential information and if you are not the
intended recipient, you must not copy, distribute or take any action
in reliance on it.
If you have received this email in error, please notify us as soon as
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however,
Swansea NHS Trust accept no responsibility for infection caused by
any virus received on the recipients system.
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
http://www.prodev.us
Let me build your next MS Access database application.
---------------------------------
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
Message #3 by "Tim Maher" <tim.maher@s...> on Thu, 13 Mar 2003 14:41:46 +0000
|
|
Thanks for replying!!!!!!
when I open the database there is an empty database window. When I
click on the Tables tab I then get the error - "Operation Inalid without
current Index".
Hope this
>>> prodevmg@y... 03/13/03 02:27pm >>>
What does the database do when it first opens? Is there an autoexec
macro, or a form loaded in the startup program? We need to know this.
Can you open it by holding down the shift key?
Tim Maher <tim.maher@s...> wrote:Hi,
Im going to be unemployed soon if i cant get this fixed!!
Im trying to open a very large database and im getting :
"Operation Invalid without current index"
Somebody please tell me I can fix this!!!!!!!!!!!!
TIA
Tim
This e-mail transmission is strictly confidential and intended solely
for the person or organisation to who it is addressed. It may contain
privileged and confidential information and if you are not the
intended recipient, you must not copy, distribute or take any action
in reliance on it.
If you have received this email in error, please notify us as soon as
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however,
Swansea NHS Trust accept no responsibility for infection caused by
any virus received on the recipients system.
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
http://www.prodev.us
Let me build your next MS Access database application.
---------------------------------
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
This e-mail transmission is strictly confidential and intended solely
for the person or organisation to who it is addressed. It may contain
privileged and confidential information and if you are not the
intended recipient, you must not copy, distribute or take any action
in reliance on it.
If you have received this email in error, please notify us as soon as
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however,
Swansea NHS Trust accept no responsibility for infection caused by
any virus received on the recipients system.
Message #4 by Lonnie Johnson <prodevmg@y...> on Thu, 13 Mar 2003 07:09:09 -0800 (PST)
|
|
Here is a fix that seemed to work for another guy.
http://www.experts-exchange.com/Databases/MS_Access/Q_20278216.html
Tim Maher <tim.maher@s...> wrote:Thanks for replying!!!!!!
when I open the database there is an empty database window. When I
click on the Tables tab I then get the error - "Operation Inalid without
current Index".
Hope this
>>> prodevmg@y... 03/13/03 02:27pm >>>
What does the database do when it first opens? Is there an autoexec
macro, or a form loaded in the startup program? We need to know this.
Can you open it by holding down the shift key?
Tim Maher wrote:Hi,
Im going to be unemployed soon if i cant get this fixed!!
Im trying to open a very large database and im getting :
"Operation Invalid without current index"
Somebody please tell me I can fix this!!!!!!!!!!!!
TIA
Tim
This e-mail transmission is strictly confidential and intended solely
for the person or organisation to who it is addressed. It may contain
privileged and confidential information and if you are not the
intended recipient, you must not copy, distribute or take any action
in reliance on it.
If you have received this email in error, please notify us as soon as
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however,
Swansea NHS Trust accept no responsibility for infection caused by
any virus received on the recipients system.
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
http://www.prodev.us
Let me build your next MS Access database application.
---------------------------------
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
This e-mail transmission is strictly confidential and intended solely
for the person or organisation to who it is addressed. It may contain
privileged and confidential information and if you are not the
intended recipient, you must not copy, distribute or take any action
in reliance on it.
If you have received this email in error, please notify us as soon as
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however,
Swansea NHS Trust accept no responsibility for infection caused by
any virus received on the recipients system.
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
http://www.prodev.us
Let me build your next MS Access database application.
---------------------------------
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
Message #5 by "Tim Maher" <tim.maher@s...> on Thu, 13 Mar 2003 15:20:15 +0000
|
|
Thanks again!! ive also looked through E-E and found some veyr helpful
hints that have "saved my bacon"
I compacted - then repaied!
>>> prodevmg@y... 03/13/03 03:09pm >>>
Here is a fix that seemed to work for another guy.
http://www.experts-exchange.com/Databases/MS_Access/Q_20278216.html
Tim Maher <tim.maher@s...> wrote:Thanks for
replying!!!!!!
when I open the database there is an empty database window. When I
click on the Tables tab I then get the error - "Operation Inalid
without
current Index".
Hope this
>>> prodevmg@y... 03/13/03 02:27pm >>>
What does the database do when it first opens? Is there an autoexec
macro, or a form loaded in the startup program? We need to know this.
Can you open it by holding down the shift key?
Tim Maher wrote:Hi,
Im going to be unemployed soon if i cant get this fixed!!
Im trying to open a very large database and im getting :
"Operation Invalid without current index"
Somebody please tell me I can fix this!!!!!!!!!!!!
TIA
Tim
This e-mail transmission is strictly confidential and intended solely
for the person or organisation to who it is addressed. It may contain
privileged and confidential information and if you are not the
intended recipient, you must not copy, distribute or take any action
in reliance on it.
If you have received this email in error, please notify us as soon as
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however,
Swansea NHS Trust accept no responsibility for infection caused by
any virus received on the recipients system.
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
http://www.prodev.us
Let me build your next MS Access database application.
---------------------------------
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
This e-mail transmission is strictly confidential and intended solely
for the person or organisation to who it is addressed. It may contain
privileged and confidential information and if you are not the
intended recipient, you must not copy, distribute or take any action
in reliance on it.
If you have received this email in error, please notify us as soon as
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however,
Swansea NHS Trust accept no responsibility for infection caused by
any virus received on the recipients system.
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
http://www.prodev.us
Let me build your next MS Access database application.
---------------------------------
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
This e-mail transmission is strictly confidential and intended solely
for the person or organisation to who it is addressed. It may contain
privileged and confidential information and if you are not the
intended recipient, you must not copy, distribute or take any action
in reliance on it.
If you have received this email in error, please notify us as soon as
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however,
Swansea NHS Trust accept no responsibility for infection caused by
any virus received on the recipients system.
Message #6 by "John Ruff" <papparuff@a...> on Thu, 13 Mar 2003 07:21:15 -0800
|
|
Checkout the MS Knowledgebase article 158933.
Use Jetcomp.exe (free download from Microsoft) and try to repair the db.
If
that doesn't work, "Create a new database and import all the objects
from a
backup copy of the database."
I have found that I can sometimes import into a new db from the corrupt
db
and everthing will work fine (but not always).
Check out the part of the article about updating the Msjt3032.dll file.
There are recovery programs/services that you can purchase/contract with
that may or may not be able to recover the data.
You can check out AccessRecovery at
http://www.officerecovery.com/access/index.htm and AccessFix at
http://www.accessfix.com/. These are two programs that can be purchased
to
recover corrupted data. I've only used the demos myself so I'm not in a
position to suggest one or the other.
John V. Ruff - The Eternal Optimist :-)
Always Looking For Contract Opportunities
www.noclassroom.com
Live software training
Right over the Internet
Home: xxx.xxx.xxxx
Cell: 253.307/2947
9306 Farwest Dr SW
Lakewood, WA 98498
"Commit to the Lord whatever you do,
and your plans will succeed." Proverbs 16:3
-----Original Message-----
From: Tim Maher [mailto:tim.maher@s...]
Sent: Thursday, March 13, 2003 6:24 AM
To: Access
Subject: [access] HELP! "operation invalid without current index"
Hi,
Im going to be unemployed soon if i cant get this fixed!!
Im trying to open a very large database and im getting :
"Operation Invalid without current index"
Somebody please tell me I can fix this!!!!!!!!!!!!
TIA
Tim
This e-mail transmission is strictly confidential and intended solely
for the person or organisation to who it is addressed. It may contain
privileged and confidential information and if you are not the
intended recipient, you must not copy, distribute or take any action
in reliance on it.
If you have received this email in error, please notify us as soon as
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however,
Swansea NHS Trust accept no responsibility for infection caused by
any virus received on the recipients system.
|
|
|
View Cart
