Using Copy Of Existing Workgroup File On A New Db?

Jun 17, 2005

Hi all,

I've set up security on my database before with great success, and now I'd like to use the same workgroup file (a copy with a new name and location) to secure a nes db.

I open the new db, and join my earlier created mdw file. I'm prompted with that I have joined my workgroupfile.

I then set permissions for each user in the workgroupfile, remove admin rights for the admin user account, and assign admin rights to my own account. I am also the owner of thr db.

I now run the security wizard, and I make no changes to any checkboxes.

This goes nicely, and the wizard closes after making a backup file.

I now want to re-join the system.mdw file, so I don't get prompted with the logon dialog when opening a new db or an unsecured db.

If I now try to start my new secured db by double-clicking on the secured mdb file it opens ?????

Where am I going wrong?

Thanks in advance for any help.

View Replies


ADVERTISEMENT

General :: Copy New MDB File Over Existing Database

Feb 28, 2014

How can I overwrite the existing Access database with another Access database without the need for the end user to get involved in the process.

I want the code to copy a new mdb file over the database I am using (!) and then automatically start the new mdb file...

View 9 Replies View Related

Workgroup File Lost

Sep 21, 2005

We have an old Access 97 database with a workgroup file. The problem was that the machine was upgraded and the software was changed to XP. They support guys moved all files to the new PC except the the workgroup file. We can't fine a backup of the w/g file.

I am unable to upgrade the database to access 2002 because of the permissions.

What is the easiest way to get past this stumble block.

Thx

View 2 Replies View Related

Join Workgroup Using A Zip File

Jul 27, 2006

Present
Go to user computer, and then manually to join the workgroup.


Is this possible?

Send email to new user.
Join workgroup using a zip file. When file is un-zip the user automatically joins the workgroup and places a short cut on there desktop.


Not asking for to much, you think.

View 2 Replies View Related

Lost Workgroup File

Oct 5, 2006

Hi,

I setup user-level security on the database. the workgroup file was deleted by somebody.

How can I open the database?

Because I create the same name for workgroup group file and input the same WID. It did not restore the original one I lost.

Right now, the database cannot be opened.

Please let me know how to solve.

Thanks.

View 1 Replies View Related

Specifying A Workgroup File To Use From A Shortcut

Jan 9, 2008

Hey all,

I was wondering if any of you guys know how to specify a custom workgroup file in a shortcut to my database.

This is what I've got in my shortcut:

C:TESTTEST.mdb /w "C:TESTSECURITYFILE.MDW"

Basically I want access's system.mdw to remain the default mdw for access but want my mdb to use a different mdw.

Many thanks!

View 5 Replies View Related

Workgroup File Security

Oct 27, 2004

This is more of a point of interest then a question, at work, Access defaults to a central workgroup file, so all Access files opened on a work machine will prompt for a user name and password, and only let you in if you get it right... but if you move the work group file, even after it has been open using that workgroup file, it will just let you straight in and GIVE YOU ADMIN RIGHTS!

No one really seems to know about this... does it happen if you manually set the workgroup file? Or is this just a security hole if you rely on the default? I'm not sure yet, haven't tested, but i fell people should be made aware (happens for sure on Access2002, haven't tested it on any others)

-mwalts

View 4 Replies View Related

Workgroup File In MS Access 2003

Jun 29, 2005

I created a Workgroup file (Project.mdw), assigned different Permissions to different Groups, and put different Users in appropriate Groups.
The above setup is working fine and just as required. But, if I remove or rename the Workgroup file, MS Access does not look for it, creates in its own Workgroup file and starts just as usual - without asking for the Password, or caring about the Permissions and/or restrictions set.
How can I make the database file bound to the MDW file, so that it does not open without it.

View 5 Replies View Related

Assigning Workgroup To Just One Database File ?

Jul 26, 2005

Hi,

I am trying to setup User Level Security around a Purchase Order Database that I created. Using the Wizard I was able to setup different users with different permissions.

However, as I found out the hard way (but I did recover it), 'joining' a PC to a my new security workgroup forces all Access databases on the PC to use this.

Is there a way to force just this one Access .mdb file to use the newly created PO Workgroup security file ?

I am aware of setting up a shortcut to point to thesecured db. Ie: "C:Program FilesMicrosoft OfficeOfficemsaccess.exe" /wrkgrp "C:PO FormsMyWorkgroupFile.mdw" "C:PO FormsMyDB.mdb" /user

But despite the above shortcut, couldn't users just find out where it points to (by looking at the Properties of the shortcut), and open the .mdb file based on that ?

Thanks !

View 1 Replies View Related

Workgroup File (system.mdw) Problem

Jul 28, 2005

I recently created a workgroup for an access database and it works fine. But I have other versions of that same database (beta copies) for which I didn't create that workgroup file. They have different names than the first DB for which I made the workgroup.
But even when I open those beta copies it still launches the workgroup file (system.mdw) and prompts me to login. What do I need to do to revert these changes and go back to the unsecured version of my database?

Is it as simple as deleting this file?

Thanks in advance,

Angelo

View 6 Replies View Related

WorkGroup Information File Qustion...

Nov 22, 2007

Hello all

First of all, I'd like to thank everyone who's a member and has helped someone at some point within the forums! I'm quite new to Access and have received a massive amount of help on one of my first databases.:)

As the title points out, I'm not sure about the WIF. If I have two database in the same location, lets say their called DB1 and DB2 and I create a WIF for DB1, this wont affect DB2, will it? For example, it wouldn't create security for DB2?

Another senario is, if I have two databases nameed DB1 (basically one is a copy) within lets say two different subfolders within the same top level folder, because they are the same name, would this mean that they would both be affected by the same WIF?

I recently created a WIF like this and had to enter a password for both databases! to my consternation, I deleted the DB (along with the WIF) with which I made up the WID and I could access the Other DB without the Password! If I do create a WIF for a database, how can I stop using it as if I never created it in the first place?

Hope someone can help me! Thanks.

View 1 Replies View Related

Hyperlink To Database Using Workgroup File

Jan 10, 2008

Is there anyone out there that can help me with this problem. I want to create a hyperlink in MS Outlook to my database file using my workgroup. The problem I'm having is when I put the following: file://"N:DbaseFilesSCC_Dbase.mdb" that works. It will open Access to that dbase file. But if I include the workgroup file associated like this: file://"N:DbaseFilesSCC_Dbase.mdb" /WRKGRP "N:DbaseFilesCSS_Issues.mdw" it doesn't work. Can someone please tell me why. I've been struggling with this for days now. I can't find any solutions.

View 2 Replies View Related

Remove WorkGroup Information File

Mar 2, 2008

Hi ,

I need to remove the workgroup information file from my MDB file (i.e) removing security check from my project. Can any one help me in it?

View 6 Replies View Related

Workgroup File In MS Access 2003

Jun 29, 2005

I created a Workgroup file (Project.mdw), assigned different Permissions to different Groups, and put different Users in appropriate Groups.
The above setup is working fine and just as required. But, if I remove or rename the Workgroup file, MS Access does not look for it, creates in its own Workgroup file and starts just as usual - without asking for the Password, or caring about the Permissions and/or restrictions set.
How can I make the database file bound to the MDW file, so that it does not open without it.

View 3 Replies View Related

Workgroup Security Cancelled If Mdw File Is Deleted

Mar 14, 2007

Hello people of access world forums. I've decided to design a simple access db with 2003 version but with 2000 compatibility and everything appear to work ok.

After designing and testing the db, I have set the Jet user-level security options as described in some documentation and set the startup options too for a "clean type" start. Everything is ok: I have created the workgroup in a new .mdw file, joined the workgroup, set the users, set the groups, protect the forms I wanted to. If I try to open the db, it asks for user and password and the db works as espected about security.

But if I delete, move or change the .mdw filename, the db turns accesible without the implemented security. Only the startup option works but no user is prompted and the protected items turns unprotected.

I would like to know how can I associate the .mdw to the .mdb so I can't access the .mdb if the .mdw file is not present (i.e. copying the .mdb to another computer or something).

Thanks in advanced.

Kish

View 8 Replies View Related

Copy Existing Fields To New Records

Dec 12, 2006

I have a database and I wish to be able to copy 10 out of about 20 fields into a new record automatically using a command button on a form. Similar to the way the Duplicate button or the Create New button would work but only with these selected fields. None of the fields I wish to duplicate are the primary key. The primary key is an AutoNumber field. After clicking the Save button, the primary key would increment one to confirm the save record.

Any help or suggestion would be appreciated!

Thanks!

View 3 Replies View Related

Copy Existing Invoice Done In Access

Mar 29, 2013

We have a program in Access that makes invoices. I am interested in copying one of the invoices to be used as a new invoice..How do I add a 'copy' button?

View 6 Replies View Related

General :: Copy Structure From Existing Linked Table In Backend

Jun 9, 2012

I have a need to copy a table structure from an existing linked table in the backend

i have done this by

a) copying the table structure into a new table in the fromt ebd
b) exporting the new table into the backend
c) dropping the table in the front end

just wondered if there was an easy way to do this directly in the backend?

View 1 Replies View Related

Tables :: Copy And Replace Existing Records Function In Access?

Dec 3, 2012

Is there a copy and replace existing records function in access?

I.e. I would want to copy records from one table to another (with same structure) and replace similar records with in original table in the new records (which have minor ammendments made).

View 3 Replies View Related

Queries :: Insert Into - Copy Records From Another Base Into Existing Table

Apr 15, 2014

I'm trying to copy records from another base into existing table in current base by:

Code:
DoCmd.RunSQL ("INSERT INTO pivot (RFO_CLIENT_ID, FOLDER_DATE_CREATE, start_time, end_time) SELECT (RFO_CLIENT_ID, FOLDER_DATE_CREATE, start_time, end_time) FROM svod IN 'Z:NPSNPS - Operator - 1.accdb' ")

But it doesn't run. Says insert into syntax error.

View 6 Replies View Related

General :: Make A Copy Of BE File Rather Than To Make A Copy Via Code

Nov 26, 2012

Would it be ok just to make a copy of the BE file (every so often) rather than to make a copy via code?The user can then just paste over the original if it becomes corrupt.

View 4 Replies View Related

Help Me! Error When Open Existing File...

Sep 28, 2006

I'm begin study Microsoft Access but have error and don't know how!
(Please see the attach picture)

I'm use Window XP Pro and Office 2003.

I'm already update window and Jet 4.0 Service Pack 8 (SP8) for Windows XP at link but nothing to change (http://www.microsoft.com/downloads/details.aspx?FamilyID=2deddec4-350e-4cd0-a12a-d7f70a153156&DisplayLang=en)

Please advise me the way to repair this error!!!

View 5 Replies View Related

Modules & VBA :: Create New Backend File From Existing One

Nov 4, 2013

I'm trying to create a button that will open a save window so that user can select where and the name of a new backend file.

and create a new backend file from the one in use and link to the new open.

View 4 Replies View Related

Queries :: Link External File To Existing Database?

Apr 30, 2013

Basically it's trying to take all the files in a given directory and add them into a existing database.

I have a database called Permit. the database has a field called "SEAL" and they will be creating an additional field "SCART" to hold the contents of the file that exist in the directory. Each image file, in directory, is named the same as a unique record in Permit.

example:
Permit-SC might have unique record 532442
An image file would be name 532442.

If the image file matches a record in Permit the image should be added to permit in a field called "SCART". At this point I'm not certain if I want a link or the actual image included in the record. since there's a possibility of including the permit file on the website it might be cleaner to have it included.

View 7 Replies View Related

Modules & VBA :: Appending To Existing Excel File From Recordset

Apr 18, 2014

I'm spinning my wheels on this. Trying to copy a recordset into an existing excel file.

Private Sub cmdExport_Click()

Dim conn As ADODB.Connection
Dim conn2 As ADODB.Connection
Dim rst As New ADODB.Recordset
Dim strSQL As String
Dim strConnection2 As String
Dim wks As Excel.Worksheet

[code]...

View 2 Replies View Related

Tables :: Migrating OLE File To Attachment Field In Existing Record

Mar 8, 2015

Exporting all the OLE files in a 2003 database.

Any way to automatically connect these file to an attachment field in the existing record.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved