Refer to Another Database

[DougAtAvalon]

How do I Refer to another database record. Would I use SQL? what is the syntax if I know the path and name of db, the table name, and I guess the record wor\uld be criteria?

-Doug

 

[MichaelRed]

You need to dimension and set references to the other db. method and syntax are the SAME as refering to current db, argument for the db needs to be the whole entire complete path filename (incl ".MDB&quot. There after, the objects (tables and queries) appear and operate the same as local objects. This is the "classic" for splitting a db into front/back end, so look at references for this for additional help.

MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[DougAtAvalon]

This is my code and vNetWorkPath is a full path with ".mdb"

***************
Public Function GetSecurityOnOff(vNetworkPath)
GetSecurityOnOff = "On"
Dim vSecurityValue
Dim dbs As Object
Dim vRecordset As Object

Set dbs = vNetworkPath

SQLstring = "SELECT DefaultSettings.*, DefaultSettings.DefaultID FROM DefaultSettings WHERE DefaultID = 'SecurityOn'"

Set vRecordset = dbs.OpenRecordset(SQLstring)
With vRecordset
vSecurityValue = ![DefaultValue]
End With

Set vRecordset = Nothing
Set dbs = Nothing
End Function
******************


I get a "Object does not support this property or method" error. I guess cause it's seeing "networkpath".Openrecordset(SQLString) which isn't correct

-Doug ?

 

[MichaelRed]

Dim dbs As Object <== Should be database
MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over