2 questions about MS-Access.

Thread View: comp.databases.ms-access

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Periquitin Sat, 20 Dec 1997 00:00

#421

Author: Periquitin
Date: Sat, 20 Dec 1997 00:00

31 lines
2766 bytes

Hello!
I would like to know if there is something like "triggers" in Access. I have
got a database accessed by a Visual C++ program through ODBC.
The database has tables and relations, nothin else (it has not forms) and I
do not know how to make some necessaries comprobations ( input masks and
validation rules are not enough) nor where to make them.
Another question. Is it possible to know what type of data structure
 B-trees, hash tables,...) use Access indexes? And change that type of
indexes? How?
Greetings and thank you very much.

�Hola!
Me gustar�a saber si en Access existe algo parecido a los "triggers".
Me explico. Tengo una base de datos a la que accede un programa hecho en
Visual C++ a trav�s de ODBC.
La base de datos no contiene ning�n formulario, s�lo tablas y sus
relaciones, de ah� que una serie de  comprobaciones necesarias
(que debe hacer la base de datos y no el programa) no s� en qu� lugar ni
c�mo realizarlas (con las m�scaras de entrada y con reglas de validaci�n no
es suficiente).
Otra pregunta. �Es posible saber o incluso cambiar la estructura de datos
(�rboles-B, tablas hash, etc..) con que se almacenan los �ndices en Access?
Si alguna de estas cuestiones es realizable agradecer�a una peque�a
indicaci�n del c�mo (supongo que ser� con alg�n m�dulo o procedimiento de
Visual Basic del cual no tengo ni idea).
Muchas gracias por adelantado y un saludo.



Armando: l183568703@abonados.cplus.es

Re: 2 questions about MS-Access.

#422

Author: Steve Arbaugh
Date: Sun, 21 Dec 1997 00:00

25 lines
2229 bytes

Periquitin wrote in message <67h2bc$t0o$1@talia.mad.ibernet.es>...
>Hello!
>I would like to know if there is something like "triggers" in Access. I
have
>got a database accessed by a Visual C++ program through ODBC.
>The database has tables and relations, nothin else (it has not forms) and I
>do not know how to make some necessaries comprobations ( input masks and
>validation rules are not enough) nor where to make them.
>Another question. Is it possible to know what type of data structure
> B-trees, hash tables,...) use Access indexes? And change that type of
>indexes? How?
>Greetings and thank you very much.
>


�Hola! Aramdo:

No Access doesn't support "triggers" as you might think of them at the table
level.  You can set table validation rules, but generally only one per
table.  Re: indexes, the Jet engines index optimization routines are
propriatary, and no you can't change them.

Steve Arbaugh
ATTAC Consulting Group

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads