|
CompactRepair on a secured Access db
Hello all,
Is there a way to run the CompactRepair method on a user secured database?
This code works fine on an unsecured db but not on a secured one.
VB6.0 code...
Dim strSource As String
Dim strTarget As String
Dim blnLogfile As Boolean
Dim blnRet As Boolean
Dim app As New Access.Application
strSource = "C:\database\Secured_db.mdb"
strTarget = "C:\database\Repaired_db.mdb"
blnR...
|
8 |
10.08.2006 13:32:35 |
|
|
NT Login
I apologize if this has already been posted. I have a database that multiple
users will need to access. Is there a way that I can set up my database to
automatically display/give permissions what is assigned per Windows/NT Login?
FOr instance, I want to be able to make changes, redesign, add and delete
information, but I don't want my team member to be able to redesign. I also
want non-t...
|
1 |
09.08.2006 20:29:11 |
|
|
Encode/DeCode same as Encrypt?
Hello:
All of the documents I've read on Access 2003 states we can encrypt data in
the database and I should look for the Tools/Security/Encrypt Data option.
However, I don't see that option, but I do see a Tools/Security/Encode/Decode
database. Is that one and the same or does it serve a different purpose?
Thanks...
|
3 |
09.08.2006 19:52:49 |
|
|
multiple users
We recently moved an Access database file from a Win98 machine to our main
File Server (Windows 2000 Domain controller). When on the Win98 machine more
then one user could access the db at the same time. Now only one or two can
at the same time. Not always the same users can access it at the same time. I
tried it when I first moved the file to the DC and three or four could get on
but no...
|
1 |
09.08.2006 18:21:02 |
|
|
Snafu 2
This seemed worth a separate post.
I went through the wizard once more, this time using a tutorial from a text
book. I created one admin user, myself and one Full Permissions for a user.
This time I don't even get a login dialog. I am told "You do not have the
necessary permissions..."
The good news is I can still use all my other databases.
This is why I have given up on usi...
|
4 |
09.08.2006 17:49:42 |
|
|
MDW lost all users access
I use a mdw that I join into all my Access databases at work. The problem is
there was an Access database that everyone uses that is in production. I had
to make changes to some forms and reports, so I made a copy of it, and moved
the copy to a different location for development and testing. The copy used
the same mdw as the production database. Everything worked fine in testing,
but...
|
8 |
09.08.2006 17:45:14 |
|
|
Habilitar el servicio de noticias NNTP en ISA 2004
saludos:
alguien podría ayudarme a configurar la regla en el isa 2004 para que
algunos usuarios puedan ver los grupos de noticias, sin necesidad de tener
instalado el cliente isa 2004.
gracias.
Gustavo
...
|
1 |
09.08.2006 17:34:33 |
|
|
Security Snafu
I'm a security novice in Access. I was experimenting with setting up Groups
and Users and from one PC at least I now cannot open ANY databases. I get
asked for user name and password no matter which database I try to open. I
can open these same databases from my alternate PC though, except for the one
I was actually trying to secure. I have restored the usecured back up I
created...
|
4 |
09.08.2006 14:32:43 |
|
|
Report won't run, says another user is currently running these rep
A user was running a report from Access and the server crashed while she was
in the DB. Once the server came back up, she went back into run the report
and got the message "User: %UserName% is currently running these reports.
The report was setup at %date/time%. Please try again later. If it has been
an abnormally long time, Contact the user or support to see if they are truly
runnin...
|
1 |
09.08.2006 12:40:02 |
|
|
Windows 2003 User Share
On a windows 2003 server, is there anyway to see when (date and time) a
certain user was given access to a network share? ...
|
2 |
08.08.2006 18:31:54 |
|
|
How do I remove my security.mdw file from my database?
I ran the MS Access 'User Level Security Wizard' on our in house
database. My manager did not like the users having to login. He hates
the login screen and wants the users to be able to access the database
again by simply clicking the MDB file.
Does anyone know how to remove the users/workgroup level security?
that mdw is killing me, my users do not use passwords anyways.
Please Help!
...
|
3 |
08.08.2006 16:31:00 |
|
|
Re-enable Shift
Good Afternoon,
I have disabled the shift button when entering my database. Well now I need
to add some more customization to my custom menu and can't access it. Is
there a line of coding or something to that effect that I can put in a module
or something to re-enable the shift button. Thanks.
--
Message posted via http://www.accessmonster.com
...
|
3 |
08.08.2006 13:47:47 |
|
|
Query using 'start' & 'end' date parameter
Hello,
i've created a query that produces all the data held in my database and
i've set up a parameter - 'Between [Enter start date] and [Enter end date]'
to return only the data received between two specific dates however, when i
run the query it still returns all the data held in my database, not the
dates i am requesting. Can anyone help at all?
...
|
3 |
07.08.2006 19:02:21 |
|
|
Macro Security
I am rolling out an appliucation with Access ADE and I am trying to implement
TC's workaround for the Macro security Warning:
dim o
set o=createobject ("Access.Application")
o.automationsecurity=1 ' set macro security LOW.
o.opencurrentdatabase "full path to your database"
o.visible=true
o.usercontrol=true
set o=nothing
However it seems that you cannot use CreateObject in a runtime ...
|
1 |
07.08.2006 16:15:01 |
|
|
Digital Certificate for runtime installs. (Not Self Cert)
I was wondering if anybody knows the best place to get a digital certificate
for "commercial" use. NOT USING SELF CERT...
|
23 |
07.08.2006 14:57:01 |
|
|
*** Urgent Retrieve UID
I am relying on Sql Server Security for linked tables in Access.
Now I have a need to know the UID of the user logged on. How can I get it?
Based on this UID, I want to restrict access to certain records.
Thank you,
-Me
...
|
5 |
06.08.2006 13:52:17 |
|
|
deploying secured database shortcut
Hello,
I have a secured MS Access db I would like to deploy as a demo. I have
tested it on a few machines and it is successful, but I have one problem: I
have to modify the shortcut path for the user's machine every time I install
the files. I would like to give users a CD and have them simply copy the
files to their own PC. The shortcut seems to be the only problem I think.
Any sug...
|
2 |
06.08.2006 04:28:12 |
|
|
Windows XP2 Login Problem
Since I have ghost this workstation running windows xp Profesional, I am
getting this error message" The Local Policy of this system does not permit
you to log on Interactively".
I can sign in as Administrator, other user can not sign In. This in domain
group not workgroup. If some can help me I will be very much appreciate.
Thanks
Q...
|
3 |
06.08.2006 01:43:20 |
|
|
Can you access the security user signons using a query?
I have an application that the user must enter their specific code into every
record they touch. Is there a way for me to program the application to look
at the security data and pull that information into a regular form?...
|
3 |
05.08.2006 20:03:01 |
|
|
Security has gone wild.
I am having some huge problems with my security.
For some reason security and all user names and passwords work fine on my
computer. However, when I go to my users computers things aren't working
correctly. The users can only see the form header of each form, the detail
section is not visible. And I have a query that is used for data entry and
the data entry portion is not working. It wi...
|
3 |
05.08.2006 13:58:01 |
|
|
New Post - Owner deleted - No backups, nothing!
Joan Wild gave up! Can anyone else help me?
Database (MS Access 2003) That someone deleted the designer of the DB.
No one knows anything, but I do not know enough about it to hack into it. I
have asked for Network Admin rights to the folder it is in and all files in
that folder.
Still waiting for those rights.
I have rights to the DB, but can not even look at the macros. I can l...
|
11 |
05.08.2006 00:37:53 |
|
|
Can one user be joined to multiple workgroups at the same time?
I have several databases that are secure for which have different workgroups.
And sometimes a user needs to be able to work in more than one of these. Is
there another way besides unjoining from one database and joining another
everytime? Thanks!...
|
3 |
05.08.2006 00:32:51 |
|
|
Secuirty On Switchboard
Hey All,
I am developing a database and need certain features on teh switch
board to be username and password protected. For example i want all the
options avaiable to view such as : View Customers, View Employees,
Create Payslip but i need some of the options when clicked to appear
with a a screen or pop up asking for a username and password in order
to access information recarding which ...
|
2 |
04.08.2006 13:46:35 |
|
|
Linked Tables Security Problem
Hello
I'm involved with a project at work where we are using two different
databases.
The project is split into two areas.
I manage one and another colleague manages the other.
I'm quite new at this stuff so I posted in here and there and read the
articles regarding securing the database when I created it.
My colleague (who's a know it all) went right ahead and created his datab...
|
6 |
04.08.2006 08:38:43 |
|
|
Current user's password
Hi,
How do I access the current user's password?
Thanks,
Carla
--
Message posted via http://www.accessmonster.com
...
|
6 |
03.08.2006 15:58:31 |