Access can't find required file for startup

[jbknudsen]

Greetings to all.
The long-short of this is: My machine experienced a glitch, windows installer continued to run at boot up. After the initial fix, the resultant problem is ms access. I was on office 2000 professional. I ran a repair install, no luck, a removal of office, disk cleanup and defrag then reloading office 2000 professional. Still no luck. Next I uninstalled office 2000 pro, downloaded the installer cleanup from microsoft and followed by installing office xp professional. The problem still exists. I am running windows 2000 professional, have 100 gig hard drive and have used 9 gig of space, 512meg of memory. Below are the error messages I experience with any access data base.

"Workgroup Administrator couldn't create the workgroup information file. Make sure that you have specified a valid path and file name, that you have adequate permission to create the file, and that you have enough disk space on the destination drive (-3100."

after "rc" on "ok"

"Microsoft Access couldn't find file '??'. This file is required for startup."

The data base that I am after is working on other machines with no problems. Additionally all of the other office programs work as they should.

Any clues on how to fix are much appreciated.

Best Regards,
Jay
jay@dicar.com

 

[THWatson]

Jay
Just a shot in the dark. Is your operation FrontEnd/BackEnd? If so, do you need to re-link the Front and Back ends?

As I said, just a shot in the dark.

Tom

 

[jbknudsen]

Tom
Thanks for the reply, I am not sure, is there an easy way to find out?

Jay

 

[THWatson]

Jay
Is everything you are working with on your own machine, or do you have only the FrontEnd (the forms, queries, reports etc.) on your machine, and the BackEnd (the tables) on a server which is accessed by several people?
I assumed this might be the case, because you mention the database is running fine on other machines.

Regardless of whether you are working from a server, or everything is contained on your own computer...
To check, and refresh, the links between the FrontEnd (the forms, queries, reports etc.) and the BackEnd (the tables), go to Tools > Database Utilities > Linked Table Manager and follow the steps to refresh the links to the tables. Be sure and tick the "Always prompt for new location" box or you'll have to repeat the operation for each table.

If it's not a linkage problem, then perhaps the database has become corrupted when your computer got the glitches. What you could do then is make a new blank database and import all the objects from the corrupted one, and see if things will work then.

Tom

 

[jbknudsen]

Tom,
The files are on the server, none of the info is located locally. I can log in at another machine and use the desired file. The "Linked table manager" is greyed out, it is not selectable. I looked under security, could the user and account info need to be setup again since I have uninstalled and re-installed access?

Jay

 

[THWatson]

Jay
Given your original error message - "Workgroup Administrator couldn't create" - that sounds quite probable. You probably lost the security settings when you uninstalled and reinstalled Access. Worth a try.

Tom