Missing Table (1 Viewer)

M

mjdemaris

Working on it...

Local time

Today, 02:22

Joined

Jul 9, 2015

Messages

426

• Jul 23, 2016

• #1

Here's a new one on me:

I have a split DB, local drive, development copy. I decided to add a new table to the backend.

Then, I wanted to link the frontend to it...it does not show up in the table list. I used the Linked Table Manager to update, I deleted all the links, and re-linked, and I deleted them again and imported all the tables. But the frontend does not show the new table I created!

I've tried compacting/repairing before and after deleting/linking.

I tried it in another DB, same thing. I've never seen this before.

:banghead:

Thanks for any help!

 

S

sneuberg

AWF VIP

Local time

Today, 02:22

Joined

Oct 17, 2014

Messages

3,506

• Jul 23, 2016

• #2

Try this.

1. In the EXTERNAL tab, Import & Link, click on the Access icon
2. Choose "Link to the data source by creating a linked table"
3. Click on Browse and navigate to the backend database
4. Click OK
5. Look in the Tables tab

Is the table listed there? If not try deleting and readding to the backend. If it is then just select it and click ok.

 

M

mjdemaris

Working on it...

Local time

Today, 02:22

Joined

Jul 9, 2015

Messages

426

• Jul 23, 2016

• #3

I tried that. Just one table does not show up in the list.

 

S

sneuberg

AWF VIP

Local time

Today, 02:22

Joined

Oct 17, 2014

Messages

3,506

• Jul 23, 2016

• #4

If you add another table to the backend then what? Are two tables missing from the list then?

 

M

mjdemaris

Working on it...

Local time

Today, 02:22

Joined

Jul 9, 2015

Messages

426

• Jul 23, 2016

• #5

Does splitting a DB change anything besides moving the tables to another file and linking? Maybe there is some setting that could cause a problem here.

 

M

mjdemaris

Working on it...

Local time

Today, 02:22

Joined

Jul 9, 2015

Messages

426

• Jul 23, 2016

• #6

sneuberg said:

If you add another table to the backend then what? Are two tables missing from the list then?

Click to expand...

Yep, that is exactly the case.

 

S

sneuberg

AWF VIP

Local time

Today, 02:22

Joined

Oct 17, 2014

Messages

3,506

• Jul 23, 2016

• #7

mjdemaris said:

Does splitting a DB change anything besides moving the tables to another file and linking? Maybe there is some setting that could cause a problem here.

Click to expand...

I don't think so. The question is, "What the difference between the tables before the split and the new table in the backend." I can't think of any setting that would hide a single table.

 

M

mjdemaris

Working on it...

Local time

Today, 02:22

Joined

Jul 9, 2015

Messages

426

• Jul 23, 2016

• #8

Got it, sneuberg. It's my fault, the default path set in Access is different than the folder I develop in, so I got the wrong back end!!

Well, sometimes it's the silly things that stump us...

Thanks for the quick response! Peace.

 

S

sneuberg

AWF VIP

Local time

Today, 02:22

Joined

Oct 17, 2014

Messages

3,506

• Jul 23, 2016

• #9

You probably know that the tables in the backend have to be real tables and not links to tables, right?

 

M

mjdemaris

Working on it...

Local time

Today, 02:22

Joined

Jul 9, 2015

Messages

426

• Jul 23, 2016

• #10

Yeah. Lol. I copy my development files to a back up folder and some time ago that was my working folder...I simply did not change the default Access project folder to something else...and the names are similar enough that I overlooked that.

 

M

mjdemaris

Working on it...

Local time

Today, 02:22

Joined

Jul 9, 2015

Messages

426

• Jul 23, 2016

• #11

I've been working on permissions at folder/file levels as well, so moving things around and trying to be careful not to lock myself out may have contributed to the confusion.