DUX COMPUTER DIGEST

 

Site Search

Site Info

Home » Forums » Forum Archives » General » Topic # 160

Microsoft Access
BBATES Jun-20-01 03:46 PM
I have a Access 2000 database on a server and we are having a major problem for the first time in several years. The database is visable in windows explorer and can be accessed via Microsoft Excel. We were able to pull data from the tables using Excel. The problem is we cannot access the database via MS Access! When I open the database from windows explorer, Access executes, but I get a blank screen. The application starts, but no database is open. HELP

1. RE: Microsoft Access
lbyard Jun-20-01 07:51 PM
In response to message 0
I'm a bit rusty, but there are ways to hide the database window at startup and I've done it. Before I go digging into some of the code I wrote years ago, see if playing with Tools, Options, View solves the problem. Larry

2. RE: Microsoft Access
BBATES Jun-21-01 01:10 AM
In response to message 1
Yes, I know about unhide in the option menu. It is grayed out. I can't even close the database, because one isn't open. If you start Access and have a blank screen, that is exactly what I see when I click to open my database.

3. RE: Microsoft Access
tockert Jun-21-01 06:34 AM
In response to message 2
Look under the Windows to see if you can unhide your database. If that is grayed out, try to repair the database from the tools, database utilities option.
Did someone put a password on the database that is not allowing you to open it? Do you get any errors or messages when you open the database?
Right click on the database file name. Make sure that it is not set to read only. If a password or read-only is set, you should get an error msg.
Good luck

Todd
hagnd


4. RE: Microsoft Access
BBATES Jun-21-01 09:55 AM
In response to message 3
I get no error messages. I tried to repair the database, but you must have the database open to repair it....So the repair option is also grayed out. I even tried to repair the database from the command line. The screen flashes the Access screen for a split second and then nothing. I do not get a promt for a password nor is the file read-only. I have tried to open the file exclusivly and read-only with the same results. This is really strange and has me puzzled. I get the same results from all client computers and all user accounts.

5. RE: Microsoft Access
lbyard Jun-21-01 01:40 PM
In response to message 4
Itís obviousÖ but Iím not absolutely sure you havenít tried opening the database from within Access? Try http://office.microsoft.com/downloads/2000/SP2upd.aspx. Believe there is a reference to a somewhat similar problem in MS KB and that SR1 fixed it. I did a search today, but did not record the article number. Larry

6. RE: Microsoft Access
tockert Jun-22-01 04:26 AM
In response to message 5
On a worse case senerio, is to use Excel to pull the data from the database and then recreate the database with the info you pulled out with Excel. If the database is large, this may take a while.
One other thought, is to try and import the data into a new database. I would try these two options before I would start from scratch. They may give you a good starting point. The second option would be the best, in that you could most likely retreive your queries and reports and such. Excel would not give you that option.

Good luck

Todd
hagnd


7. RE: Microsoft Access
BBATES Jun-22-01 10:16 AM
In response to message 6
Yes, for now, we have pulled data from the tables using Excel, but you are right the several new tables and queries that we wrote are still stuck. I tried to import them from a different database, but no luck.

8. RE: Microsoft Access
BBATES Jun-22-01 10:18 AM
In response to message 5
Yes, we have tried opening the database from within Access. I'll try the Service Release route and let you know. Thanks for everyones help it is very much appreciated!

9. RE: Microsoft Access
lbyard Jun-22-01 04:13 PM
In response to message 8
Try importing to a new database. Larry

10. RE: Microsoft Access
BBATES Jun-25-01 12:41 PM
In response to message 9
I tried to import table into a different database, but the sreen blinked like it was tring to perform the task and then nothing. I downloaded Service Pack 1 and Service Pack 2, but still the same results.

12. RE: Microsoft Access
lbyard Jun-25-01 05:48 PM
In response to message 10
http://support.microsoft.com/support/kb/articles/Q209/1/37.ASP might help. Larry

13. RE: Microsoft Access
BBATES Jun-25-01 06:05 PM
In response to message 12
Thanks Larry, I'll give it a try.

14. RE: Microsoft Access
BBATES Jun-26-01 11:39 AM
In response to message 13
Well, I downloaded the compacting and repair tool, but I get the same thing. The access screen opens with an hour-glass for about 20 seconds and then my pointer comes back, but no database is open, just the access screen. I would have given up on this a long time ago, but I know the data is still there. Why can't I open it??? I copied the database to my local machine only to have the same problem.

15. RE: Microsoft Access
lbyard Jun-26-01 11:56 AM
In response to message 14
If permitted, send me a copy via E-Mail. Larry

16. RE: Microsoft Access
BBATES Jun-26-01 02:22 PM
In response to message 15
I will, but I must notify you that it is a 30mb file. If you want I can put it on a zip disk and mail it to you.

17. RE: Microsoft Access
BBATES Jul-02-01 05:30 PM
In response to message 16
I have overnighted you a copy of the database on a CD. You should get the database today (7-2-01) via UPS. Let me know if you can help me out.

Thanks again
Brian


18. RE: Microsoft Access
lbyard Jul-03-01 01:41 PM
In response to message 17
Brian, I sent some time on it yesterday. No luck so far. Larry

19. RE: Microsoft Access
lbyard Jul-03-01 07:18 PM
In response to message 18
Brian, I've tried everything I know about and can find and nothing works, except it looks like, from running the demo, that http://ap.excelrecovery.com/access/index.htm#General%20Recovery%20Checklist will recover most of it. However, they want $400 for the software, which can be downloaded. Larry

20. RE: Microsoft Access
BBATES Jul-03-01 09:13 PM
In response to message 19
Thanks for all of your help.

Brian


| Home | Guides | How to | Reviews | Online Store | FAQ | Forums | Forum Archives |
| Links | News | Newsletter | About Dux | Advertising | Contact Info | Privacy |