Access 2000 Database won't open

MS Office Access


  • 1. data corruption - the search key was not found in any record
    While on a text type field, when try to input data directly to a table (in a record that is already created), I get the error: "the search key was not found in any record" Upon moving off the record I get a little square charater preceding an "@" character. I've read up a bit and found two suggestions. The first is to compact and repair. Although this seems to work and allows me to input data into my other record, I get a new record at the top of my table, preceding my first record, that seems to be written in Chinese, with a primary key of "-16742401". I seem to be able to just delete this record and move on, but I'm curious as to whether it has any known meaning. It seems I have three options: 1) Doing the compact/repair and deleting this weird record 2) Deleting my bad record and recreating it and reassigning primary keys to related records 3) Creating a new database, importing all objects, and leaving this record out (with a SELECT FROM WHERE) of the import Thoughts on the weird record and/or any of my solutions would be greatly appreciated... -- _____ DC G
  • 2. Scaling a number by multiple of Thousands
    I would like to display numbers in Thousands like $2,159,260 to be displayed as $2.159. I have tried by using #,, and it works, but however if the number is less than a million I want the number with a leading zero for example: $159,260 to be displayed as 0.159 and currently it does not do that In microsoft Excel the number format for scaling a number down is #,##0.000,, I do not know how to make it work in Access. I am using Access 2000 Any help will be appreciated Regards Edward
  • 3. Text file editing in Access?
    Hi anyone, I wander if there is any way to open and then save a text file in access with the data from one of the fields in a form... Basically what I need is 1. Take the string from the user. 2. Insert it in the text file. 3. Save the file. Is it possible? Thanks for your time and advice. Alex
  • 4. Delay execution
    Is there a command to temporarily halt execution in VBA, like 'sleep' command in other languages? I have automated batch document creation and printing but the dicuments print too quickly causing the printer to get confused. I thought I would make it sleep between documents but I don't know how.
  • 5. where to put criteria?
    For a given report I want to either print all or a single batch. I can create 2 queries with the appropriate criteria, but since the report is always the same except for record source being qryAll or qryBatch, isn't there a better way to do this than creating the same report twice with the only difference being the record source. PS. I don't know VB at all.

Access 2000 Database won't open

Postby YWxleGFuZHJh » Thu, 24 May 2007 02:40:00 GMT

I am working with several Access 2000 databases.
I worked in one of them this morning and after exiting and re-opening the 
database it only displays a blank page. It doesn't appear to even open at 
The other databases work fine.
The file size of the database is still the same, so the data appears to 
still be there.

Any advice?

RE: Access 2000 Database won't open

Postby SmFja2llIEw » Thu, 24 May 2007 03:31:01 GMT

Normally, does a form automatically load upon opening?  If so, start your 
program by holding the shift key and try opening up that form through design 
mode instead.  Your main form may have gotten "damaged".  You could try the 
Compact/Repair utility but that has not worked to fix a bad form for me in 
the past.  I normally restore the form by importing it from a backup.

Hope this helps.

RE: Access 2000 Database won't open

Postby YWxleGFuZHJh » Thu, 24 May 2007 04:01:02 GMT

Thanks for your quick reply.
Normally a main menu form opens. I worked in the database this morning. 
After I closed out of it and re-openend it nothing happended. It just 
displays a blank page and the database does not open at all.

I tried the shift key and also the F11 key but it didn't work.

I was thinking that I might have to import from a backup.

RE: Access 2000 Database won't open

Postby SmFja2llIEw » Thu, 24 May 2007 04:59:00 GMT

If you have a backup you can use, great. 

Another thing you can try is to open a new, blank database and try importing 
the queries, forms, reports, etc. from the damaged database.  You can 
sometimes isolate the damaged object this way.

Hope this helps.

RE: Access 2000 Database won't open

Postby YWxleGFuZHJh » Thu, 24 May 2007 05:07:06 GMT

Thanks, I was able to retrieve a backup.

Similar Threads:

1.Access 2003 won't open Access 2000 database

We have a new workstation running XP Pro and Office XP (Access 2003).
We installed the front end of a database that's been operating for
years on 98, 2000, etc on this workstation, but when we try to open
the front end on the workstation, we get this error message:

"Warning!  Unsafe expressions are not blocked..."

If we bypass the warning and continue, the db opens to the main menu
(built with menu builder) but immediately errors out with a message
about "unauthorized to execute this code..."  or something similar.

What is the solution for this?  I'm well aware that older Access apps
should run just fine under XP.

Paul Fenton

2.Access 2000 won't open databases

I just recently install a fresh version of windows 2000 
Pro and office 2000. All the programs in office work fine. 
I went to open an old database that i have (created by 
access 2000) and it won't open. I tried opening others, no 
go. I tried creating a new one. No luck. I tried removing 
access and reinstalling it. Still no luck. then I removed 
Office entirely and reinstalled the whole thing (every 
feature). Still nothing. Please help my next step is to 
start over and reinstall windows from scratch again.

3.Access opens to blank screen, won't open database

I am troubleshooting for a computer that just had  2003 installed and
can not open files/DB

>From a complete uninstall, reinstall: The files are reconized as
access, and when you click on them, Access opens but to a empty

The DB is on a shared drive and is accessable by other users that have
noproblem with it.

Any ideas?

4.access opens database first time, close and retry database won't o

access file resides on a file share. Opens successfully first time to 
switchboard. Close and try to reopen nothing happens. End up restarting pc to 
open database again. 

5.word 2000 will not open new files and outlook 2000 won't attac

hello, Chris.  The solution was to get Microsoft's help to uninstall Office, 
do some manual registry changes and reinstall Office. A simple uninstall and 
reinstall didn't work.       I believe that an Office "Add-in" from a 3rd 
Party had caused the problem. I haven't reinstalled the 3rd Party and the 
pblm has not reappeared. George

"Chris M" wrote:

> George,
> I'm having the same issue as of late.  I didn't see any responses to your 
> post.  Were you able to come up with a solution?  
> Thanks,
> Chris M
> "george s" wrote:
> > running winxp home.
> > 
> > using the "open" icon, then the "open" menu, word 2000 doesn't allow me to 
> > highlight the file i want to open. also, won't allow use of the "view" icon 
> > to show details. usually ends up "hanging" the computer
> > 
> > outlook2000 won't allow selection of files to attach to an email

6. word 2000 will not open new files and outlook 2000 won't attach fi

7. Access 2.0 help files won't open in Win 2000

8. query won't open in design mode in Access 2000

Return to MS Office Access


Who is online

Users browsing this forum: No registered users and 51 guest