ODBC connected attribute ???


G

George

Hello to everybody,
I have an Access97 Database with
ODBC-connected tables to a SQL Server (7.0)
I created a form wich links automatically
the SQL Server tables to my mdb file.
That's ok.So far so good.
But when i try to delete the links,checking
the Tabledefs Attribute if it is equal to
dbAttachedODBC,I notice that no table has
this specific attribute.
Why? They are linked via ODBC.....
The long value of dbAttachedODBC is 536870912
My tables attribute is 537001984....and there is
no attribute with this number associated.

I apreciate any help/suggestion

Thanks in advance!
George
 
Ad

Advertisements

U

Uwe Ricken

J

Joe Fallon

'This procedure deletes all linked ODBC table names in an mdb.
Public Sub DeleteODBCTableNames()
On Error GoTo Err_DeleteODBCTableNames

Dim dbs As Database, tdf As TableDef, I As Integer
Set dbs = CurrentDb
For I = dbs.TableDefs.Count - 1 To 0 Step -1
Set tdf = dbs.TableDefs(I)
If (tdf.Attributes And dbAttachedODBC) Then
dbs.TableDefs.Delete (tdf.Name)
End If
Next I

dbs.Close
Set dbs = Nothing

Exit_DeleteODBCTableNames:
Exit Sub

Err_DeleteODBCTableNames:
MsgBox ("Error # " & Str(Err.Number) & " was generated by " & Err.Source
& Chr(13) & Err.Description)
Resume Exit_DeleteODBCTableNames

End Sub
 
D

david epsom dot com dot au

537001984 = 536870912 + 131072
= dbAttachedODBC + dbAttachSavePWD
= &H20000000 + &H20000

(david)
 
Ad

Advertisements

L

Lyle Fairfield

Hello to everybody,
I have an Access97 Database with
ODBC-connected tables to a SQL Server (7.0)
I created a form wich links automatically
the SQL Server tables to my mdb file.
That's ok.So far so good.
But when i try to delete the links,checking
the Tabledefs Attribute if it is equal to
dbAttachedODBC,I notice that no table has
this specific attribute.
Why? They are linked via ODBC.....
The long value of dbAttachedODBC is 536870912
My tables attribute is 537001984....and there is
no attribute with this number associated.

I apreciate any help/suggestion

Thanks in advance!
George
Attributes generally may be combined.
That is we may be both sexy and intelligent.
If Sexy is 1 and Intelligent is 2 then our attributes will be (at least)
1 Or 2
=
3
(Note
2 Or 6
<>
8)

To check for a specific attribute we often use
Attributes And SpecificAttribute = SpecificAttribute
(we should be able to use just Attributes And SpecificAttribute but why take
chances with a company famous for being perverse?)

Note that
537001984 And 536870912
=
536870912

The base 16 (hex) manisfestation of these numbers allows us to grasp
their relationship a bit more intuitively:
20020000 20000000

And, of course the base 2 (bin) notation is clearest of all:
100000000000100000000000000000
100000000000000000000000000000

You can see that we are actually just checking to see which switches are
turned on, or which flags are up, or which voltages are great enough to
register.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top