If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Workgroup File - Access 2007
I have an issue....and it's totally my BAD!!! If anyone could give me some
advise how to fix this I would be very grateful. The place I work just recently switched out our computers and upgraded our software from Office 2000 to Office 2007. I had created several databases in the Access 2000 Version with securiity. So when I went to convert my database to Access 2007 (this is the version I now have), it would not let me convert because it said I needed Administrator Permissions. So I tried to create new databases by importing my information from the old to the new, and it would not let me import my forms because of again Administrator Permissions, everything else came through but my forms. So the DUMB IDIOT that I am I thought oh well I need to re-assign the WorkGroup file to another WorkGroup to get rid of the old security features....well here comes my problem I accidently assigned it to a file that I stupidly thought was an Access 2007 workgroup with the extension ..ACCDU, and guess what yep to my amazement I now cannot even open up a new blank database in Access 2007. It is giving me an error message that reads: "Could not open table MySysAccounts in the WorkGroup Information File". Can anyone tell me how/where/what/etc I can go in and change it back to grab the old .mbd WorkGroup File? Because I am obviously not very BRIGHT due to my recent STUPIDITY.....unfortunately I'm going to need detailed (step by step) instruction on how to correct. I so appreciate anyone who can look past my ignorance to help me out. Thanks -- Alison |
#2
|
|||
|
|||
Workgroup File - Access 2007
Alison,
When you open your database you should use a short cut to reference the workgroup file such as; "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "n:\data \DatabaseName.mdb" /WRKGRP "n:\data\SecuredWorkGroupFile.mdw" Is there a reason you are trying to convert your database to 2007 format? You don't need to, in fact if you still want to use Work Group Security you should leave it in the 2000 format. If that's not what your asking please clarify. Hope that helps Rick Can anyone tell me how/where/what/etc I can go in and change it back to grab the old .mbd WorkGroup File? Alison |
Thread Tools | |
Display Modes | |
|
|