Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why not for MS Access databases?

databases MS
0
Posted

Why not for MS Access databases?

0

This is because MS Access uses Windows NTFS permissions to restrict access… an MS Access database is simply a file with permissions. So, if you have two domain’s, domainA.com and domainB.com, and you place the db mydb.mdb into domainA.com’s hosting space, only domainA.com’s “hosting user” can access it. Files within domainA.com are only accessible by your domainA.com “hosting user”, and files within domainB.com are only accessible by domainB.com’s “hosting user”. The is same security that keeps your domain hosting space secured from another customer on the same server, and it applies the same here. However, if you simply upgrade your database to either MySQL or MS SQL, you do not have this problem. Security for MySQL or MSSQL databases is handled within the database server engines, i.e., you create a “db user” with each database. So in this scenario, you’d have: • A MySQL database “mydatabase” accessible with MySQL db user: username: “mydbuser” password: “mypassword” • the database c

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123