MS Access permissions changed [Was: What happened?

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

MS Access permissions changed [Was: What happened?

Postby estrellasmc » Wed May 23, 2012 4:42 am

I just tried to modify a Microsoft Access table I had connected to OpenOffice Base. I had successfully done this in the past, but this time it wouldn't let me. I found the place where user permissions were handled and found that there was no user listed,that I couldn't add one, and that I couldn't modify the permissions. What is going on Has anyone else had this problem?
Last edited by RoryOF on Thu May 24, 2012 5:06 pm, edited 1 time in total.
Reason: Changed Subject as suggested by Eremmel, to help better searching (RoryOF, Moderator)
OpenOffice 3.3 on Windows 7
estrellasmc
 
Posts: 1
Joined: Wed May 23, 2012 4:37 am

Re: What happened?

Postby eremmel » Thu May 24, 2012 4:59 pm

Might it be possible that you do not see all info in Access tables when you have not the right permissions? I remember that I fixed once a access database permissions by taking it over to a MSAccess-MSOffice installation and fixed there the permissions and than took it back. The OOo Base interface is too generic to support you with this kind of issues. Never the less MS Access database with Jet Engine works nice with OOo according my experience.

P.S. modify the subject of your first post to be more specific: "MS Access permissions changed unexpectedly" So it is useful to others as well
It's Microsoft marketing that tells you computers are qualified for non-technicians
eremmel
 
Posts: 1041
Joined: Tue Dec 30, 2008 1:15 am

Re: MS Access permissions changed [Was: What happened?

Postby Villeroy » Thu May 24, 2012 7:04 pm

You are aware of the primary key that is required for editing any type of database table?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28536
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 2 guests