Just Upgraded to 2007 - security won't let me in database Ronnie 12/27/2008 11:27:01 PM I just upgraded to 2007 and the security I had set on the database in Access 2003 is not letting me in. I am getting a message to contact the administrator to change my user permissions. I am the administrator and I can't get in to make any changes. I can open the workgroup, but I can't see how to change or remove passwords. I thought this might do it, but I guess not. Any suggestions? -- Ronnie

Re: Just Upgraded to 2007 - security won't let me in database "Arvin Meyer [MVP]" <arvinm[ at ]mvps.invalid> 12/28/2008 12:29:09 AM You must use the exact same workgroup file (.MDW) that you used with the previous version. If the file was changed in the upgrade, you will need to find a copy from one of your machine backups previous to the upgrade. Further, Access 2007 ACCDB files do not support User=Level security, so you will need to maintain the MDB file type. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Ronnie" <Ronnie[ at ]discussions.microsoft.com> wrote in message news:1CD4961A-90F5-4851-B764-E863BE375A27[ at ]microsoft.com... [Quoted Text] >I just upgraded to 2007 and the security I had set on the database in >Access > 2003 is not letting me in. I am getting a message to contact the > administrator to change my user permissions. I am the administrator and I > can't get in to make any changes. I can open the workgroup, but I can't > see > how to change or remove passwords. I thought this might do it, but I > guess > not. Any suggestions? > -- > Ronnie

Re: Just Upgraded to 2007 - security won't let me in database "a a r o n . k e m p f [ at ] g m a i l . c o m" <aaron.kempf[ at ]gmail.com> 12/28/2008 1:17:57 AM Microsoft removed User Level Security from Access 2007 (format). You should remove the security and upsize to SQL Server, so that you can have real horizontal security. On Dec 27, 3:27 pm, Ronnie <Ron...[ at ]discussions.microsoft.com> wrote: [Quoted Text] > I just upgraded to 2007 and the security I had set on the database in Access > 2003 is not letting me in.  I am getting a message to contact the > administrator to change my user permissions.  I am the administrator and I > can't get in to make any changes.  I can open the workgroup, but I can't see > how to change or remove passwords.  I thought this might do it, but I guess > not.  Any suggestions? > -- > Ronnie

Re: Just Upgraded to 2007 - security won't let me in database "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 12/28/2008 2:49:04 AM "a a r o n . k e m p f [ at ] g m a i l . c o m" <aaron.kempf[ at ]gmail.com> wrote: [Quoted Text] >Microsoft removed User Level Security from Access 2007 (format). Wrong. ULS is still available in A2007 MDB format. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Re: Just Upgraded to 2007 - security won't let me in database "a a r o n . k e m p f [ at ] g m a i l . c o m" <aaron.kempf[ at ]gmail.com> 12/29/2008 8:07:27 AM I didn't say anything about Access 2007 MDB format. It is a fact that ULS was removed from Access 2007 (format) On Dec 27, 6:49 pm, "Tony Toews [MVP]" <tto...[ at ]telusplanet.net> wrote: [Quoted Text] > "a a r o n . k e m p f [ at ] g m a i l . c o m" <aaron.ke...[ at ]gmail.com> > wrote: > > >Microsoft removed User Level Security from Access 2007 (format). > > Wrong.  ULS is still available in A2007 MDB format. > > Tony > -- > Tony Toews, Microsoft Access MVP >    Please respond only in the newsgroups so that others can > read the entire thread of messages. >    Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm >    Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

Re: Just Upgraded to 2007 - security won't let me in database Ronnie 12/29/2008 9:20:00 PM I have the workgroup file saved, but do not know how to join the workgroup in 2007. How can I remove the security from my 2003 version (from a pc with Access 2003) and start over? Also, is there a site I can go to learn about the upgrades. I opened up another database I had created without security and can't access the switchboards! Getting frustrated. -- Ronnie "Arvin Meyer [MVP]" wrote: [Quoted Text] > You must use the exact same workgroup file (.MDW) that you used with the > previous version. If the file was changed in the upgrade, you will need to > find a copy from one of your machine backups previous to the upgrade. > Further, Access 2007 ACCDB files do not support User=Level security, so you > will need to maintain the MDB file type. > -- > Arvin Meyer, MCP, MVP > http://www.datastrat.com > http://www.mvps.org/access > http://www.accessmvp.com > > > "Ronnie" <Ronnie[ at ]discussions.microsoft.com> wrote in message > news:1CD4961A-90F5-4851-B764-E863BE375A27[ at ]microsoft.com... > >I just upgraded to 2007 and the security I had set on the database in > >Access > > 2003 is not letting me in. I am getting a message to contact the > > administrator to change my user permissions. I am the administrator and I > > can't get in to make any changes. I can open the workgroup, but I can't > > see > > how to change or remove passwords. I thought this might do it, but I > > guess > > not. Any suggestions? > > -- > > Ronnie > > >

Re: Just Upgraded to 2007 - security won't let me in database Walt Kowalski 12/30/2008 2:27:00 AM "a a r o n . k e m p f [ at ] g m a i l . c o" wrote: > I didn't say anything about Access 2007 MDB format. > It is a fact that ULS was removed from Access 2007 (format) Get off my lawn and don't come back.

Re: Just Upgraded to 2007 - security won't let me in database "a a r o n . k e m p f [ at ] g m a i l . c o m" <aaron.kempf[ at ]gmail.com> 12/30/2008 5:37:24 AM you can't use ULS in Access 2007 (format). if you need security in Access 2007; you're forced to move to Access Data Projects. SQL Server, the worlds most popular database. -Aaron On Dec 29, 1:20 pm, Ronnie <Ron...[ at ]discussions.microsoft.com> wrote: [Quoted Text] > I have the workgroup file saved, but do not know how to join the workgroup in > 2007.  How can I remove the security from my 2003 version (from a pc with > Access 2003) and start over? > > Also, is there a site I can go to learn about the upgrades.  I opened up > another database I had created without security and can't access the > switchboards!  Getting frustrated. > -- > Ronnie > > > > "Arvin Meyer [MVP]" wrote: > > You must use the exact same workgroup file (.MDW) that you used with the > > previous version. If the file was changed in the upgrade, you will need to > > find a copy from one of your machine backups previous to the upgrade. > > Further, Access 2007 ACCDB files do not support User=Level security, so you > > will need to maintain the MDB file type. > > -- > > Arvin Meyer, MCP, MVP > >http://www.datastrat.com > >http://www.mvps.org/access > >http://www.accessmvp.com > > > "Ronnie" <Ron...[ at ]discussions.microsoft.com> wrote in message > >news:1CD4961A-90F5-4851-B764-E863BE375A27[ at ]microsoft.com... > > >I just upgraded to 2007 and the security I had set on the database in > > >Access > > > 2003 is not letting me in.  I am getting a message to contact the > > > administrator to change my user permissions.  I am the administrator and I > > > can't get in to make any changes.  I can open the workgroup, but I can't > > > see > > > how to change or remove passwords.  I thought this might do it, but I > > > guess > > > not.  Any suggestions? > > > -- > > > Ronnie- Hide quoted text - > > - Show quoted text -

Re: Just Upgraded to 2007 - security won't let me in database "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 12/30/2008 6:09:58 AM "a a r o n . k e m p f [ at ] g m a i l . c o m" <aaron.kempf[ at ]gmail.com> wrote: [Quoted Text] >you can't use ULS in Access 2007 (format). > >if you need security in Access 2007; you're forced to move to Access >Data Projects. Wrong. Access security is supported in A2007 MDB format. Granted SQL Server security would be very likely be better but would be significantly more work. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Re: Just Upgraded to 2007 - security won't let me in database "a a r o n . k e m p f [ at ] g m a i l . c o m" <aaron.kempf[ at ]gmail.com> 12/30/2008 3:14:55 PM I never said anything about Access 2007 MDB format. ULS and replication are not available in Access 2007 (format). If you want replication or security, you're forced to use Access Data Projects On Dec 29, 10:09 pm, "Tony Toews [MVP]" <tto...[ at ]telusplanet.net> wrote: [Quoted Text] > "a a r o n . k e m p f [ at ] g m a i l . c o m" <aaron.ke...[ at ]gmail.com> > wrote: > > >you can't use ULS in Access 2007 (format). > > >if you need security in Access 2007; you're forced to move to Access > >Data Projects. > > Wrong.  Access security is supported in A2007 MDB format.  Granted SQL > Server security would be very likely be better but would be > significantly more work. > > Tony > -- > Tony Toews, Microsoft Access MVP >    Please respond only in the newsgroups so that others can > read the entire thread of messages. >    Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm >    Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

Re: Just Upgraded to 2007 - security won't let me in database "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 12/31/2008 5:24:18 AM "a a r o n . k e m p f [ at ] g m a i l . c o m" <aaron.kempf[ at ]gmail.com> wrote: [Quoted Text] >I never said anything about Access 2007 MDB format. >ULS and replication are not available in Access 2007 (format). Your statement is still misleading. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Re: Just Upgraded to 2007 - security won't let me in database "a a r o n . k e m p f [ at ] g m a i l . c o m" <aaron.kempf[ at ]gmail.com> 12/31/2008 11:46:28 AM Tony; you're the one that _LIES_ at every corner. you have no right to say that my statement is misleading. You're the one that's stuck, insisting that everyone use _YOUR_FAVORITE_ database.. and you just can't handle the fact that someone somewhere-- knows databases more than you. So sorry that you think that your 6 month project working for igloo- manufacturing cmpany gives you the qualifications to proclaim that sql server is 'TOO COMPLEX FOR EVERYONE' you can just screw yourself. so sorry that you had a hard time on an upsizing project a decade ago. You have no right to insist that everyone use an obsolete database _TODAY_ just because you couldn't figure out sql server. Grow up you lazy bastard. -Aaron MCITP: DBA SQL 2005 On Dec 30, 9:24 pm, "Tony Toews [MVP]" <tto...[ at ]telusplanet.net> wrote: [Quoted Text] > "a a r o n . k e m p f [ at ] g m a i l . c o m" <aaron.ke...[ at ]gmail.com> > wrote: > > >I never said anything about Access 2007 MDB format. > >ULS and replication are not available in Access 2007 (format). > > Your statement is still misleading. > > Tony > -- > Tony Toews, Microsoft Access MVP >    Please respond only in the newsgroups so that others can > read the entire thread of messages. >    Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm >    Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

Re: Just Upgraded to 2007 - security won't let me in database "John Radan" <ajonrad[ at ]aol.com> 1/1/2009 4:28:48 AM "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> wrote in message news:hf0ml4pc9ha9vgrdq9nmqqh6l1eghoh12s[ at ]4ax.com... [Quoted Text] > "a a r o n . k e m p f [ at ] g m a i l . c o m" <aaron.kempf[ at ]gmail.com> > wrote: > >>I never said anything about Access 2007 MDB format. > >>ULS and replication are not available in Access 2007 (format). > > Your statement is still misleading. > > Tony > -- > Tony Toews, Microsoft Access MVP > Please respond only in the newsgroups so that others can > read the entire thread of messages. > Microsoft Access Links, Hints, Tips & Accounting Systems at > http://www.granite.ab.ca/accsmstr.htm > Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/