|
Query-based Combo Box -- No Permissions (?)
In an Access 2000 / 2002 db, a user from a group with
permissions to enter/edit data on all forms, and where all
querys are RWOP, I'm still having trouble with a combo box
fed by:
SELECT qrySpecies.SpCode, qrySpecies.CommonName,
qrySpecies.OtherName, qrySpecies.SpId
FROM qrySpecies
WHERE (((qrySpecies.SpCode) Not Like "any"))
ORDER BY qrySpecies.SpCode
WITH OWNERACCESS OPTION;
I get ...
|
5 |
5/25/2007 2:07:41 PM |
|
|
Default Admins Group & Admin User Account
Hi,
While logging in under Admin user in the Admins Group account, I did a
stupid thing by removing my Admin user account from the Admins Group account
upon creating some other new users with administrative rights.
After I exit and restart my Access, I realise I am unable to do any changes
to the users and groups accounts settings because these changes were done
using the Admin user...
|
3 |
5/25/2007 12:23:54 PM |
|
|
finding all the changes made to a table
I had a student enter data through a form, but the changes are not in the
table. Is there a way to observe all times the table was updated? I would
like to identify if the data was really entered and then revert the database
back to that date or copy the data from the table.
--
thank you - from the professor...
|
2 |
5/25/2007 11:20:15 AM |
|
|
Should Have Permission, but Doesn't (?)
In a secured, split Access 2000 / 2002 db, when I log in as
a member of a group that has run permission for all the
forms, I get a permissions error:
"Record(s) cannot be read; no read permission
on 'tblCountDetail'".
The forms are all based on querys with 'Run with owner's'
property, and all the combos are based on querys with that
property.
This user/group was working ok a few m...
|
6 |
5/24/2007 9:28:34 PM |
|
|
Compiling Problem
After I compile my database, events will not run the code i have made. Does
anyone know whay this happens? ex.
Private Sub County_Enter()
On Error Resume Next
County.RowSource = "Select Counties.County " & _
"FROM Counties " & _
"WHERE Counties.State = '" & State.Value & "' " & _
"ORDER BY Counties.County;"
End Sub
I made these combo boxes to narrow the the list of coun...
|
1 |
5/24/2007 9:25:01 PM |
|
|
ADP Security Settings
I have an ADP file pointing to a SQL Server 2005 DB. I'm looking to secure
the data in the tables. Currently everyone is setup as an owner through the
SQL Server Manager. All of the data in the application is pulled/connected
using stored procedures.
- Some directly through the form's data source in the properties
interface
- Other are dynamically constructed using VBA
...
|
1 |
5/24/2007 7:01:00 PM |
|
|
Moving users from one db to another
Hello -
I need to move the users and groups from one database to another, and I'm
looking for some help on how to do this (other than a lot of typing...).
Thanks in advance,
Jake...
|
2 |
5/24/2007 6:55:13 PM |
|
|
Security File (.mdw)
Please forgive me if this message is a little verbose. Is there a way to
link a specific "Security.MDW" file to ONLY ONE MS Access Database? I
created a secure database but when I close that database and open ANY OTHER
database I am still attached to the same security file. Once joined, the
security file becomes the default for ALL MS Access databases that open. Is
there a way to acc...
|
4 |
5/24/2007 6:00:02 PM |
|
|
Help....
Hello everyone, I work with an Access 2002 database at work which requires a
password in order to gain access to it... I was trying to see if I could
change the password to the database becasue someone was corrupting it. In
terms I locked myself out of it and now instead of asking for the regular
password (which works for everyone else) is giving me my ID name and a
password to put in un...
|
2 |
5/24/2007 3:56:45 PM |
|
|
Security Short Cut: Start In field
The properities of the short cut for the sercure database has a field called
START IN. What is supposed to be in there? The local folder for of MS
Access (c:\program..\Micro...\office11) or the folder on the server that
houses the database (\\server\databasefolder)?
I checked all my users and I have about a 50/50 spread of users starting on
thier local or starting on the server.
What a...
|
2 |
5/24/2007 3:45:53 PM |
|
|
Splitting in 2000/2003 environment
I am ready to split a database, but some computers have Access 2000 and
others have Access 2003. I have Access 2003 on my computer, so I need to
convert a database to 2003 format before I can create an mde file. As I
understand it, Access 2000 machines won't be able to use the file. I'm not
clear on whether I can create an Access 2000 mde and use it with Access
2003.
Joan Wild's site...
|
8 |
5/24/2007 2:12:27 PM |
|
|
Can't run Update Query
I have an access database that has an update query in it that updates a
linked excel sheet. Everything was working fine until the IT guys at work
got me a new machine. Now, I get an error that the sheet is not updateable.
When I just open the linked sheet and try and manually change the data or add
a record, I'm unable too.
I went to a co-workers machine that uses the same file and t...
|
2 |
5/24/2007 10:36:59 AM |
|
|
Linking to ACCESS Tables in unshared folder
I have three databases, one for the psychology department, one for the
supervisors out in the cottages (read only summary reports), and one for data
entry only for the cottage staff to punch behavior reports. The cottage one
is completely locked down so that all they get is a pop-up form and the data
goes into a hold table for appending into the main database.
We absolutely do not wa...
|
3 |
5/24/2007 8:27:44 AM |
|
|
localhost access to Access DB denied!
I am trying to run locally a web application. When I try open an Access 2003
mdb file, which has been defined in ODBC, I get the following message:
"Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] You do not have the necessary
permissions to use the '(unknown)' object. Have your system administrator or
the person who created th...
|
2 |
5/24/2007 8:07:37 AM |
|
|
Cannot update local DB using ODBC
I have a web application which accesses a local database via ODBC and it
gives the following error:
"Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object
is read-only."
How do I get around this problem?
Thanks ......
|
2 |
5/24/2007 8:07:26 AM |
|
|
Start Up Error
I am currently using Access 2003 with SP2. I have several databases and they
are all multi-user environments. However, I have one database that is only
used by two people (including myself) and when the other user is already in
it and I try to open it, I get the following error .....
"When attempting to open a database object in Design view, you may encounter
this error message. This ...
|
7 |
5/23/2007 5:05:02 PM |
|
|
Allow Special Keys
I have several databases that I have unchecked the "Allow Special Keys" and I
wanted to change one back so that it would allow the special keys and I have
checked the box again. However, even when I close out of the database and go
back in I cannot use the special keys. I have checked the options to make
sure it is still checked and it is, but it will not re-enable the
functionality.
H...
|
5 |
5/23/2007 1:53:01 PM |
|
|
Access Security Notice
I have a secure PC that I am using to design databases. I want ro create
links to pdf or other office documents. While I am designing I don't want the
security notices to keep popping up as they are annoying. I have turned
everything off in the trust center and added my folders where my links are to
my trusted publishers, and still when I click on a command button to open a
pdf, I get th...
|
1 |
5/22/2007 10:40:01 PM |
|
|
Lost .mdw file
Hi,
I created a secured Access (97) Database and I am the Admin And I had all
permissions. But I lost my .mdw file. I have written down My Username and
User ID. So How can I retrieve Data from my Database. How to created a new
mdw file?
Please Help me.
thanurahl@yahoo.com...
|
4 |
5/22/2007 10:29:28 PM |
|
|
permissons
I run a few databases on stand-alones. I was trying out some of the
options using the permissions wizard, etc - and now all of the
databases on the computer (including new ones) require a logon.
This is a real pain as my students sometimes use the machine. Is there
any way that I can remove the need for permissions and hence log ons?
...
|
2 |
5/22/2007 9:42:36 PM |
|
|
Can I time limit usage of my database?
Can I put a 'Use by' date mechanism in my database, such that once the
database goes past a particular date, it stops working?
has anyone any ideas on how to protect a database from unauthorised use?
...
|
2 |
5/22/2007 11:23:04 AM |
|
|
database protection
my application runs with a linked database placed in a network folder. i have
to share that folder with full permissions. it means that the security of the
database is at stake, anybody from any netwark location can damage the
database. can somebody suggest a solution? thanks....
|
2 |
5/22/2007 8:23:00 AM |
|
|
Are hippos really cute?
I think they are, but I want other peoples opinions too....
|
1 |
5/21/2007 5:05:01 PM |
|
|
Password in *
I have this code to protect a form when I press a command button. My question
is: When I input my password everyone can see my password, how can I input my
password and show "*****", for no one see my password?
Private Sub AddFuncionário_Click()
Dim strPasswd
strPasswd = InputBox("insert password", "restrict form")
'See if a valid entry made to input box
If strPasswd = "" Or st...
|
13 |
5/21/2007 3:58:57 PM |
|
|
error 0x80245003
When I start my pc I get messages at the right hand side of screen saying
windows defender needs to update. When I go to do this I am getting the
error message 0x80245003. I have tried going to cmd and entering various
information I was given, to no avail. Please could someone help me as I am
sure this is messing with my security. It is also saying that I don't have
anti virus software ...
|
1 |
5/21/2007 3:24:08 PM |