Desarrollo de bases de datos con Access
Utilizo Access 97/2000 para desarrollar Bases de datos relacional. El uso de los lenguajes 'SQL','Visual Basic' y ADO me permiten crear base de datos a medida de los proyectos
Ejemplos:
SQL:
SELECT Count([Tour Operator_UK_Atol_Market Intelligence].[Turks and Caicos Islands])
AS [CountOfTurks and Caicos Islands] FROM [Tour Operator_UK_Atol_Market Intelligence]
WHERE ((([Tour Operator_UK_Atol_Market Intelligence].[Turks and Caicos Islands])=-1))
VBA:
'Display Message Box
Private Sub Company_Exit(Cancel As Integer)
If IsNull(COMPANY) Then
msgbox "'Company' field needs to be filled-out!", vbCritical + vbOKOnly
End If
End Sub
ASP:
Conexion de BBDD:
<%@ Language = "VBScript"%>
<%Set Connectiondb = Server.createObject ("ADOdb.Connection")
Connectiondb.Open "DRIVER = {Microsoft Access driver (*.mdb)};" &
"DBQ=" & Server.Mappath ("/CTO Main Database")%>