Question Back end is broke

[pepper]

Hi,

I've asked this question before and received back the information I needed back in no time. I hope I can be as succinct this time. All of a sudden I can't access the Access 97 back end of my database located on my laptop with the Access 2002 front end that's located on my desk top. I probably should mention that I'm fairly new at this and I know no code. I do remember that where I was sent had a list of checkboxes and I had to uncheck something having to do with the Internet (I think). Can anyone help?

Thanks!

Pepper

 

[G81]

Sounds like you used table link manager last time you had this problem.

Go to Tools > Database utilities > Linked table manager

Make sure all linked tables have the correct path to the backend. You can check all and re link them if necessary.

 

[pepper]

I appriciate your reply but the Linked Table Manager isn't installed on either the front end or the back end. As it stands I can't even access the back end to link the tables. Thanks though!

 

[G81]

Can you not access the laptop at all from the desktop??? What happens when you try to ping it?

How are they connected to eachother and what operating system are they both running?

 

[pepper]

No, I can't access the backend at all with the front end and I can't open it with a with the desktop even by just double clicking on it. I can open every other program or file on the laptop from the desktop. I might also mention I can work with the back end from another front end on the laptop, I can open the the backend by it's self and I can work on another backend residing on the desktop from another front end on the laptop. I hope that all makes sense. Thanks again for your thoughts!

 

[G81]

Hi Pepper. Ive been following your thread here:

http://www.accessmonster.com/Uwe/Forum.aspx/access-gettingstarted/23694/Back-end-is-broke

You mention

When I click on open Access appears to open but
then I get a second error message saying that Microsoft Access cannot open
the file... This file located outside your intranet or on an untrusted site.
Microsoft Access will not open the file due to potential security problem.
I can open all of the other files located on the laptop from the desktop.
Thanks, pepper

I found this, I hope it helps:

http://www.access-programmers.co.uk/forums/archive/index.php/t-93725.html