|
mc access
we recently converted to ms office 2007. somehow in the process we lost our
individual permissions in our access db. users can still access the db but
can only view the data. no one seems to have the rights to edit anymore and
we don't even seem to have the ability to give out rights. how do we get
the permissions back? and if they have to be reassigned how to we get
someone to be ...
|
2 |
11/8/2008 3:24:20 AM |
|
|
password recovery for MS Access DB
My problem lies in the fact that a manager here would like some information
in a MS Access db which has a password although it has been long forgotten so
I am also unsure what version it was created in. Are there any tools that
you recommend for 97 or 2000 or 2003? I will try each until it works
although I am more convinced this was created in 2000 not 97 or 2003. Thank
you....
|
2 |
11/7/2008 6:49:01 PM |
|
|
Cannot open Microsoft Jet Engine Workgroup Information File
Hi all.
I've searched this newsgroup for similar postings and they all seem
to
be under a slightly different scenario than what I'm experiencing.
I have an application with my own User Security file (BB.MDW) which
is
used to access several secured access databases. The workgroup file
resides in the same directory as the .mdb files with a different name
than the .mdb files.
What...
|
1 |
11/6/2008 7:10:42 PM |
|
|
Allowing people to only enter data into a form
I am new to Microsoft Access and have recently made a simple database using
Access 2003. The Database is fine up and running and all works ok, but i
need to allow others using to input data into one form only, so that they
don't interfere with the Tables. what i am hoping can be done is that when
anyone else opens the database it displays the form stright away, they input
the data and ...
|
3 |
11/6/2008 2:51:00 PM |
|
|
Workgroup Administrator
Workgroup Administrator does not appear to be available in Access 2007. How
can you join a Workgroup (System.mdw) in this version, which I know was
available under Tools_Security in previous versions.
Thanks for any help
...
|
1 |
11/6/2008 2:01:02 AM |
|
|
Remove or disassociate a mdw
Hi all, is there any easy way to just unjoin, from a mdw file that is
associated with my database? I have made several, but i work for a very
large orgainization and someone from ISD ??? says they didn't do it (create
this nightmare for me) created an mdw file that has more than the default,
all users are admin mdw. I really doubt there is a simple solution or it
wouldn't be much of a...
|
4 |
11/5/2008 4:20:06 PM |
|
|
Extra DBs created
We have a DB that I secured using the wizard a few months ago. Over time I
have had to add, delete or change a few of the user accounts.
I cannot pin down when or why, but in the folder where the DB is stored
extra dbs have been created. They are all named db1, db2 etc. We are now at
db29.
I am not too familiar with Access and the security side effects. Can
someone explain why ...
|
3 |
11/4/2008 7:25:01 PM |
|
|
No more double-click code access?
I am trying to come to grips with the numerous changes in Access 2007. One
of these is that double-clicking a control does not open it's OnClick event
routine, even if the VBA window is open.
Can this functionality be enabled, or is this another irritating security
feature from the people who claim to be providing enhanced productivity every
time they take functionality out of Office...
|
5 |
11/4/2008 1:28:18 PM |
|
|
Compile Codes
I have a lot of VBA codes in my database
but some of it are just pasted from examples
or imported from download samples.
I want to convert my .mdb to .mde
but as i convert i need to compile my codes.
now the issue is there are some errors on from pasted or imported codes but
i dont know how to fix them. can anyone give me a suggestion on how to
manage this errors?
although there are c...
|
3 |
11/4/2008 6:54:00 AM |
|
|
Security warning: unsafe expressions are not blocked
I am getting a Security warning: unsafe expressions are not blocked when
users are trying to log into the Access 2003 database through the Citrix
Server. Any suggestions on how I can eliminate that?...
|
3 |
11/4/2008 6:51:00 AM |
|
|
Oracle ODBC DRIVER CONNECT
Hi I have a database that have different external table sources. Therefore I
have to enter my username and password for the 'Oracle OBDC Driver Connect'
for every single table. I Don't want to 'Save Password' when linking the
tables this databse has many users.
Are there any other ways that i can enter and remember my username and
password until i close the application. cheers...
|
1 |
11/3/2008 12:17:01 AM |
|
|
Access 2000 multi-user security
I have recent designed a Access database on the server in my office and am
trying to set it up for simultaneous multi-user access and workgroup
security, but have been unsuccessful. When I setup security access from one
workstation, subsequent use of the database from that workstation, prompts me
for a logon and password which was previously successfully setup at the
workstation. If I...
|
2 |
11/1/2008 6:17:00 AM |
|
|
can't log in to any of my databases
I have Access 2003 set up on my home machine (I am the only user). Recently I
opened a database which had security set up on it, and since then I am unable
to open any database. I get the security logon screen with my user name and
looking for a password. I didn't set anything up with a password. I've tried
every password I've used for the past several years to no avail. What's the
best ...
|
5 |
10/30/2008 4:18:04 PM |
|
|
Log In
hi,
I have my database i want to share to some of my colleagues for updating.
i dont want to convert it to MDE because it is not finalize yet but is
usable now.
i want to share my database to some of this users and i want to create
users account.
what would be my first step to this? can anyone guide me or give me some
advice or link for any notes that i can read from.
thanks..
...
|
9 |
10/30/2008 3:13:01 PM |
|
|
Share a database
Hi there,
I created a database and i would like to share it with multiple users. This
database will be savade in a public drive in our network and obvious all
intendent users have access installed into their machines. Two groups wil be
using this database simultaneously, production (creating new records) and
final QC inspecting (retriving records already saved in the that table). What
...
|
5 |
10/30/2008 3:36:50 AM |
|
|
customizing input boxes
How can I change the format of a input box?. The password command I applied
to control my form worked fine, but shows a BIG input form; can I change the
size of that input box?.
--
Max Ortega...
|
1 |
10/29/2008 4:30:05 PM |
|
|
User level security - help needed
I'm using access 2003 and am really struggling with creating user level
security.
The database in question needs 3 levels of access;
1. General User - can open and use specific forms (3 in total) to run
queries and filter data, but only have read only access
2. Managers - can fully edit information (apart from delete records), and
only open and use specific forms (about 5)
3....
|
2 |
10/29/2008 3:20:21 PM |
|
|
Access 2007 Password protect - locked out of a report now
I created a database password. Everything seemed fine until I tried to open
a report and now get the error message "not a valid password". The other
reports seem fine but for some reason this one is locked up. Help please....
|
7 |
10/27/2008 8:46:01 PM |
|
|
Access 2003 allowing users to view only certain records
I am new to the community, so please let me know if I am following proper
etiquette.
I am working wth Access 2003 and am developing a database so managers can
submit salary increase recommendations. I plan to have one table of employee
information including salaries, who the employee reports to (manager), and a
blank field in which a manager can input a suggested increase. I then plan...
|
7 |
10/27/2008 7:13:05 PM |
|
|
Returning current user from SQLServer
I have converted my Access 2007 back end to a SQLServer and am trying to
return the current user back to the application. Unfortunately if I use the
built in function CurrentUser is only returns Admin which is from Access and
if I try to use the TransactSQL function CURRENT_USER in a SQL Docmd.RunSQL
statement (Select CURRENT_USER) Access errors and says it is looking for a
SELECT, INSE...
|
15 |
10/27/2008 12:06:10 PM |
|
|
New virus "brastk.exe"
I am getting a message from my antispyware software saying that "brastk.exe"
is on my PC. When I try to delete it, irt comes up with the message "Access
denied ..".
Is this a new virus?
How can I delete it?...
|
4 |
10/25/2008 10:22:06 PM |
|
|
How to creat user account and give limited access
I have created Students Database using tamplat, now I want to creat some user
account and give limited access to the data. Like I want Mr. John to Enter
Data but He should not edit any data in that database and I want Ms. Lora to
have full access to the database.
Please note I dont have any experience in SQL Server.
Thank you
Shams...
|
2 |
10/25/2008 11:00:00 AM |
|
|
modify design subdued
after following the instructions from Microsoft support on how to secure a
database (backend), I am seeing that permissions for "modify design" for the
current database is subdued and I am unable to link it to the original front
end.
...
|
1 |
10/25/2008 10:07:12 AM |
|
|
access 2007 add-in permissions
I am trying to install an accda add-in file. I get an error that i do not
have sufficient permissions to install. The security tab of the file says I
have complete control. How do I get sufficient permissions? This is on an
individual PC and not a network....
|
3 |
10/24/2008 2:46:01 PM |
|
|
how to backup through VBA code in Access 2007?
I want an expert's advice to take data backup through VBA code in one of ny
forms. Please help....
|
3 |
10/24/2008 2:21:00 PM |