Turn on a Table?

[nwebber]

Hello all,

First time posting here. So I have been working as a CRM Sys-Admin for about 4 months. My predecessor did not leave me with much in the way of coherent instruction. I am currently creating a registry of products for a convention. I have been working my way through his notes, but I've come to the vague instruction of "Turn on the convention by going to the convention table and changing it to 1". Now I have no idea what this means so I went digging. Eventually I found my way to the Linked Table Manager, and I thought I solved my problem. It had my table name with a 0 next to it, so all I have to do is change it to a 1 right? Problem is, I don't see an option to change the number. I will include a screenshot of the page I'm on.

Any advice on what I need to do? Or to point me in the right direction?

[nwebber]

Hello all,

First time posting here. So I have been working as a CRM Sys-Admin for about 4 months. My predecessor did not leave me with much in the way of coherent instruction. I am currently creating a registry of products for a convention. I have been working my way through his notes, but I've come to the vague instruction of "Turn on the convention by going to the convention table and changing it to 1". Now I have no idea what this means so I went digging. Eventually I found my way to the Linked Table Manager, and I thought I solved my problem. It had my table name with a 0 next to it, so all I have to do is change it to a 1 right? Problem is, I don't see an option to change the number. I will include a screenshot of the page I'm on.

Any advice on what I need to do? Or to point me in the right direction?

[June7]

Duplicate https://www.accessforums.net/showthread.php?t=84441

[June7]

Interesting, I do not see a 0 (nor a 1) in my linked tables list.

Open the table in Datasheet view. What is the data? I suspect the instruction means to change value in field so that a convention record is 'activated'.

[Welshgasman]

Just open the table and change the value?

[nwebber]

The data is just a series of numbers associated with a product, and an auto-generated number as the primary key. On the Linked Table Manager, it has a "0" next to my dbo_OCA2021Convention. I imagine the instructions that were left for me wants me to change that "0" to a "1".

[Gicu]

As funny as it sounds I think your predecessor actually meant to rename the table "dbo_OCA2021 1" . Right-click on the table in the navigation pane (not the link table manager) and choose rename and replace the 0 with 1. Now the rest of the app should work as intended (assuming all the queries, forms, reports, etc. are using a table called dbo_OCA2021 1....

Cheers,

[pbaldy]

Welcome to the forum! I merged your duplicate threads since both had replies. In the future, please don't post the same question twice.

[kd2017]

parentheses*. Thoughts?

[nwebber]

So what I thought was a "0" was actual just an open close parentheses with nothing inside? Well that tracks I guess. As far as the naming convention, That was the requested name from the Marketing team, so I don't imagine that is what he means. I'll keep digging through our internal stuff, maybe there's a clue in there. I'll update this post if I find an answer.

Thank you for your assistance.

[kd2017]

Playing with a linked table name on my computer I can confirm that really looks like parentheses... Also, considering you were able to open the table in post 4 and view the data it's already "on".

I think they were talking about something else. What exactly are you trying to "turn on", do you know yet or are you just working your way through notes?

[nwebber]

The idea is that once I turn it "On", one of our sites will update showing it as an option to select, and then once they select it, they can choose from the list of numbers which product they are interested in. As I search through his notes, I wonder if he is referring to something in SSMS instead of Access...

[kd2017]

I don't envy your head ache. Good luck!

[nwebber]

UPDATE:

So it turns out there was another Linked Table called "Convention". As my predecessor created it, I assume that whenever he opened Access, it was always showing up for him by default. So what I had to do was find the dbo.Convention in ssms, and manually update it there, which did indeed have a "is Active?" field. Once I did that the site updated, and it's all resolved now. Thank you all for being a great soundboard.

[isladogs]

As stated, your screenshot just shows a pair of brackets. It should show the link database info in the brackets like that below:




I assume that empty brackets means your links are broken