thanks, Bill! I couldn't open it with 2013 --- but then took the file to another machine with 2007 and was able to. It is an Access 95 database with 40 tables and no relationships ... or unique indexes that I could find in the few tables I looked at design for.
Youssef, adding on to what Bill and Duane said -- if you want greater security for the back-end, them move the data to something else.?? Another thing you can do is rename the back-end to NOT have an MDB/ACCDB extension so someone can't so easily troll around looking for it.
Where is the *application* though??? this is just data. Access to data is controlled by the application.
Access is an application development environment with built-in capability for a limited database. While you're developing an application (queries, forms, reports, macros, modules), Access is fine to also use for storage, as long as you don't exceed its 2gig barrier per file, or need more data security or something else.
To make things easy, you can prototype, and maybe even keep, data in Access. When you have more than one user, data should be in its own database, as yours appears to be, ... but there should be another file with the user interface objects that everyone gets their own copy of! Where is that? If you want greater data security for the tables, like denying ability to edit, you can convert to to something else like SQL Server or SQL Express , as Duane and Bill suggested.
have an awesome day,
crystal
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_ProfessionalsMy nothing-to-do-with-Access blog
---In MS_Access_Professionals@yahoogroups.com, <youssef> wrote :
the database is a compressed file with name Imsys
Posted by: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (8) |
Tidak ada komentar:
Posting Komentar