Back end is broke

Discussion:

Back end is broke

(too old to reply)

pepper

2010-07-07 02:11:21 UTC

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

2010-07-07 03:56:01 UTC

Permalink

Post by 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

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

2010-07-07 04:14:58 UTC

Permalink

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

Post by John W. Vinson

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]
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

Douglas J. Steele

2010-07-07 12:12:58 UTC

Permalink

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!)

Post by 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

Post by John W. Vinson

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]
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

2010-07-07 22:28:16 UTC

Permalink

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!!!

Post by 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!)

Post by 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

Post by John W. Vinson

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]
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

2010-07-07 22:36:38 UTC

Permalink

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

Post by 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!!!

Post by 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

On Tue, 6 Jul 2010 19:11:21 -0700, "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]
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

2010-07-07 22:48:02 UTC

Permalink

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...???

Post by 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

Post by 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!!!

Post by 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

On Tue, 6 Jul 2010 19:11:21 -0700, "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]
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

John W. Vinson

2010-07-07 23:39:23 UTC

Permalink

Post by 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...???

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.

pepper

2010-07-08 01:32:47 UTC

Permalink

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?

Post by John W. Vinson

Post by 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...???

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]
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

John W. Vinson

2010-07-08 02:34:11 UTC

Permalink

Post by 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?

pepper

2010-07-08 18:44:36 UTC

Permalink

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

Post by John W. Vinson

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]
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

2010-07-08 02:39:30 UTC

Permalink

Post by John W. Vinson
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.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

John W. Vinson

2010-07-08 03:42:31 UTC

Permalink

Post by David W. Fenton

Post by John W. Vinson
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.

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

David W. Fenton

2010-07-08 02:38:53 UTC

Permalink

Post by Douglas J. Steele
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 http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/