ACCESS FEED: Re: [MS_AccessPros] Security Changes between Access97 and Access2010

Sabtu, 04 Mei 2013

Re: [MS_AccessPros] Security Changes between Access97 and Access2010

Hi John,

Thank you for that information.

I like the idea of upgrading to Access 2003 and keeping the .mdb format. Debugging in Access 97 is not much fun.

I will check with the client first to see when an upgrade to 2013 is likely.

Regards, Clive.

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Clive-
>
> Ah, completely ignored the "Security" aspect. User-level security for .mdb
> files is not supported for .accdb. You'll have to keep it as a .mdb file.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
> Sent: Saturday, May 04, 2013 2:06 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: RE: [MS_AccessPros] Security Changes between Access97 and
> Access2010
>
> Clive-
>
> I would convert it to 2003 format first and compile it there to discover any
> incompatibilities. Then test it in 2003. Finally, open it in 2010 and
> compile the VBA project again - save and compact, then give it to your
> client. Note that 2013 no longer supports the mdb format, so you could
> consider converting it to .accdb in 2010 before handing it back to the
> client.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Clive
> Sent: Saturday, May 04, 2013 12:23 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Security Changes between Access97 and Access2010
>
> Hi All,
>
> I need help to set up the security when converting from an Access_97 split
> FE/BE database to Access_2010.
>
> My client has upgraded to Office2010 for Word, Excel etc.(except for Access)
> on WindowsPro.XP_SP3.
>
> Q1. Can the Db remain in Access97 or is better to
> convert it to Access_2003 first?
> (I prefer the Access2003 debug facilities.)
>
> Q2. If I keep it as a .mdb file can I still run the
> existing VBA code?
>
> Q3. Are there any other tips that you can give?
>
> I possess John Viesca's 'Access2007 Inside Out' book.
>
> Looking forward to hearing from you.
>
> Regards, Clive(Williams)
>
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>