3.4  5 reviews on Udemy

Connection Set-Up AccessVBA & Security (ADODB &DAO Series-5)

how you can work with access databases when they are on server or on same machine using two technologies -ADODB and DAO
Course from Udemy
 46 students enrolled
 en
Students will be able to connect access with other access efficiently using connection strings. This topic is so important for access coders that it cannot be excluded from learning.
Connect access with other databases on same desktop
Connect access db with other databases which are on server
How to protect a database with full security features.
How to give users access to database as an Admin
  • Learn how to work with recordsets using ADODB Library. This is my first time I am sharing the ADODB library. My all previous series were on DAO.

  • Not just ADODB methodology but side by side we are also making the code in DAO so that we can a good comparisons

  • Talking about connections strings you go and use when you work with other ACCCESS Database which is on your computer or may be on server.

  • Types of DAO recordset cursor types like dbforward only, dbsnapshot only, dbdynamic etc

  • Also how to set up the security set up and create a login page for users.

  • How to connect access db with another database on the same system

  • How to connect access db with database which is on server. Like sql server or ms access etc.

  • What is a  connection string and where we can have it if we want to connect front end access with other databases.

  • How to set up the security set up in MS Access using by pass key.

  • How to allow users to see limited data by giving them read-write only.


Connection Set-Up AccessVBA & Security (ADODB &DAO Series-5)
$ 19.99
per course
Also check at

FAQs About "Connection Set-Up AccessVBA & Security (ADODB &DAO Series-5)"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

SOCIAL NETWORK