• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. SQL Server Security > Access Security and Its Role in a Client/Serve...

Access Security and Its Role in a Client/Server Application

When you upsize an Access database, the security that you have established on the Access database is not upsized. Microsoft leaves it up to you to establish security on the SQL Server. You can write code to read the security in the Access .MDB and create it on the SQL Server. If you opt not to use code, you must go through the tedious process of establishing security on each object in the SQL Server database.

When you upsize the data, you still may opt to secure the Access .MDB. This serves to secure your forms, reports, and macros. You can secure your programming code by placing a password on the Visual Basic for Applications(VBA) project. Another option is to distribute your application as an .MDE. This distributes your application without source code. Because the data is secured by SQL Server, this option may be sufficient for you and greatly simplifies the security process.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint