|
How to change specific user privileges in Access that uses .mdw fi
Greetings to all
I would appreciate you help on the following:
I have inherited an access database implemented in MS-Access 2000 and
currently users are updating through MS-Access 2003. The .mdb file is based
on security .mdw file. I can see the privileges of each user for each form
through the security "Users and Groups" permission.
The problem is I don't know how to update it?
...
|
2 |
3/14/2007 5:17:07 PM |
|
|
Permission numbers of containers.. please help :(
I am really confused with this one..
I have produced the following and I would like to know what is the meaning
of it :
MSysDb document
-------------------
Permissions : 393230
AllPermissions : 393230
UserDefined document
----------------------
Permissions : 0
AllPermissions: 65536
-----
what does those numbers mean?
thank you in advance
...
|
1 |
3/14/2007 8:47:17 AM |
|
|
disabling shift key
How do I go about disabling the shift key function for opening up a secured
dbase at login so people can't view forms, reports, queries, etc? Also, if
I do this how will I be able to make modifications and such afterwards? Is
their some kind of back door that can be created? Please be descriptive with
explanations since I'm no expert.
--
Todd...
|
2 |
3/14/2007 8:12:02 AM |
|
|
multiuser security on the network
I have questions about setting up a secured database for multiple
users on a network. This database will have several
groups and appropriate permissions for groups.
I have been able to set up the permissions so the users in
each group can access only the appropriate data. But I
also want to set it up so each user has to log in. I have
set up passwords for test users, put secured.mdw and t...
|
2 |
3/13/2007 8:53:15 PM |
|
|
Access 2007 usergroups
I understand there is no user security in 07. What is the best way to create
user mgmt? I have created a login dialog and want to track modified
notes...how do i do this in 07?...
|
1 |
3/13/2007 8:01:34 PM |
|
|
Visible tables become hidden; how to access them?
This string began in the "Programming" section under the name "Help find lost
taables!".
One of my users suddenly couldn't open her application, and sent me her
app_be.mdb file. I discovered that about 1/2 of her tables were not listed
in the Database form. With help, I found that the table names can be seen by
checking the "System Objects" checkbox in the Tools|Options|View page
...
|
9 |
3/13/2007 6:20:39 PM |
|
|
Security question
Is there a way to programmically view what security grooups are assigned to
which objects?
Also, can the security on specific objects be changed through programming?
I deploy a front end database to various offices throughout the company and
often have to rebuild the security after the database is deployed, it would
be really handy to be able to print out what the groups are and who h...
|
12 |
3/13/2007 4:46:27 PM |
|
|
Accessing Access database from a 2003 server
Hi I have a access database that hosts part of a webpage system. Currently
the web sites are hosted on a windows 2000 server and connection is working
correctly. I am migrating the web pages to a new windows 2003 server but I am
getting the following error when trying to connect back to the windows 2000
server that hosts the database use an ole connection string.
Microsoft JET Database ...
|
1 |
3/12/2007 2:30:08 PM |
|
|
How do I undo security in ms access?
I chose user-level security on the db I created. Now I cant open even a new
db as it's prompting me for password which I didn't remember inputting. My
colleagues can still access the db in our lan so I guess it could be my lan
id. I supplied my lan id and pssword but it wont open. How do i gain my
access back?...
|
7 |
3/12/2007 1:20:30 PM |
|
|
Group By query
I have a table as shown below
TABLE NAME:BAL
Account Date Balances
OTC 01-Jan-07 1000
OTC 02-Jan-07 6000
OTC 03-Jan-07 3000
OTC 04-Jan-07 4000
OTC 05-Jan-07 5000
ICT 01-Feb-07 2500
ICT 02-Feb-07 3000
I want to extract the row which has the latest date with corresponding
balance from table BAL
Result expected is a...
|
2 |
3/10/2007 11:16:05 PM |
|
|
Determining permissions of objects
Is there a way to be able to see what security groups are assigned to which
forms, tables, queries, etc? I would like to be able to code this into my
application and print it out. ...
|
1 |
3/9/2007 10:28:38 PM |
|
|
Importing access data from word
I use an access database, to which i connected a new workgroup file. This
works just fine, giving some of the persons in the organization read-only
access and just those who need it possibility to change data and design. Here
comes the problem:
When i try to use data from access in a word fil, for instance to print
labels, the database cannot be opened. I am told that i am not allowed to ...
|
3 |
3/9/2007 10:23:13 PM |
|
|
User and Group Permissions Problem - Access 2000
Hi there
I have designed a database which other people will access, so wanted to make
some forms read only for some people.
I decided to use the security wizard to enable User and Group Permissions.
This worked fine. However, I have since found that every database I open now
has the login box pop up (this is a side effect I didnt envision). On top of
this if I move my database to a...
|
3 |
3/9/2007 10:03:28 PM |
|
|
track what users entered
My dbase is secured and I'd like to be able to see who entered records in the
database. Is it possible to add a field in an underlying table to show who
entered a new record for that table or who last modified a record in the
table? I guess it would be like adding a date/time stamp in a table field:
now() that shows the date and time a record was entered. Help!
--
Todd...
|
6 |
3/9/2007 9:56:13 PM |
|
|
How do I create a Header in Access on a query?
Help me Please...
|
2 |
3/9/2007 9:34:27 PM |
|
|
Security
Is there a way to get my Database to only open for users of the workgroup I
created. I created a database and a workgroup, but some people are able to
log in as an Admin without even joining the group....
|
5 |
3/9/2007 6:30:07 PM |
|
|
splitting a secured dbase in access 2003
I secured my dbase and would now like to split the dbase into FE and BE.
I've seen some instructions that suggest splitting it manually. The first
step says to copy the dbase and this will be the backend. Then it says to
open the backend (copy) and delete all objects except the tables. Problem is
that when I try to open the copy to delete the other objects I can't access
the dbase, i...
|
4 |
3/9/2007 5:01:34 PM |
|
|
Open xp secured db in 2007
TIA:
How does one open a secured XP database (has MDW file) in Access 2007. I
understand 2007 doesn't have user level security but MS says it should work.
I can't figure out how to tell Access 2007 to read the MDW file (no workgroup
admin).
Thanks for any help.
Joel
...
|
3 |
3/9/2007 3:23:28 PM |
|
|
Admin access denied
I have a module in the front end of my split, secured DB that shows who
is logged into the DB at any given moment:
Sub ShowCurrentUsers()
Dim cn As New ADODB.Connection
Dim cn2 As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim i, j As Long
cn.Provider = "Microsoft.jet.oledb.4.0"
cn.Open "Data Source=g:\MyDirectory\MyDatabase_BE.mdb"
cn2.Open "Provider=Microsoft.JET.OLEDB.4.0;" _...
|
2 |
3/8/2007 9:38:05 PM |
|
|
i am locked out of my account - this includes MSN!!!
someone has changed my password and security question!!! i didnt set up an
alternate email address what can i do?...
|
2 |
3/8/2007 9:28:52 PM |
|
|
Access to personal forms
I have a DB that contains personal data for members of a rescue team. This
infomation is everything from personal data to training data. I am
attempting to add UN & PW for each person so that they can view training data
(read only), and be able to change their personal contact information. I
have built the data change form, but I am not sure how to allow members to
only see their spec...
|
4 |
3/8/2007 2:18:14 PM |
|
|
Setup data security in Access 2003
Hello,
I am planning to start creating an Access database 2003 and would like some
suggestion on how I should setup the security. Any advice is appreciated.
I can only think of two ways. Please let me know which would you sugguest.
1) Design the database with tables, forms and reports, then apply security
(access level right) to the database, then split the databse into FE & BE.
Create ...
|
4 |
3/8/2007 8:20:38 AM |
|
|
Cannot Save Macro Security Setting
Hello
I have a PC with Office 2003 installed and sp'ed currently. I'm logged
on as administrator. In Access, Tools-Macro-Security, I have changed
setting to Low. (So macros in application will execute). Then I get
warning about Sandbox mode, I select No do not block unsafe expressions
(yes doesn't seem to matter either) Exit out and start Access again.
The setting has reverted ba...
|
1 |
3/7/2007 5:00:54 PM |
|
|
HELP! CAN'T ACCESS DB AFTER OFFICE RE-INSTALL
Hi guys,
I have a weird problem that i hope you guys can help with.
I recently had virus on my work PC and had the PC formatted and everything re-
installed from scartch. I was originally on MS Windows 2000 but now have
Windows XP installed. I have both Access 97 & 2000 installed, as was the case
before my PC got formatted.
Before my PC had been formatted, i had created an application with...
|
1 |
3/7/2007 11:55:30 AM |
|
|
IE6 calls 127.0.0.1, "cannot find website"
Hi, someone worked on my mom's computer and now when you click on any
site from the IE6 Favorites it calls local host and posts, "cannot
find website" or some such 404 type message. The only site that
connects is her health insurance company site. If you type in a
www.whatever.com address it does the same thing too.
Afterwards the hour glass mouse icon is displayed in the upper part of
IE6. ...
|
2 |
3/6/2007 11:36:01 PM |