Some questions

[Guest]

I am very new in this field and I need help. I will be highly pleased if any
one can provide some information according to my questions.

1. What is the system of user authorization in MS Access (I mean by login
and password or also host name)? Is there any option to secure connection?
2. What are access privileges (level)?
3. Is there option to grant group privileges?
4. What are the maximum numbers of row and column in one table?
5. Is it possible to use data from different instances in one session?
6. Which applications does Access support?
7. Does it support automatic crash recovery?
8. Does it support triggers?
9. How many users can simultaneously work on one database?
Best regards,
SSR

 

[Graham R Seach]

1. There are three available options in Access. Custom-written security,
Database password protection (which is not user-aware), and user/group-level
security, which makes use of a separate database file called a Workgroup
Information File. There is no way of securing a connection.

2. I don't quite understand what you mean with this question. The access
privileges are whatever you define, proivided you (a) write your own
security, or (b) use user/group-level security.

3. Yes, it forms part of user/group-level security.

4. There is no maximum number of rows, except to say that the database
itself is limited in size to 2GB (there are ways around *that* too),
however, the maximum number of columns is 255.

5. In this context, I don't understand what you mean by "different
instances", and your use of the word "session". Can you elaborate? If you
mean to ask, "does Access support multiple concurrent sessions (users)",
then yes, multiple users can access data simultaneously. See answer 9.

6. Access doesn't support applications - it's the other way around. Access
can be manipulated by any application that uses OLEDB and ODBC providers
against the Jet database engine, and the major data access technologies
(DAO, ADO, JRO, and so on).

7. No. Access is a file-based database, not a server.

8. No. Again, Access is not a server, so it doesn't have listener agents.

9. Theoretically 255, but that depends on the communications infrastructure
and workload.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Albert D.Kallal]

7. Does it support automatic crash recovery?

If you are using a adp project, then you do have crash recovery

8. Does it support triggers?

yes, if you make a ADP project, then triggers are available (the data engine
that lets you do this has been included for the last 3 versions of
ms-access).

9. How many users can simultaneously work on one database?

It depends on what data engine you use. There are some companies with 1000
users all working on the same database. In this case, of course the data
engine was sql-server and the front end was ms-access.