Connecting Tech Pros Worldwide Forums | Help | Site Map

Lost back end connection

RBohannon
Guest
 
Posts: n/a
#1: Nov 13 '05
I have a split database (A2K). The back end was originaly on drive J.
IT changed some network stuff and eliminated the J drive. The back end
is now on the F drive. When the front end is opened, it looks for the
back end on the J drive and displays a message saying the filepath of
the back end is not a valid path.

Is there any way to reconnect the front end to the back end?

The front end appears to open. An Access.LockFile is created, but
nothing appears on screen. Not even the database window. The Linked
Table Manager is not available, neither is Get External Data. I can't
see any way of changing the location of the back end.

Any suggestions are greatly appreciated.

Randy


Randy Harris
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Lost back end connection


"RBohannon" <ranb550@hotmail.com> wrote in message
news:1114003750.035167.14220@g14g2000cwa.googlegro ups.com...[color=blue]
> I have a split database (A2K). The back end was originaly on drive J.
> IT changed some network stuff and eliminated the J drive. The back end
> is now on the F drive. When the front end is opened, it looks for the
> back end on the J drive and displays a message saying the filepath of
> the back end is not a valid path.
>
> Is there any way to reconnect the front end to the back end?
>
> The front end appears to open. An Access.LockFile is created, but
> nothing appears on screen. Not even the database window. The Linked
> Table Manager is not available, neither is Get External Data. I can't
> see any way of changing the location of the back end.
>
> Any suggestions are greatly appreciated.
>
> Randy[/color]

Try holding down the shift key when you open the application.
--
Randy Harris
(tech at promail dot com)


RBohannon
Guest
 
Posts: n/a
#3: Nov 13 '05

re: Lost back end connection


Thank you! This allowed me to open the Linked Table Manager and set
the links to the proper tables. There is still something hinkey with
the app. I keep getting error messages that say Access could not
"read" some instruction at some location.

However, I have been able to reconstruct the entire DB from parts that
were recoverable, and it was easier than I anticipated it would be.

Thanks for the help.

Randy

Closed Thread