Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Robert K asked in Computers & InternetSoftware · 1 decade ago

Can anyone help me with Microsoft Access?

I keep my customer records in a ms access database that was set up in 1997 (windows 95). I later updated to windows 98 and the application worked fine. I've now copied and moved the application to a windows xp computer and I'm having trouble. The trouble seems to be that access looks for my database in "C:\windows\desktop", but in this xp computer the desktop is located in "C:\documents and settings\administrator\desktop". It's simply an incorrect path.

but I can't find how to re-specify the path.

any suggestions? thanks.

retype: the desktop is located in "C:\Documents and Settings\Administrator\Desktop"

twice now I've typed desktop, but when I post it comes out des...

I don't know why that should be, but you get what I'm trying to type, I hope.

Update:

Thanks for anwers so far. Belgaria, I've been afraid that you are right; I might have to type in the records manually.

600 +. Man, I hope it doesn't come to that.

Update 2:

Michael B, thanks. I just took a quick look @ Alt+F11. I didn't see where to change the filepath, but it was just a quick try. When I have a bit of time later, I'll keep looking. You've given me something to work with. And that's hopefull. Thanks.

2 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    I'm not sure what you mean by you've re-typed...but...

    My guess would be that you need to get into the VBA editor (Alt-F11) and in the code you will find a reference to the desktop. It would be stored in a variable. Change that reference to the new location and you should be OK.

  • 1 decade ago

    I think I might understand. Your earlier computers were dos based. Windows XP does not use dos. Transferring older software to windows XP can be a real pain in the but. Try your help and support software it might help you if you installed an older program directly onto windows XP otherwise you may have to manually reinstall all of your customers files into a newer version.

Still have questions? Get your answers by asking now.