2000 Security Issue 'Cannot Read Permission On MSysAccounts'

Jan 24, 2008

i have an unsecured database in 2000

i open up a blank db with a workgroup file and then pull everything in from the unsecured

ta da, a secured database

but if i go tools>security>users & accounts it gives me

'Cannot Read Permission on MSysAccounts'

which has stumped me

the workgroup file is OLD, like and mda old, and it might be that it needs converting to a 2000 mdw, but i don't have permissions to do it

am struggling for more things to try to solve the issue, any thoughts are welcome



View Replies


ODBC Read Permission

Aug 17, 2007


I am using MS Access which has a ODBC link to a sql database. I find that the linked table can be edited in Access.
I would like to prevent editing in this Linked table. IS there a way?


View 1 Replies View Related

Access 2000 Security - Authenticate With Windows 2000 Server Credentials

Oct 24, 2005


I have a database that currently has security in place so that users input their own usernames and passwords to access the database. The users have recently been added to a windows 2000 server and I want to be able to use their windows 2000 server logon credentials to provide them with automatic access to the database. Is there anyone out there who knows how to set this up? It is a rather urgent request if you could get back to me either on this forum or via email


many thanks


View 1 Replies View Related

Is It Wise To Change Security Permission .....

Mar 20, 2007

When users are active in DB

View 2 Replies View Related

Access 2003 Security Permission Problem

Oct 19, 2006

I have a database, which contains linked tables to another database. The information held in the tables are mostly open for every permitted user but some of the table informations are restricted to a few user only. To manage all of this different permissions I created a workgroup, changed all the necessary things to become an administrator and run the security wizard to secure my database. Finally I want to give every single group the access it belongs to. And there is my problem.
I have a form which has a VBA code underlying which selects data from a table and two queries and where the user can set individual criterias. For me as an admin user this form works perfect. When I log on as a user I can't find out how to set the permissions not to receive the error message: "You do not have the necessary permission to use the 'MSys Table' object...." The user should not be an admin user and I already set the modify, update, delete, read, read design permission to the group. Nothing helps.
Please if anybody has an idea what I can try I really would appreaciate this help!
Thanks very much :)

View 1 Replies View Related

Limit User's Security Permission With Code

Sep 15, 2005

My db is secured using Access security but now find myself needing to code a little security work around if possible.

I have a form that has a subform. On the subform is a field named "Comments". The subform security only lets a particular group write to the fields it contains (including "Comments"). I have a new user that I need to allow to write to "Comments" but not to any of the other fields on the subform. I could make another subform with "Comments" only field and redo my security so that the original group can write to both subforms and new user can only write to "Comments" subform but I think it might be easier to code in that the new user is only allowed to write to field "Comments" in the existing subform. Every user logs into the db so I can get the user ID.

Is it possible to do this?

View 2 Replies View Related

Forms :: Apply Security Or Read Only Procedures?

Jan 22, 2015

How can i apply security or read only procedures to forms?

View 1 Replies View Related

Access 2000 Security Levels

Nov 11, 2005


I have produced a database in Access 2003 and saved it as an Access 2000 format. However when it is used on PC's with Access 2000, some (not all) users are getting messages displayed when they open the database that Access cannot open the database due to the Security Levels.

Can anyone tel me where I can find the security level settings on Access 2000, I've found them in 2003, but not 2000!

Can anyone help.



View 1 Replies View Related

General :: Security And User Read / Write Permissions - Access 2010

Jul 19, 2013

I'm a SQL Server DBA and have a few Access 2010 Db's to look after and occasionally have to make amendments to (as is the case today). I've been asked to apply permissions to certain users of the Access database whereby users in a group we're calling 'Viewer' only have read permission and users in another group called 'Writer' (original I know!) have both read and write permission.

The database is form driven (i.e. no-one directly accesses and amends the tables in the database), the file is saved with a .mdb extension.

I've played around with the 'Manage Users & Permissions' in the File Menu however these don't seem to do what I need them to and only result in having to input a user and password to access the database on start-up.

View 1 Replies View Related

Opening & Closing Excel 2000 Workbooks From Access 2000

Jun 2, 2006

I am opening and closing a series of Excel 2000 Workbooks using Access 2000 VBA and want this sequence to be able to complete without any human intervention.

However, there are 2 instances when this stops and waits for a human option to be selected:

1. When the spreadsheet is password protected
2. When the spreadsheet has automatic links I get the message:

"The Workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook?"

How can I code it so that in situation 1 it skips this file and in situation 2 it automatically defaults to do not update?

Any help most appreciated.


View 1 Replies View Related

Link/Transfer Data From Access 2000 To Excel 2000

Mar 27, 2006

If I have a report in MS Access 2000 generated based on the criteria selected of a project with work order "9999" with the labor costs, materials costs and the Totals of each crew1, crew2,... and I would like to have those expenditures populated in corresponding cel in Excel for each crew, HOW would I do it?

To think it out loud, could I create a button on a form, so when I select the criteria for the work order, and when I click the button, it should refresh/update the Exel file with the new data...?? How do I write VBA code for that...?

Please help...Thank you so much....

View 3 Replies View Related

Access 2000 & MSSQL 2000 Multiuser Problems

Aug 20, 2007

Hi everybody,

I have recently been doing a conversion for my boss for a access 2000 database (both front and backend) to a MSSQL backend.

I finished the conversion today (as quite a lot of the code / queries ran slow due to access running the queries locally rather than on the server). And tested it on my and my boss's machine with no problems so he gave the go ahead to update everybody to our new mssql 2000 backend with the modified frontend.

This is when the problems started; We had two different sets of forms for accessing one of our databases systems - the log system, one is the original dynaset based form, and the other is a newer set which uses snapshot views and preforms updates via queries. Nobody uses the old dyanset system apart from my boss and one of the administrative team as they have things on that window which they need to see. About 30 minutes into the release of the new database the system frooze up on my bosses computer and nobody could create a new log (the server was timing out). I assumed this had something to do with the old dynaset's creating locks on the table.

I offlined the database and kicked everybody out of the front end, turned it on again and tied again, this time banning everybody from the dynaset system. Within 10 minutes another computer frooze up, again with a timeout on the insert query. I discovered that after you had added a new log to the database it would timeout on all subquent additions (something it hadn't done during testing) . Further investigatiion showed it was the snapshot list window causing the error, so coded the add log window to close the list before preforming the insert query and then reopen it afterwards. This allowed my machine to make multible additions without flaw. So I released a new client to everybody. 15 minutes later it was timing out again, but this time there you could not even make one new record.

I checked for locks on the table though the server management table and couldn't find any for the Log table. I have restarted the SQL server box and with no avil. So I reverted our backend to the access mdb file and told people to use the old client.

I am at a complete lose to why this is happening, if anybody has had any expericences like this or knows the cause please tell me.

Some information on the database in question.

It was made as an access 2 database all intergrated into one file, then it was seperated into two files (frontend and backend). Upgraded to Access 97, then to 2000 before this final update to MSSQL 2000.

The log system has two main tables. The first is the log title / info table which links (one to many) to a log entry table. This problem only occurs on the main log table and does not appear to be reoccurring anywhere else within the database. The main log table has just under 18,000 rows in it.

Thank you in advance for any help,


View 10 Replies View Related

Replication Between SQL Server 2000 And MS Access 2000.

Nov 15, 2006

Is it possible to have the master datebase in SQL Server, the replica in Access format and still can sychronize them?

Thank you in advance.

View 3 Replies View Related

MSysTable Permission....

Dec 14, 2005

The programmer who built this access program is no longer here...Everytime I create a new Report, it works great for me...but the person I made it for ALWAYS gets the MSystable permission error....I have gone through the wizard to give them every permission available on the report and the query it is using...AND went and made sure permission was given on the SQL side of things as well...YET I still get this incredibly annoying error...that seems there is no real answer to...CAN ANYONE help?!!! even compacted and repaired the program...still no good....I know it will be something small, but I can not see it.

View 5 Replies View Related

Error-You Do Not Have The Necessary Permission..

Jul 12, 2006


I get this error when opening my MS Access database - You do not have the necessary permissions to use the ...[flie name and path]... object. Have your system administrator or the person who created this object establish the necessary permissions for you.

The database works fine on another computer, but every time I transfer it to mine (I am on a network), I get the above error. I have recreated the User-level security workgroup file, no joy.

Can you help?

View 7 Replies View Related

Access Permission

Jan 17, 2007

Hi there

Can i set permission on a single button in a access database form for specific number of users. And rest of the database is available for everybody ?


View 2 Replies View Related

Permission Problem??

Feb 7, 2005

hi, when i tried to use "update" i got this error, no problem with "select" . it is got something to do with the permission setting?? using winxp pro, ms acccess 2003.

Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/okl/topics/DC/Basic/VD_Q1_Result.asp, line 72

View 1 Replies View Related

Permission Problem

Nov 20, 2005

i have this problem if anyone can help me please,,

i have some databases in my server(dc) + the Microsoft Office Access Workgroup Information(secured.mdw) ...
when i open the database i get this error message
("You do not have the necessary permission s to use
the '\dcdatabases$systemsdecdec sharedec_wahab.mdb'
Gas Supplier.mdb' object. Have your system administor or
the person who created the object establish the
appropriate permissions for you.")

then how can i open the database?

View 3 Replies View Related

You Do Not Have Permission To Enter This Database

Oct 5, 2005

I get the above message when I try to open a database created by someone that no longer works here. I tried to create a new version of the workgroup information file and assume the permissions of the administrator, but I still cannot access the database. Any leads?


View 5 Replies View Related

User Permission Problem

Jul 17, 2007


I was in the process of setting up a new user on our database, when I think I inadvertantly changed my own permissions. As the owner & creator of the database I am now unable to open it up - am getting th following messag:

"You do not have the necessary permissions to use the 'NDatabasesGAB Contacts.mdb' object. Have your system administrator or the person who creatd this objct establish the appropriat permissions for you."

After rading another thread on this subject I hav amendd the security options for the database, by right-clicking & selecting properties and the Security tab, then adding myself as the owner - but this has not resolved the problem.

Does anyone have any other suggestions to help me get back into my database?

View 6 Replies View Related

Access97 Permission Problem

Dec 19, 2007

I bought a database about 10 years ago and still uses it. Since then we changed our address and need to update all the forms as the address is hard coded into the forms. When I tried to modify any thing it tells me I don't have the Permission. I tried to contact the programmer, but he's been out of business years ago and was unable to contact him.

How do I reset the permission on MDB? I tried Tools->Security->User/GroupPremissions and it only shows Admin user with "Read Design" checked on all object names. And if I check on any other permission it says I need administer permission.

I tried upvmsa2k.zip "Users' passwords viewer v3.2" and it shows admin user with garbled up password. Also tried MDWRecovery, but it says there's no user or password.

Your help would be greatly appreciated.

View 3 Replies View Related

User And Group Permission

Feb 5, 2008

I have put my database in a package using MS Access extension but the user and Group Perssion is not included to the package. Does some one know how to include the permissions too.


View 1 Replies View Related

Access 200 Permission Lockup

Feb 20, 2008

Either when copying from one db to another on my machine or running a db produced on that machine on a network, I get the message "the database has been placed in a state by user (my machine is called "Rat") that prevents it from being opened or locked". =Error 3734.
The security data says I am "Admin" and permission is set for Admin and Users. It has been doing this intermittently for a while and now does it all the time.
Follow up data
All databases are created, revised and run on home machine (Rat) and run on the office network.

The offending DB will permit internal design, editing , copying and will accept pasting IN of tables etc. from other DBs. But it will not allow copying OUT of files such as a table to other DBs even on the machine that created them. However it will allow copying and pasting of objects such as forms in visual form or individual query cells to other DBs.

Iíve carefully compared the Tools/Security/User & Group Permissions with a good running version of the DB and can see no difference.
Permission settings on good and bad DBs are:-
Permissions: Admin Object: Current DB
Checked: Open/Run, Open Exclusive, Administer.
Iíve also checked each individual filesí Permissions. The .ldb file, viewed with Word with the offending DB running on my office machine (Weasil), reads:-
WEASIL_ Admin_

The creating machine ďRatĒ uses the Account ďRichardĒ: but I have had few similar problems before. While revising the DB, I made 30 copies of at each stage along the way but saved carefully each design change and certainly did not deboot the computer without doing so.

Iíve tried the above procedure on my computer (Weasil) at the office, but got the same result. So itís not the computers or MS Access 2000 program. Somewhere along the line, perhaps, the DB got corrupted. It Repaired and Compacted OK but still has the problem.

View 4 Replies View Related

Advice For Security & Question On Built In Access Security

Mar 26, 2007

I've read and gone though quite a few of the scrips and examples for creating logins and security and i'm getting to the stage when i need to have good understanding of the different methods.

Some of the examples whilst create a user login do not really allow for security within the database whilst the build in security wizard would appear to offer that functionality.

I am thinking that I will use the Workgroup file and that method. My question is am i able to utilise the fact that if a person 'AdamA' logs onto the database which is built into the workgroup security file. am I then able to take 'AdamA' to populate a table which records actions by a user? (I can't seem to find any thread or book reference to doing this)

View 4 Replies View Related

Why Those Permission Differences Btw Access Files ??

Sep 1, 2005

Hi accessors,

I have 1 permissions related Q.

If I create msaccess db by calling the app through its icon, i get a db with following permission items :


but if I create it through rightclick> new> ms_office_access_application, I get a db with:

VS Developers(compNameVS Developers)

Why /the hell/ those differences btw the same kind of files ? :mad:


View 3 Replies View Related

Column Permission In Access Table

Jan 4, 2005


I have a table in Access database. I would like to set read only permissions to some of the fields/columns in the table. I do not want user to alter or edit some fields/columns in a table. Could someone give a solution for this?

thanks in adavance


View 2 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved