Access error message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I recently upgraded to Windows XP. When trying to open a '97 Access database, an error message appeared. It said something like "shortcut has been changed or file has been moved. Do you want to delete the shortcut?" Have I lost my database? Can it be retrieved?
 
I have seen shortcuts respond this way because they would remember the
computer name as well as the actually disk location and try to make a
network connection back to the original computer. It usually happens when
you copy the shortcut from one computer to another, but I'm wondering if
changing the OS is causing this also. Use My Computer and browse to where
the file should be to see if it is still there. If it is, just create a new
shortcut.

--
Wayne Morgan
MS Access MVP


nikki said:
I recently upgraded to Windows XP. When trying to open a '97 Access
Click to expand...
database, an error message appeared. It said something like "shortcut has
been changed or file has been moved. Do you want to delete the shortcut?"
Have I lost my database? Can it be retrieved?
 
Thanks for the suggestion. However, the computer was not changed only upgraded and the database can not located in My Computer. Hope you have other ideas

----- Wayne Morgan wrote: ----

I have seen shortcuts respond this way because they would remember th
computer name as well as the actually disk location and try to make
network connection back to the original computer. It usually happens whe
you copy the shortcut from one computer to another, but I'm wondering i
changing the OS is causing this also. Use My Computer and browse to wher
the file should be to see if it is still there. If it is, just create a ne
shortcut

--
Wayne Morga
MS Access MV


nikki said:
I recently upgraded to Windows XP. When trying to open a '97 Acces
Click to expand...
database, an error message appeared. It said something like "shortcut ha
been changed or file has been moved. Do you want to delete the shortcut?
Have I lost my database? Can it be retrieved
 
You mean you can't find the .mdb file by searching your local drive/s? Where
was it (the actual Database) before you upgraded the os?
 
Hi, thanks for replying. It was in My Documents. I'm not sure what exactly you are asking. When I did a search for it, it showed up once in Windows Explorer but could not be accessed. This is when I get the error message. If I try to access it though the Desktop shortcut, it asked which application do I want to open it up in. None of the choices will open it
nikk

----- Damien McBain wrote: ----


You mean you can't find the .mdb file by searching your local drive/s? Wher
was it (the actual Database) before you upgraded the os

nikki wrote
 
What OS did you upgrade from? If you do a search (F3) where does it say the
file is currently located? It may be that your My Documents is moved and the
NTFS permissions won't let you at the old folder. If so, browse to the
folder, right click it and choose Sharing and Security... Go to the Security
tab and click Advanced. Click the Owner tab, select your account, select the
check box at the bottom that says Replace owner on subcontainers.... and
click Ok. This should give you access to the file, if not, it will at least
give you permission to change the folder's permissions so that you can
access the file. You will have to have Administrator permissions to do this.

--
Wayne Morgan
Microsoft Access MVP


nikki said:
Hi, thanks for replying. It was in My Documents. I'm not sure what
Click to expand...
exactly you are asking. When I did a search for it, it showed up once in
Windows Explorer but could not be accessed. This is when I get the error
message. If I try to access it though the Desktop shortcut, it asked which
application do I want to open it up in. None of the choices will open it.
 
Hmm, if the file is still there, chances are that it will be OK.
If you can see the file (*.mdb), does it have a MS Access Icon (the key
thing), or a windows icon? If it doesn't have an Access icon then
something's probably happened to the file association. You can fix this
manually (by associating mdb, mde etc with ms access) or reinstall Access.
I would always recommend a clean install when upgrading to XP, especially if
you were using Win98, ME or 95.
 
Wayne and Damien, I am so grateful for the help you provided. The database was recovered intact. Thank you for taking the time to guide me through this
nikki
 
Back
Top