Re: shortcut on network

Tech-Archive recommends: Fix windows errors by optimizing your registry

The Target would be something like this:

"Full path to msaccess.exe" "full path to your database" /wrkgrp "full path
to your workgroup file"

You can determine which workgroup you're using to open a specific database
by opening the db, opening the VB Editor (ctrl + f11) and typing this in the
Immediate window:

??dbengine.SystemDB

This will tell you what workgroup is currently being used.

I would also encourage you to use something other than "system.mdw" as the
name of your workgroup file. This is the default workgroup file Access uses.

--
Scott McDaniel
InfoTrakker Software
"neeraj" <neeraj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:510C48D8-2917-4C9A-BC60-B830B5F3316B@xxxxxxxxxxxxxxxx
>I have made several .mdw files in the past few days while testing and
> learning about security, eg.system.mdw, system1.mdw, system2.mdw. How can
> I
> determine which one is associated with the db (and the associated
> shortcut).
> How can I edit the target of my shortcut to the workgroup file. Thanks.
>
> "Scott McDaniel" wrote:
>
>> I would suspect that this has to do with either (a) an anti-virus program
>> or
>> (b) some type of security setting on the sharepoint machine.
>>
>> Also, when moving your db and shortcut, you'll have to move the workgroup
>> file (the .mdw file) to a public folder (normally it's stored where the
>> backend is stored) and edit the Target of your shortcut to point to that
>> file.
>>
>> --
>> Scott McDaniel
>> InfoTrakker Software
>> "neeraj" <neeraj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:564F988D-A588-4393-9319-1A2F3D3FB0D1@xxxxxxxxxxxxxxxx
>> >I secured a database using user level security wizard. It works fine
>> >with a
>> > shortcut that was created on my desktop. As expected, when I click open
>> > the
>> > shortcut, it asks me for a username and password, which when on
>> > supplying
>> > opens the database with assigned permissions. The main access file when
>> > tried
>> > to be opened gives the message "You dont have necessary permissions".
>> > Now I have to make this database availble to the users on our network
>> > through Windows Sharepoint. I uploaded the main database file to the
>> > Sharepoint and it was uploaded. But when I try to open the file from
>> > there,
>> > it gives the expected message "You dont have necessary permissions" Now
>> > I
>> > was
>> > trying to upload the shortcut to Sharepoint but it gives me the
>> > following
>> > message:
>> > "Form Validation Error
>> > Please correct the information you provided by following these steps,
>> > then
>> > submit the information again:
>> > The following file(s) have been blocked by the administrator: Call
>> > Center
>> > Sales/MSACCESS.EXE"
>> > I am not even sure if a shortcut can be uploaded but thats the only way
>> > to
>> > enter into a secured database. Please advise.
>> >
>> >
>> >
>>
>>
>>


.

Relevant Pages

  • Re: Workgroup file connection problem!!!
    ... While it's possible to attach a new workgroup file to Access, ... The shortcut must include the full path to msaccess.exe, ... Doug Steele, Microsoft Access MVP ... I have some question concerning attachments of new users to the database ...
    (microsoft.public.access.security)
  • Re: security wizard cannot be run
    ... You need to open your database using your secured mdw (i.e. the desktop ... Open Access (not via the shortcut). ... Create a new mdb and import everything from your 'secure' mdb. ... Once the database opens, the ...
    (microsoft.public.access.security)
  • Re: No login prompt
    ... log in through a workgroup file - even on a new, fresh install of Access, ... transfer a database to any machine with Access installed and open it. ... > Access window stay open, and then try to open a db, it does not prompt me ... >>> and passwrd and simply opens ...
    (microsoft.public.access.security)
  • Users Cant Open Access Database Security Or Corruption ??
    ... "Database is in an unexpected state; ... If I open the same database it opens with no problems. ... The admin group was stripped of the usual design change permissions ... workgroup file and has the permissions of the admin goup. ...
    (microsoft.public.access.security)
  • Re: Security Wizard Locked ALL Dbs
    ... new Workgroup file before you started. ... Open any code module in the secured database. ... Display the Immediate window. ... and select Create Shortcut from the ...
    (microsoft.public.access.security)