Senin, 12 Agustus 2019

Re: [MS_AccessPros] Prevent Table Design Change

 

Duane and Crystal


Unzip the .rar file using 7-zip or some other file unzipper. The file is just an MDB. I was able to open it in Access 2010.

As to preventing users from making changes to the tables, there really isn't a secure way to do that. There are a few tricks like putting the back end in an obscure folder path and making the front end an MDE without access to the tables except through forms, but that takes a lot of VBA skill.

I recommend that you use SQL Express ( a free version of SQL Server) so you can secure table structure permissions. It is a much more secure way than trying to code that kind of security.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com



---In MS_Access_Professionals@yahoogroups.com, <youssef2309@gmail.com> wrote :

the database is a compressed file with name Imsys

__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (7)

.

__,_._,___

Tidak ada komentar:

Posting Komentar