A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Workgroup File - Access 2007



 
 
Thread Tools Display Modes
  #1  
Old April 23rd, 2010, 04:34 PM posted to microsoft.public.access
alison.justice
external usenet poster
 
Posts: 40
Default 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  
Old April 26th, 2010, 02:18 PM posted to microsoft.public.access
Rick A.B.
external usenet poster
 
Posts: 44
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:28 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.