Back end is broke

[pepper]

Hi,

I've asked this question before and received back the information I needed
in no time. I hope I can be as succinct this time.
All of a sudden I can't access the back end of my database located on my
laptop from the front end located on my laptop. I probably should mention
that I'm fairly new at this and I know no code. I do remember that it hade
something to do with an internet setting but I can't find anything that
looks familiar. Please help!

Thanks!

Pepper

 

[John W. Vinson]

Hi,

I've asked this question before and received back the information I needed
in no time. I hope I can be as succinct this time.
All of a sudden I can't access the back end of my database located on my
laptop from the front end located on my laptop. I probably should mention
that I'm fairly new at this and I know no code. I do remember that it hade
something to do with an internet setting but I can't find anything that
looks familiar. Please help!

Thanks!

Pepper

Insufficient information, Pepper. What and where are the backend and frontend?
..mdb files, .accdb, a SQL/Server instance, ...? What version of Access? What
do internet settings have to do with it if the front and back end are both on
THE SAME COMPUTER? (Access doesn't play nice over the Internet in any case)!

Try Tools... Database Utilites... Linked Table Manager to relink to the
backend. Internet shouldn't come into the picture at all.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[pepper]

OK, so much for my trying to be succint. Thanks so much for getting back to
me. If I understand your questions, the files are .mdb and it's an office
97 backend on my laptop and an Access 2002 frontend on my desktop.
Regarding the internet settings, as I recall, where I was directed before
there was a list on checkboxes and when I unchecked something having to do
with the Internet I was able to line the frontend with the backend again. I
checked on the Linked Table Manager but it's not installed. Thanks again!
Pepper

 

[Douglas J. Steele]

The Linked Table Manager is installed by default. Unfortunately, I don't
have Access 2002 installed anywhere handy, so I can't give you instructions,
but I believe it's under Tools | Database Utilities.

Alternatively, download the free J Street Access Relinker from
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)

 

[pepper]

OK, I found it. Thanks again for your efforts. Just as an FYI, in what I
think is called the code window. On the Tools menu it gives a referances
option. If you choose it a References -db1 option box opens. One of the
check options is something like Microsoft Office XP Web components. Checked
I can't link to the back end and unchecked I can. Like I said this is a
recent occurrence so if anyone could tell me why it started happening I'd
sure appreciate it. Maybe it was an update? Thanks!!!

 

[pepper]

BTW, I might mention in case it's relevant. My Networks Places has these
computers locations as 'The Internet' instead of 'Local Network. I don't
know anything about networking either but if you this is a problem please
let me know. Many thanks, Pepper

 

[pepper]

OK, my mistake, it didn't work this time and there is not a Linked Table
Manager installed in either the Access 97 back end nor the Access 2002 front
end...???

 

[John W. Vinson]

OK, my mistake, it didn't work this time and there is not a Linked Table
Manager installed in either the Access 97 back end nor the Access 2002 front
end...???

That suggests a corrupt installation of Access (not a corrupt database, though
that's possible too, but a bad install of the Access program itself). The
Linked Table Manager is a builtin, automatic, non-extra feature of Access 97
(and all other versions).

You can relink tables without it, if need be. To do so, make a backup of your
frontend. Open the Tables window, take a deep breath, select all the linked
tables... and press the Delete key to delete the link. You're just deleting
the link not the table, IF you're in fact in the frontend and each table icon
has a little arrow icon by it.

Then for 2003 use File... Get External Data... Link to link to the backend;
for 2007 use the External Data tab on the ribbon. Navigate to the current
location of the backend, select all the tables (or that subset of the tables
which should be linked), and link to them.

There is something REALLY weird going on here: the XP Web Components is *not*
involved in linking to a backend database, so having it checked or unchecked
should have no effect on this issue.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[pepper]

Thanks John! I'm starting to think this is a networking problem instead of
an MS Access problem. Can you tell me if Microsoft has a networking forum
or do you think I'd be better off going to something like a Lynksys forum?

 

[John W. Vinson]

Thanks John! I'm starting to think this is a networking problem instead of
an MS Access problem. Can you tell me if Microsoft has a networking forum
or do you think I'd be better off going to something like a Lynksys forum?

I'm not sure where to look. Linksys makes the hardware, but the software would
probably be Windows. Perhaps someone else can suggest where to look.

Can you use Windows Explorer to view files across the network? Do you have a
networking expert, or are you on your own?
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[David W. Fenton]

The Linked Table Manager is installed by default.

Actually, no it's not -- it's only installed if you include the
"advanced wizards."

 

[David W. Fenton]

The
Linked Table Manager is a builtin, automatic, non-extra feature of
Access 97 (and all other versions).

No, it's not. It is only installed in those versions if you choose
to install the ADVANCED WIZARDS.

 

[John W. Vinson]

No, it's not. It is only installed in those versions if you choose
to install the ADVANCED WIZARDS.

Thanks, David - I wasn't aware of that and I've never worked with Access
without it.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[pepper]

When I first click on a MS Access 97 back end I get a Open Fle - Security
Warning that says that the publisther is unknown and then asks if I really
want to open this file? 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