|
Access 2003 w/ User Level Security - NOT WORKING
Hello,
I have an Access 2003 that uses user-level security. Here's what I did...
1. Moved the DB and MDW to the directory on the Vista/Access 2007 machine
2. Added the directory to the Trust Center locations
3. Open database...
Issue #1: Access 2007 thinks my user has a password when it doesn't. A user
of the same name may have already existed - can this create a conflict?
Issue ...
|
3 |
3/20/2007 3:35:28 PM |
|
|
secured and unsecured dbase on pc
I've got a secured database on my pc and I've also got another database on my
pc that should be unsecured but when I joined the workgroup to secure the
secured dbase it also defaulted the other dbase to prompt for user/password.
How can I keep the security on the secured dbase while removing the unsecured
dbase workgroup file?
--
Todd...
|
4 |
3/20/2007 2:27:05 PM |
|
|
Problem deleting users from User Level Security
Hello. I'm using Access 2003 and have setup user level security. I haven't
figured out how to delete users who no longer should access the database from
the user level security.
I've tried going into the wizard, but when I select a user, the Delete
button is grayed out. I've also tried typing in the User, password, and PID,
but it will not let me delete.
I've also tried deletin...
|
3 |
3/20/2007 12:15:23 PM |
|
|
error 2450
When i try to open a form i get this error.
steps:
1. main menu - select a customer form
2. Documents button in the customer form - click to see a document
3. View additional button in Document form
4. select any document and click preview button in Document search
form
5. Document-Additional form opens
In database tab window,
i get this error when i try to open Document-Additional f...
|
1 |
3/19/2007 5:41:31 PM |
|
|
How to open the .ldb file and use the info within, current users?
Does anybody have some sample code to allow me to open the .ldb file of the
current database running the code. I am running ACCESS 2000, and using ADO on
a local database stored on a network shared drive.
I need to view a list of the current users logged into the database from the
currently open database. The intention is to allow only one user to use the
database at a time. If I have ...
|
4 |
3/19/2007 4:42:32 PM |
|
|
disallowing SHIFT Bypass
Hi
after a long time playing with disallowing SHIFT Bypass I decided to ask you
for help.
I did following:
1) paste function ChangePropertyDdl into separate module called Security
(function from recommended web site
http://www.mvps.org/access/general/gen0040.htm)
Public Function ChangePropertyDdl(stPropName As String, _
PropType As DAO.DataTypeEnum, vPropVal As Variant) _
As Boolean...
|
9 |
3/19/2007 8:56:08 AM |
|
|
Access 2007 Password not valid
I've created a accdb database in access 2007. I set encoding and password. I
can open database with my password, but cant compact, backup or decode. It
keeps asking for password and does not accept the password I open the dB
with. Just says not a valid password....
|
1 |
3/19/2007 12:44:25 AM |
|
|
Access 2003 requires password to create a new blank database
I have an issue where Access 2003 requires password to create a new blank
database. Also, when I try to open an existing .mdb file I'm prompted for a
password. My windows login is autofilled for the username. I tried my windows
logon password but no luck. I have all of the latest service packs and
patches. Any idea what could be causing this?
...
|
4 |
3/17/2007 7:10:28 PM |
|
|
Security Massage
If the popup massage below appear (hopefully appear) what should I do to
solve this problem..
[IMG]http://i29.photobucket.com/albums/c293/mzkdee/security-mdb.jpg[/IMG]
alternate link
http://i29.photobucket.com/albums/c293/mzkdee/security-mdb.jpg
...
|
2 |
3/17/2007 6:24:32 PM |
|
|
Cross Post 'Security - DAOVBA': Updatiung Secured Back-end in code from Front-end in Runtime environment (A97)
Sorry for cross post folks - just realised I was probably in the wrong
group!
Hi Folks
I have been using a technique where the front-end checks an update table
that indicates the Fields, Relationships and defaults etc to be updated in
the back-end, and goes ahead and makes the relevant changes.
However, two things have changed:
1. The app is now in runtime and MSAccess is not avail...
|
1 |
3/17/2007 2:20:36 PM |
|
|
Security problem
HI...
I had set security & password for my access forms,queries etc.,.Now, I need
to remove the security. I tried to remove that. But, I couldn't..
The following errors shows often..
Run-time-error '-2147467259 (80004005)';
The database has been placed in a state by user 'Admin' on machine 'GOVIND'
that prevents it from being opened or locked.
Can anybody pls solve this problem..?...
|
5 |
3/17/2007 4:47:21 AM |
|
|
runtime error 2450
I have a preview button(cmdbutton) in a form. when i click this button
it suppose to bring a different form( i call this mainform(check the
below code)). But that didn't happen. so i checked Mainform code and
had a problem on this line.
CurrentDB = Forms![MainForm]![subform].Form![DatabaseName] with
runtime error 2450 msg.
When i output CurrentDB and it was showing ""
but ssal displayed the...
|
2 |
3/16/2007 9:25:16 PM |
|
|
Remove user permission to edit table records.
I've locked users out of a form that restricts them from selecting an
"approved" option status on a record field. However, if they go directly to
the table they will be able to edit this field. I tried to configure user
permissions on table but no luck. Any helpful tips on how to do this?
Using Access 2000
--
FL...
|
1 |
3/16/2007 4:54:20 PM |
|
|
access security permissions over a network
I have set user and group permissions on one database on one networked
machine on the domain but would like these to be applied over the network on
all machines is this possible? and how, does anyone know?
Server is on server 2003 computers on the network are Windows 2000 and XP
Pro and all have office 2003 pro. total database users 60 ...
|
4 |
3/16/2007 3:38:36 PM |
|
|
WRKGADM.EXE
Where is the WRKGADM.EXE file located in Access 2003, I did a search on the
users PC and I can find it...
|
17 |
3/16/2007 12:43:29 PM |
|
|
logging in to an access db
I was given a user name and password to login to an access 2000 db, however
when I open the db I don't get a login screen pop up. How do I get the login
screen to pop up?
Dave
...
|
7 |
3/16/2007 12:33:20 PM |
|
|
Gaining exclusive control of the Database...
We have a DB that is used by around 20 users.
My problem arises when I need to make a change, and I can't seem to find who
is still in the DB. Is there any way for me to find out who it is, or to
kick them out?
Thanks,
Ricky Painter...
|
8 |
3/16/2007 8:26:44 AM |
|
|
runtime error 2450
I have a preview button(cmdbutton) in a form. when i click this button
it suppose to bring a different form( i call this mainform(check the
below code)). But that didn't happen. so i checked Mainform code and
had a problem on this line.
CurrentDB = Forms![MainForm]![subform].Form![DatabaseName] with
runtime error 2450 msg.
When i output CurrentDB and it was showing ""
but ssal displayed the...
|
1 |
3/15/2007 8:58:12 PM |
|
|
runtime error 2450
I have a preview button(cmdbutton) in a form. when i click this button
it suppose to bring a different form( i call this mainform(check the
below code)). But that didn't happen. so i checked Mainform code and
had a problem on this line.
CurrentDB = Forms![MainForm]![subform].Form![DatabaseName] with
runtime error 2450 msg.
When i output CurrentDB and it was showing ""
but ssal displayed the...
|
1 |
3/15/2007 8:46:13 PM |
|
|
programmatically delete user in group
Hi,
I am trying to delete a user from the group but I always
get a data type mismatch in - grpUsers.Users.Delete usr ?
Dim db As Database
Dim ws As Workspace
Dim usr As User
Dim grpUsers As Group
Set ws = DBEngine.Workspaces(0)
Set grpUsers = ws.Groups("Admins"
Set usr = grpUsers.Users("userTwo")
...
|
2 |
3/15/2007 5:51:20 PM |
|
|
PLS HELP: Shared use of Access 2003 database
Im having a Access 2003 database on one of XP PRO PC.
I have shared the folder on those PC in which is this mdb and give
read-only share rights to 5 users. Those users can open a database in
read-only mode ONLY when a user on which PC is a database keeps this
database closed. Othervise, read-only users cannot open database -
they are getting error:
"Could not lock file"
PLS HELP !!!!!
...
|
2 |
3/15/2007 5:46:12 PM |
|
|
How to get list of tables within an MDB via ODBC
(Yup, first-time poster here. Ill try my best not to embarass myself)
OK, the thing is this. I need to get a list of the tables/queries/reports
within a just-delivered Access2002 file from within my MFC code (utilizing
MSA-ODBC). I get dozens of these files a day.
Ive got my MFC code tuned perfectly to do what I need, but there is a series
of keystrokes that
still haunts my brain.
...
|
1 |
3/15/2007 3:39:54 PM |
|
|
More than one user cannot open access db
Hi,
Up until a month ago all was well, all our users could open a access db with
no security settings. Currently a user can open the file and a .ldb file is
creating showing computer name and username.
The db is located on a Terminal server which is access from outside the
network. Any ideas as to why only one user at a time can open the db.
cheers
M...
|
1 |
3/15/2007 2:43:05 PM |
|
|
user permissions in access 2003
I've asked this question before but I apparently did something wrong. I've
got a secured dbase and one of the groups is called "Full Data Users". All
the users that will be entering, editing, deleting data are located here.
This works fine but I'd like to restrict each of them from accessing each
others information in the data entry form (where they enter, edit, delete
data).
Descr...
|
2 |
3/15/2007 9:28:11 AM |
|
|
Untrusted Publisher Warning
I'm currently using a file that was created by a co-worker and used on a
networked drive. The file format is Access 2000 but I'm using it in Access
2003. The drive that it's stored on was recently moved to active directory
and ever since then I've been getting a untrusted publisher warning. It just
says "Are you sure you want to open this file?" The unstrusted publisher part
is bolded...
|
2 |
3/14/2007 5:20:06 PM |