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 all. 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?
Access 2000 Database won't open
5 posts
• Page 1 of 1
- Windows XP
- FLASH
- PERL
- MS EXCEL
- Exchange 2000
- MS SQL SERVER
- dotnet framework
- pocket pc
- MS WORD
- Internet Explorer
Jump to:
- 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.
Next
Access 2000 Database won't open
by YWxleGFuZHJh » Thu, 24 May 2007 02:40:00 GMT
RE: Access 2000 Database won't open
by 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
by 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
by 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
by 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 XXXX@XXXXX.COM
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 workspace. 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
5 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 51 guest