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 Replies
ADVERTISEMENT
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
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
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
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
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
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
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 6 Replies
View Related
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
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
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
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
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
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
Sep 29, 2013
I see a lot of requests for this operation, but apparently .DB files are so general that sometimes it's impossible? Any all-encompassing program that can read files like this? I believe they come in different formats and are produced by a variety of different programs. The only thing I ever see though are files with [.db] as the extension.
If I open the one I have with notepad on a windows machine I see some of the info but some of it is not there and is garbled.
[URL]....
View 4 Replies
View Related
Jun 15, 2006
Is it possible to delete user information in workgroup information (System.mdw) file from command line or programmatically?
Thanks
View 1 Replies
View Related
Mar 17, 2014
I am trying to use a Connection to an xlsx spredsheet to read in a table of information (the data is not a table, just laid out in a table, see attached, the one I am trying to load is xlsx not xls but I cannot for some reson upload the xlsx one on here)
I have the following declared:
Code:
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
my connection string is:
Code:
strConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & cstrFolder &
Chr(92) & tempSymbol & ".xlsx;Extended Properties='Excel 12.0 Xml;HDR=YES';"
I open the connection which works fine:
Code : cn.Open strConnectionString
Now here I hit the problem, I have the following SQL string:
Code : strSelect = "SELECT * from [table$]"
The spreadsheet contains just 1 tab, named table so I think I am referring to the data correctly in my SQL string?
When I open the recordet for variable rs using:
Code : rs.Open strSelect, cn, adOpenStatic, adLockOptimistic, adCmdText
I get the error dialogue box:
The Microsoft Access database engine could not find the object 'table$'. make sure the object exists and that you spell its name and the path name correctly.....
I did a Debug.print to check the strConnectionString was correct and the Source is exactly correct and refers to the name of the file I am trying to access exactly.
View 2 Replies
View Related
Feb 2, 2015
I'm trying import some information from excel file into Access Database but I need have imported information formatted in specific way.
Import file is looking like:
City - Week / 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8
London / 3 / 1 / 4 / 5/ 5/ 9/ 1/ 3/ 4
Chicago / 2 / 1 / 4/ 8/ 3/ 3/ 2/ 1 / 5
Paris / 9 / 4/ 1/ 7/ 8/ 9 / 1 / 1 / 2
And i need table in Access looking more like
City / Week / Value
London / 1 / 3
London / 2 / 1
London / 3/ 4
London / 4 / 5
and so on for each city.Is there any option that this can be done within DB or It would need be some kind of macro to transfer this into other format?
View 1 Replies
View Related
Oct 31, 2006
Hi there,
I'm trying to put in place a workgroup and I'm struggling with it at the moment. I created a seperate workgroup and have a command line short cut to it. When I try to add a user to the admin group permissions it works fine except that I can't open any of the forms in design mode. It says I do not have exclusive rights . I dont know what to do. I though that the admin password would be set to blank but It won't open the database either.
Any ideas, im pulling me hair out.
View 6 Replies
View Related
Jun 2, 2005
Might be a stupid question but here goes.
I have successfully created my own private workgroup and have set up security levels for 4 users on one access programme that l have written.
I have a second access programme that l use with the same users, however l want to set different user parameters, can l set a second workgroup up as l did the first.
Is two workgroups possible on the same machine ?
Regards
Andy B
View 8 Replies
View Related
May 18, 2006
I have the security set via the Access workgroups for both groups and users. I want to be able to use the username entered on the logon screen to filter my query results.
How can I get the logon id that was entered when my switchboard form opens?
Thanks in advance.
Dennis Cronin
View 3 Replies
View Related
Jun 5, 2006
I currently have several Access 2003 databases on my computer. I have been working on a new one that must be secured.I have created a new .mdw file to handle this. The path to this file is included in the shortcut. Everthing works great.
HOWEVER:
Whenever I close this database and then open another, it is still promting me for a password (the other DBs aren't supposed to be secure). I have changed the shortcuts to go through the old system.mdw but it still does it. When I change the workgroup manually, the secure database no longer prompts me for a password. It would appear there is more to selecting the workgroup than just editing the shortcut.
View 1 Replies
View Related
Jul 26, 2007
I'm trying to set-up and secure a networked multi-user database. I used the Workgroup Administrator to create a new workgroup and save it to the network drive. However, when I open my database, it seems it may still be pointing to the the default SYSTEM.MDW workgroup on my hard drive. Do I need to do something to my database to tell it to point to the new workgroup I have set-up? When I start having other people log in from different locations, will they need to join the workgroup or also point the database to the networked workgroup when they open the database? The manuals aren't very clear on this, please help.
View 1 Replies
View Related
Jun 6, 2005
Can someone post a copy of a sample mdw file so that I may observe the design of the database? I am very new to the concept of db security and would like to take a look at how the design is constructed. Thanks!
View 11 Replies
View Related
Jul 18, 2006
We are running two versions of Access (97 and 2003) on some of our machines. We recently set up a new workgroup file, but it seems that on the machines that have the two versions of Access the workgroup file reverts back to the old setting everytime the user logs in again.
What do we need to do to prevent the workgroup file from switching back?
Thanks
View 2 Replies
View Related
Aug 4, 2007
help,
i have forgoten my workgroup password, can anyone recomend some free software that will allow me to recover the password.
thanks
View 5 Replies
View Related
