|
Unable to merge after sharing database
What did I leave out?
Added security in access 2003 and lost the abbility to merge with word 2003!...
|
4 |
16.07.2006 15:14:02 |
|
|
corrupt files
On June 27th at 7:46 pm all my database files ( in the same folder)
became corrupt( Probably around 100 different files all with the same
time stamp of June 27 7:46 pm) I think the file that did it was
da8f5167.exe. I can see the data briefly in excel when the file starts
to open. In Access 97, the message starts with unrecognized file and no
data appears. I have tried a lot of stuff but none...
|
7 |
16.07.2006 02:09:48 |
|
|
Adv/disadv of using Access built-in security tools vs build in db
This is a high level question.
I can think of three ways, in general, to implement Access user-level security
* Use the built in security tools to create workgroups and users
(have never done, but have read it can be tricky to implement)
* Obtain the Windows XP ID to control access to forms and database
changes
* Store user IDs and ...
|
22 |
15.07.2006 13:30:56 |
|
|
Learning experience
How long it took you to become a security specialist and a MSCDA...
|
1 |
14.07.2006 14:22:02 |
|
|
what is sccess?
i am ganesh, i wise know sccess about this access....
|
1 |
14.07.2006 05:58:01 |
|
|
Disable Security - Use the standard .mdw file - Allow external apps to connect using DAO
I have a database that I tried to implement the access security using a
stand alone .mdw security file.
I no longer want to have the security implemented and want to make the
DB completely unsecure.
I have sort of achieved this - I can now distribute the DB freely and
people can open it. But when I try to connect to the DB from external
sources (e.g. using DAO from Excel) I get the erro...
|
3 |
13.07.2006 22:29:15 |
|
|
Network Security multiple users, Getting rid of the warning messag
Hi
I am implementing a database that is to be shared on a network. I was
wondering with the access security when a user is logged on and some1 else
tries to log on with the same correct details what happens? Are they allowed
on or does it say already logged on and not let u on?
Another question is to do with the annoying security messages, is there a
way to get rid of these for a par...
|
8 |
13.07.2006 18:26:28 |
|
|
Help
This is a multi-part message in MIME format.
------=_NextPart_000_001E_01C6A6CA.D06CBE70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Can anybody give me a link where I can study about Access. I wish to set =
up a server. I just dont know how from the scratch.
------=_NextPart_000_001E_01C6A6CA.D06CBE70
Content-Type: text/html;
charset="...
|
1 |
13.07.2006 15:22:23 |
|
|
Security for DCOM component
I have a DCOM compent that our programers have built. I have the security
settings set on it to customize for "Launch and Activation Permissions". This
server was W2K3 then it was upgraded to SP1. However I have another set of
servers that are built as W2K3SP1 integrated. I can't get the Security to
stay at customize for "Launch and Activation Permissions"
I have made sure the DCOM com...
|
1 |
13.07.2006 14:52:01 |
|
|
Record level access
anyone know how I can give certain users access only to certain records
within a database...too many forms and reports to redo for each user!......
|
4 |
13.07.2006 13:38:39 |
|
|
Reopen the database for relogon
I have security on my DB and it works great until I leave the computer. How
can I get it to go back to the logon screen. I don't want to have anyone use
my logon. I have a button to exit access when I am done, but someone might
want to look something up and I need to have them use their own logon....
|
5 |
13.07.2006 10:44:32 |
|
|
ldb won't delete
Hello,
I have a split DB running and when I try to open the back-end to do edits on
a table, I get a message saying that I do no have exclusive access and that
my changes may not save. When I checked the ldb files I found that there is
always two and they seem to be from the same user. I've tried to delete them
and they do but then they show up again.
Is there anything I can do?...
|
2 |
13.07.2006 01:39:58 |
|
|
log in problems
When I first created the access db I created it on a local drive. There I
created the log ins and security permissions. Everything was working fine.
I recently moved it to a network drive only to discover the users I had set
up would bypass the login screen. I then moved my security files from my C:
drive to the network K: drive. Now I'm getting an error message that my
users do no...
|
5 |
12.07.2006 17:22:02 |
|
|
mde file
I created a mde in a folder and copied it to other folder for other users.
Sometimes the forms and queried don't function properly. Does the mde and
mdb need to be in the same folder or can I make a mde in one folder and copy
it to other folders and make shortcuts? Also, how can I keep the size of the
mde file from growing?
Thanks...
|
2 |
12.07.2006 15:26:48 |
|
|
** Security Issue While Linking Excel or Word to Access Database **
Hello --
I have recently implemented security on a networked Access database (system.
mdw is in the same network location). The security at a user level seems to
be working fine.
However, now that the security has been implemented, I am unable to link
Excel and Word documents to the database. We leverage many Excel pivot table
reports that are linked to Access via the GET EXTERNAL DAT...
|
2 |
12.07.2006 14:50:41 |
|
|
How Do I Prevent Access 2003 Crash when using Digital ID & Library
I posted this as a suggestion to Microsoft several days ago. Guess that was
a mistake. Here's my problem:
When using a Digital ID in an MDB with a MDB/MDE/MDA library which also has a
Digital ID, MS Access 2003 crashes when I use Tools-Database
Utilities-Compact
Repair Database. Backup Database crashes from both File and Tools. Compact
on Exit also crashes if MDB but MDE exits OK. I...
|
9 |
12.07.2006 12:46:34 |
|
|
Startup problem with runtime and no-runtime apps
This problem just cropped up about 10 days ago. When starting a program I get
the security warning dialog (No, Open, More Information). Normally clicking
Open allows the program to begin at it's startup page. I am using my
switchboard which for my app is the most logical place to begin and has
worked very well in the past. Now when I click Open the screen blanks out,
leaving me with a da...
|
2 |
11.07.2006 21:06:12 |
|
|
Creating security for MS Access application
I have a MS Access application which would be on the network and
multiple users must be able to access using their respective used ids.
I wanted to create user ids and grant permissions based on user ids.
First, I created a workgroup using Tools -> Security -> Workgroup
Adminstrator. I created user accounts and set permission level to
tables, queries etc.
Now, the issue is when I try...
|
5 |
11.07.2006 18:56:01 |
|
|
Can't add users and groups
I create a new MDW file, then created a new database using the new mdw,
then created a super user, then logged out and logged in as the super
user. Then I removed all the permissions from the admin and user. Now
when I go back to the security I can't add any users and the group tab
is missing. How can I get this back? Do I need to start over?
Thanks Mike P
...
|
2 |
11.07.2006 17:11:00 |
|
|
Capturing Windows Login
Is there a way of identifying the windows logon while in access?
I have computers with Access on Windows XP. I want to be able to identify
the windows' users that are using the mdb. I have established no security for
the database and only want to view the information to establish defaults
based upon the windows user. The windows intranet has windows security
logons.
Can I set it equ...
|
3 |
11.07.2006 12:47:02 |
|
|
workgroups
Were running an access 2000 database with a workgroup file.
I can't see anything for adding the workgroup into access and yet access
says I need to add the workgroup file and doesn't tell me how....
can someone tell me how, thanks...
|
2 |
11.07.2006 11:52:48 |
|
|
Preventing users opening backend
I am in the process of creating a simple split flat database using the
Splitter Wizard. I shall locate the back end in a shared folder on the
network and ensure the six users each have a copy of the front end database
in their respective folders. Each user types data into their own table (I
know this is not best practice but that is what was decided!)
I understand the backend has to b...
|
3 |
11.07.2006 10:39:02 |
|
|
digital signature trouble
(this was previously posted on thee wrong section. I apologize)
Hello,
I have a project on which I'm working on.
I released it for testing after having digitally signed with a self-signed
certificate.
Now... everythign as worked well..on my pc and on the one were the
application was tested.
Now I need to make few changes and I have done it on ANOTHER pc (not the one
where I create the c...
|
2 |
11.07.2006 01:34:02 |
|
|
Installed updates, now macros don't work!
I have a Windows 2000 server that holds an Access 2002 database. Users used
to be able to open this database through Terminal Services when necessary,
but every since I installed Windows and Office updates toward the end of
June, the database gives the following error when opened:
Action Failed
Macro Name: AutoExec
Condition: True
Action Name: RunCode
Arguments: Startup ()
And th...
|
5 |
10.07.2006 20:42:21 |
|
|
Missing User data on some macros stops conversion of Access97 to Access2003
Hi,
I'm trying to convert an Access 97 database to Access 2003 how ever I get an
error message that Access 2003 can not convert some of the database due to
security reasons (some of the macros are set to read only) and quits.
When I look in the database in Access 97 some of the macros have a user of
'Unknown rather than 'Admin'. I can't change the user to admin and the set
the macro perm...
|
2 |
10.07.2006 17:18:50 |