MS Access Database Admin Level

  • Thread starter Thread starter Dinesh Khedkar
  • Start date Start date
D

Dinesh Khedkar

1. How do we repair Acces Database, if it becomes corrupt.
2. Is there anything like re-indexing / Re-org of Access
Database?
3. What about making the mdb file secure? Today, mdb file
is accessible to anybody and everybody who has physical
access to the file. Is it possible to protect the file by
some means by which nobody can change the contents within
the tables from outside of the application?
4. Is incremental backup of Access possible? Is table
level backup possible?
 
comments inline
--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP
Dinesh Khedkar said:
1. How do we repair Acces Database, if it becomes corrupt.
Click to expand...

Use the Compact and Repair action . In A2000 and up, this is accessible
through Tools - Database Utilities - Compact and Repair. You can also run
this from a desktop shortcut:

"Path to MSAccess.exe" "Path to your db" /compact
2. Is there anything like re-indexing / Re-org of Access
Database?
Click to expand...

See #1
3. What about making the mdb file secure? Today, mdb file
is accessible to anybody and everybody who has physical
access to the file. Is it possible to protect the file by
some means by which nobody can change the contents within
the tables from outside of the application?
Click to expand...

You can implement User Level Security (ULS) and allow data access only
through RWOP. It's tricky and complex, but it will get your Access app as
secure as a desktop application can get. Note that there are quite a few
readily available tools that will retrieve user names and passwords, so
consider this when deciding what data to store in your database.

Before doing so, download and read-read-read the Access Security FAQ:
http://support.microsoft.com/support/access/content/secfaq.asp

And, you may want to look at Jack MacDonalds site also:
http://www.geocities.com/jacksonmacd/AccessSecurity.html
4. Is incremental backup of Access possible? Is table
level backup possible?
Click to expand...

You can backup an Access db the same way you do any other FILE (since
Access/Jet is a file server database system), by using a backup utility or
writing code that does so. Whether this is incremental or not depends on the
backup software you use. Access doesn't have builtin backup capabilities, if
that's what you're asking. You could implement table level backup through
code by exporting tables to a remote database ... this would, of course, be
done via code.
 
Back
Top