Access 2000

[detroitwebs]

Help! I tried once again to run Access 2000 after reinstalling Office 2000 on my newly upgraded Win XP machine. I could never get Access 2000 to run right on computers I've had in the past either, running Win 98, so I thought I'd try it on this one running XP. Same exact problem. This is what is does:

After installation I tried to click on the MSACCESS 2000 program icon and it tells me that I didn't select a database or I didn't put in a correct path. So I do the next best thing and click on an existing mdb file from a folder, (I've tried several) and it will open but the taskbar indicator is blank. No icon on the left or text. The Menu Bar has only the basics listed. There is no Tool Menu etc., nor anyway to edit the Menu Bar. If you click on the File Menu the only two options are Close and Exit. I can't even start a new mdb file. So right now Access is about totally useless.

I've never had this problem with Access 97 and I've been using it since it first appeared. It's almost as if the disc has an a defect and only part of the program installs. Very strange. Anyone ever hear of this or anything like it?

Thanks for any advice you can give me.

[Lowland]

It sounds like your Access is opening with a macro attached, I would bet it's been set to do this as a security measure - this is common practice. Now, this is normally done by database, not at programme level, but if you've had this corrupted, then you may have a registry problem.

Try this. Find an *.mdb icon ( one of your databases) Single-click to highlight ( I assume you don't have single-click open!) Then, mouse pointer over the highlighted icon, press shift and hold down while click to open. Keep depressed shift until app is open. That's one way of getting a macro not to run. You could try that on the programme icon too, but I ain't tried that, so I don't know if it works. Wouldn't be surprised though!

Good luck

[detroitwebs]

Thanks, but it didn't work. I wrote to Microsoft last night too and several other forums. I've been in the "computer world" for over 14 years and I've never seen this. But heck, that's what keeps my job interesting!

I appreciate your help.

[Lowland]

If the only common element in this is your Access installation disk, then maybe that is where the problem is. What version is it, was it an original or a burn?

Gotta ask!

[detroitwebs]

No, it's an original copy that we received when we bought our Dell 733 over a year ago. It's the Small Business Edition. It's gotta be in the disc, because this is too bizarre. Am still waiting to hear from Microsoft, but that could takes days and days... Oh, well, patience is a virtue. For now I will use Access 97 at our shop. At least I can always count on that!

Thanks again and Happy Holidays from Detroit!

[SubZero]

Office 2000 Small Business edition does not include Access 2000.

[Lowland]

And that's where your problem is!!!!

Office Small Business loads the Access pip (I think) files in your office directory, so if you try and run the .exe programme, you can't, 'cos you ain't bought it! The reason it does this is so that you can easily integrate Access with the Office SB edition

You need to get a copy of the Access programme, which comes either alone or on the Office Professional set. I never bought Access 2000 on it's own, because over here it is ludicrously expensive.

Get the programme and you'll see the benefit!

Good luck

[detroitwebs]

Hi:

According to Microsoft themselves, it should work on a full install. As I said, I can get the databases to come up, but with the program is not complete. Anyway, it's a mute point, because I am going to upgrade to Access 2002.

So on to bigger and better...

[SubZero]

It could have installed Access 2000 Runtime Environment on your machine. But even with a full install of Office 2000 SBE, you will NOT have Access 2000. It ain't on the disk.

[Lowland]

PLUS....

If you ain't bought Access 2000, how can you upgrade??? If you buy an upgrade it probably won't work!!

You need the full programme - evn if MS say you don't, they may think you have Office Pro or Access standalone.

Make sure before you shell out!!!!

Good luck

[detroitwebs]

Because I have ACCESS 97 at my home office and my shop office. It's been working fine, but wouldn't install after the upgrade to XP on at my home office, that's when I tried to Office 2000 version. And yes, I'm eligible for Access 2002, I already bought and installed it so, nuff said!

Thanks to those of you who lent their help, but I can't help feeling that there's also a few people around here who like to be condescending to others and that's not necessary.

Marion
Detroit Webs LLC

[Lowland]

Sorry you think that. A load of people give their time to try and help, and when you've done a lot of this, sometimes you forget that you have to ask the right questions to be able to help. If you look at other posts you'll see it can take a lot of enquiry to get to the problem!

Plus, the site is listed for advanced users, so I guess we all have an expectation when posts are made.

Anyway, glad you are sorted - that's what really matters. Don't give up on us if we can help, and we probably need to tap into your experience too!

Good luck!

[SubZero]

Marion,

Lowland has a good point about asking the right questions. I would have thought you had a bad install disk until you mentioned that you were using Small Business Edition. That was the clue that solved the issue. When you try to solve someone's problem on here, it's like looking at transcript, and trying to see what info you need. Also, remember, something may sound condecending if it was poorly worded.

Ron aka Sheriff Q
WinDrivers Forum Moderator

[detroitwebs]

Thank you both for replying. I do apologize for being a bit sensitive this week. It's been a very rough two weeks (husband in hospital-he's okay, and other stuff going on). On top of that dealing with twerps from Microsoft. The tech specialist (???) read my DETAILED letter (no, the problem was he didn't) and then replied treating me as an absolute beginner. One of his remarks to me was maybe my desktop icon was bad. Wow, did you read the letter, mister? So I replied that if he even glanced at the letter he wouldn't have responded the way he did.

I was talking with the gal I meet with once a month for our IT meetings and she felt the same way I did. If you finally get to the point that you have to resort to using their tech support, then most of them treat you like novices who got their first computers last week. It's extremely annoying to say the least. If I have to call I usually start out this way to save 10 minutes, "Hi, I'm Marion and I've been a tech consultant for over 14 years, so let's get to the nitty-gritty!" :-)

So, in closing, let me say thanks again and I promise to come back now and then and take a peek. I apprciate your thoughts and comments.

Oh, just so you know, I happily finished the new database for my husband's machine shop this afternoon. He's happy, and I'm happy that I finally got through the dilemma. Nothing like good ole' perserverance.

Have a great holiday season. Stay safe!

Regards,
Marion