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

Sabtu, 04 Mei 2013

RE: [MS_AccessPros] Security Changes between Access97 and Access2010

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