Value from outside DB

[Katrina]

I have a database that will be stored on various people's
hard drives. I have the master version of this database
stored on the network. What I would like to do is to have
the hard drive database look onto the network to get a
value (from a query or form) and display it on a form. (I
am using it to compare versions of the DB)

Is this possible?

Katrina

 

[Marshall Barton]

I have a database that will be stored on various people's
hard drives. I have the master version of this database
stored on the network. What I would like to do is to have
the hard drive database look onto the network to get a
value (from a query or form) and display it on a form. (I
am using it to compare versions of the DB)

There seems to be a misperception here.

Forms just present a formatted view of data, they are not a
data repository.

Queries are just a mechanism to retrieve (selected) data
from a table, they too are not a data repository.

Tables are where data is stored.

If your question is how to check data in another database
(not necessarily open), then you can use VBA and DAO to open
a recordset that retrieves the selected data. One way might
look something like this air code:

Dim db As DAO.Database
Dim rs As Recordset
Dim strSQL As String
Set db = CurrentDb()
strSQL = "SELECT versionfield FROM sometable " _
& "IN ""path to other db"" "
& "WHERE keyfield = " & somevalue
Set rs = db.OpenRecordset(strSQL, dbOpenDynaset)
If thisversion <> rs!versionfield Then
'different version
End If

rs.Close : Set rs = Nothing
Set db = Nothing

 

[Chris Nebinger]

You might also want to have a look at syncronization.


Chris Nebinger

 

[Guest]

I don't really know what you mean by this.

-----Original Message-----
You might also want to have a look at syncronization.


Chris Nebinger


.

 

[Katrina]

Thanks, I'll try that

-----Original Message-----



There seems to be a misperception here.

Forms just present a formatted view of data, they are not a
data repository.

Queries are just a mechanism to retrieve (selected) data
from a table, they too are not a data repository.

Tables are where data is stored.

If your question is how to check data in another database
(not necessarily open), then you can use VBA and DAO to open
a recordset that retrieves the selected data. One way might
look something like this air code:

Dim db As DAO.Database
Dim rs As Recordset
Dim strSQL As String
Set db = CurrentDb()
strSQL = "SELECT versionfield FROM sometable " _
& "IN ""path to other db"" "
& "WHERE keyfield = " & somevalue
Set rs = db.OpenRecordset(strSQL, dbOpenDynaset)
If thisversion <> rs!versionfield Then
'different version
End If

rs.Close : Set rs = Nothing
Set db = Nothing