When I linked table, it ask me a password on 3 tables - this is a first

Question

Good morning,

I don't know what's going on, my back-end doesn't have a password, my visual basic doesn't have a password, I can access all tables but 3 that ask me a password while linking. I thought it might be a corrupted database so I create a new one and import all objects in the new database... still ask me a password for the same 3 tables... how can 3 tables only can have a password on them. I use Access 2013

Someone heard about such a things?

Claude

---

Claude Larocque

Answer 1

never heard of such a thing myself; am not that familiar with reserved system terms - could one name a table with a reserved word that causes this?? no idea....

I would use the copy table (without data) feature and see if that copy also triggers the PW - if so - hand build a new table;   and then write in the data to the new table.....

Answer 2

If there are any ULS systems involved, this can happen. If there are no ULS systems then, verify those three tables are in the BE you expected?

Otherwise the only other thing I can think of is Folder Permissions. You can try moving a copy of the BE to the desktop and test again.

---

Just takes a click to give thanks for a helpful post or answer.
Please vote “Helpful” or Mark as “Answer” as appropriate.
Chris Ward
Microsoft Community Contributor 2012

Answer 3

I don't know what's going on, my back-end doesn't have a password, my visual basic doesn't have a password, I can access all tables but 3 that ask me a password while linking. I thought it might be a corrupted database so I create a new one and import all objects in the new database... still ask me a password for the same 3 tables... how can 3 tables only can have a password on them.

I've never heard of such a thing.  Does it happen only when relinking tables that are already linked, or does it also happen if you delete the linked table from the front-end completely, and then create a fresh link to the table in the back-end?

---

Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

Answer 4

are you using Office 365 or a desktop  version of Access?

---

Warm Regards, Crystal http://www.AccessMVP.com/strive4peace * (: have an awesome day :)

Answer 5

Claude - 

one more thing you can try provided you can export the tables. Export them as text. That should eliminate all indices. Then import the text files into a new, blank database. Once you do that all metadata will be dropped.

Delete the tables from your existing database...the back end. And delete the linked tables from the front end. Compact FE and BE. 

Finally, import the tables back into your back end and set up whatever relationships you originally had.

---

Bill Mosca
www.thatlldoit.com
http://tech.groups.yahoo.com/group/MS_Access_Professionals

Answer 6

Hi Crystal,

Yes I have Office 365 and Access.

It is not only in 1 database, it is on several databases, on top of that if I am loging via TeamViewer at my Customer site, there is no problem accessing these 3 tables, however, if I upload the backend and frontend databases, then the problem is there on my computer.

I also notice that the Relationship are missing in the front end even if I relink the tables from my backend to my frontend.

Sound like a major problem!

Thank you all

Claude

---

Claude Larocque

Answer 7

Hi Claude,

the problem is that Office 365 requires you to be logged in, which is why you are getting prompted.  I believe, however, that you can use your 365 account to download the desktop version of Access and the problem will, hopefully, go away ... please let us know.

As for the relationships, the diagram will not be there as it is in the backend database, but if you put the tables on the diagram, you should see the relationships

---

Warm Regards, Crystal http://www.AccessMVP.com/strive4peace * (: have an awesome day :)