Problem With Linking Tables

[Guest]

I created three new look up tables in the back end of my database today.
The tables are in the back end of my database and they have data in them. I
can see them and open them. The table properties are not set to hidden or
read only.

When I attempt to link the three new tables in the front end of my
database by going to File - Get External Data - Link Tables and then navigate
to the back end of my database, the three new tables are not listed in the
Link Tables dialog box. I've checked over and over. The new tables are in
the back end of my database, I am navigating to the correct back end databse,
the table properties are not hidden or read only, etc. I'm working in Access
2002 with a database brought over from Access 2000 in 2002 file format.

My Access User Group leader group said that he has seen this happen with
all of the tables being missing, but not selectively. He suggested running
Office Update because there might be a bug fix. He also remembers seeing
something on the MS Knowledge Base, but can't remember what it was. Does
anyone know?

If you could advise, I'd greatly appreciate it.

 

[Guest]

Do you have security set up on your back end database? It could be that, if
you do have security set up, you do not have permissions to it.

 

[Guest]

No, I don't have any security set up on the back end of my database.

 

[Guest]

hmmmmmmmm, well, I was thinking that maybe you were exepecting to find them
first time in the linked table manager, but you were going the right place
for a first time link. Two things to try, out of curiousity:
1. Compact and repair both databases
2. Try linking by using VBA. I would go the the immediate window and hand
enter the code to link from there.
I don't know if either of these will do any good, but I would be curious to
see what happens.

 

[Ken Snell [MVP]]

I've not seen the behavior that you're describing. My initial thought is
that you are not actually navigating to the backend file into which you put
the new tables. I know that you stated that you are indeed going to that
file, but what you describe suggests that you put the tables into a
different db file.

One way to verify that you're "looking" at the correct backend file is use
Windows Explorer to go to the backend file to which your front end linking.
Do this without having the front end open. There should be no ".ldb" file
there with the same name as the backend file. Now open your front end; do
you then see an ".ldb" file appear? If not, open a table in your front end;
now does the ".ldb" file appear?

If you don't see an ".ldb" file after doing these things, then your front
end is linked to a different backend that you think.

 

[Guest]

Well, that was the problem - Being convinced that I was looking at the
correct back end database. Second copy of the same back end database - same
name , different folder, causing confusion. Boy, do I have egg on my face -
but thanks so much for your help - Sometimes it's the easy, obvious
solution. Thanks again -

Zoe

 

[Ken Snell [MVP]]

You're welcome!

--

Ken Snell
<MS ACCESS MVP>

Well, that was the problem - Being convinced that I was looking at the
correct back end database. Second copy of the same back end database -
same
name , different folder, causing confusion. Boy, do I have egg on my
face -
but thanks so much for your help - Sometimes it's the easy, obvious
solution. Thanks again -

Zoe