Application close the connection and leaves the MDB without passwo
Wed, 4 Jun 2008 09:29:02 -0700
I coded an Application in VB 6.0 with ADO and it's connecting to an Acces
2000 MDB. This is the connecton string:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + MyDataBase + ";Jet
OLEDB:Database Password=mypassword08;Mode=Read|Write|Share Deny None;Persist
Security Info=True"
The problem is that the appli ...
|
Unable to read DB - Locked Link Table
Wed, 4 Jun 2008 07:14:52 -0700 (PDT)
I'm trying to read records from a database for a little asp page. The
page executes a query against a database containing a linked table.
If I have the source database for that linked table open in Access,
the asp page dies because of what I interpreted as an exclusive lock.
I can, however, still query directly ...
|
The VBA project in the database is corrup
Wed, 4 Jun 2008 16:06:22 +0400
Dear All
I have an access 2003 database connected to sql server.
I have finished some modifications and used access workbench to compile it
as mde.
I have first decompiled it but it launched access 2007 instead of access
2003.
The database came corrupted and now i can not access any module, i get the
messa ...
|
prevent deleting
Wed, 4 Jun 2008 04:38:02 -0700
Hi all, is there a way of preventing someone from just highlighting your
database and pressing the delete key ???, I have created a database which is
used on a network within the company I work for and want to stop just anybody
from deleting it.
Thanks Regards Tony.
...
|
User-level security - confused
Tue, 3 Jun 2008 22:45:00 -0700
Hi,
Sorry if this question is not a very good one.. I'm trying to use the
user-level security in Access to create two accounts such that one has
complete authority to change/add/delete anything in the database, just like
one has when one creates the database, and another account for data entry
that opens ...
|
Security in Access 97
Tue, 3 Jun 2008 18:50:52 -0700 (PDT)
My knowledge of Access could best be described as intermediate but
I've never really been involved with security beyond "hiding" many of
the objects and creating a database password.
I have a file at work that approximately 20 individuals use. It's not
a split database, I'm still learning more about that, and ...
|
Setting Up Switchboard Level Security
Tue, 3 Jun 2008 11:00:07 -0700
Is it possible to set security at the switchboard level. I would like only
certain folks to have access to specific departments within the dmb.
Would this be done using the "User and Group Permissions" function?
Any advice would be greatly appreciated.
Thanks. ...
|
|
|
Multiple Users
Tue, 3 Jun 2008 08:18:00 -0700
My colleague is able to open Access on her desktop when I have it open on my
desktop. Unfortunately, if she has hers open first, I'm unable to open mine.
I don't get any errors, it simply won't open. We've checked the security
settings and they appear to be the same. What am I missing? ...
|
Opening security-enabled Access 97 mdb
Mon, 2 Jun 2008 10:04:34 -0700
My company currently uses Access 2003. We have an Access 97 database that
was apparently created with a restricted user list. None of the folks that
would have been on that list work here anymore. (We get "The current user
account doesn't have permission to convert or enable this database" error
when tryi ...
|
Can a record in a table be locked to updates based record.field va
Fri, 30 May 2008 11:12:00 -0700
We want to lock a record when the status field on that record = 100.
If MasterTable.Status is 100 we'd like to lock that row from any updates
[both updates from the form that displays the table fields and from the table
in datasheet mode.
Is that possible and how to do it?
Here are my thoughts:
1) ...
|
