Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
Set adox = CreateObject("ADOX.Catalog") Set Conn = CreateObject("ADODB.Connection") Conn.open "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=drops.accdb" adox.activeConnection = Conn For Each t In adox.Tables Wscript.Echo "TABLE," & t.Name & "," & t.Type For Each c in t.columns Wscript.Echo "COLUMN," & c.Name & "," & c.Type Next Next For Each p in adox.Procedures Wscript.Echo "PROC," & p.Name & "," & Replace(p.Command.CommandText,chr(13),chr(13)) Next For Each v in adox.Views Wscript.Echo "VIEW," & v.Name & "," & Replace(v.Command.CommandText,chr(13),chr(13)) Next Conn.close Set Conn = nothing Set adox = nothing
|UK Date format in MS Access||4||21|
|How search for records based on a specified date range||14||16|
|How to execute a SQL Server Stored Procedure from an Access front-end?||15||32|