help me check correct reference in Tools-References

[muybn]

After reloading Word, I lost the reference that allows the following code to
execute. It hangs up on "Dim dbDB As Database". If someone can let me know
what I shoud select under "Tools-References," I'd really appreciate it.
(Amongst others, I already have Microsoft Active X Data Objects 2.8 Library"
checked.)

Dim dbDB As Database
…
Set dbDB = OpenDatabase("[path & file]")
dbDB.Execute strSQL
dbDB.Close

 

[Russ]

I did a google search with the terms word and opendatabase and found this:

After reloading Word, I lost the reference that allows the following code to
execute. It hangs up on "Dim dbDB As Database". If someone can let me know
what I shoud select under "Tools-References," I'd really appreciate it.
(Amongst others, I already have Microsoft Active X Data Objects 2.8 Library"
checked.)

Dim dbDB As Database
Š
Set dbDB = OpenDatabase("[path & file]")
dbDB.Execute strSQL
dbDB.Close

 

[muybn]

Thanks, Russ. I found the DAO reference after reading your post. In the
meantime, I successfully switched the statement to utilize an ADO command to
perform the update to the table I was trying to accomplish. Is ADO considered
more "modern" than DAO, or not?

--
Bryan

I did a google search with the terms word and opendatabase and found this:

After reloading Word, I lost the reference that allows the following code to
execute. It hangs up on "Dim dbDB As Database". If someone can let me know
what I shoud select under "Tools-References," I'd really appreciate it.
(Amongst others, I already have Microsoft Active X Data Objects 2.8 Library"
checked.)

Dim dbDB As Database
Å 
Set dbDB = OpenDatabase("[path & file]")
dbDB.Execute strSQL
dbDB.Close

 

[Russ]

Off hand, I don't know. Do another google search.
Maybe someone else will reply.