Is ther an easier way to obtain and store record values from a table (in
Access '97) than the way shown below:
Dim DB As Database
Dim worksp As Workspace
Dim RS As Recordset
Dim appPath As String, dbName As String
appPath = "C:\"
dbName = appPath & "\db1.mdb"
Set worksp = DBEngine.Workspaces(0)
Set DB = worksp.OpenDatabase(dbName)
Set RS = DB.OpenRecordset("Table1", dbOpenTable)
temp_var = RS(1).Value
I'm hoping there's a way to not specify the database name and location,
since the database is only working with it's own tables. I just can't
seem to find it in the help files.
Please e-mail me directly if you can help.
Thanks in advance.