Search results for query: *

Hello, all! If anyone needs this for future reference, here is the solution I created: Set reference to "Active DS Type Library" Private sub BackupToShare Dim psCompId As String Dim psBackupPath As String Dim psDirPath As String Dim psInfo As New ADSystemInfo Dim pb As...

Hello, all! I'm successfully using SQL DMO to create backups of my SQL database on my local machine. I can connect to our local network and manipulate server databases. Is there a way to create a .bak on my local disk of the server database? my abbreviated code: Dim poBackup As...

CCLINT - Good question. I almost automatically said yes since I cut and pasted. But I double checked to be sure that I had: CBool(catTbl.Tables(i).Columns(k).Attributes And adFldIsNullable) (Which was just cut and pasted from code). I had similar results with adFldMayBeNull. Perhaps to...

Thanks paulbent! Sorry, should have explained. I am using VB6 and ADO to document a SQL database. This is a very good lead, although I received 'False' back on every column (which is untrue). I'll start pursuing 'adFldIsNullable'. Thanks!

Greetings! I'm new to a company and will be doing some dataconversions. To get familiar with the data structure (and to dump it into rs) I've come up with: 'Loop through tables in Source to populate Result catTbl.ActiveConnection = cn j = catTbl.Tables.Count For i = 1 To j If...