Need to open a database from another database

[SpursGirl]

I need to be able to open a database from a macro on a form while already in one. Can anyone help?

[ADezii]

I need to be able to open a database from a macro on a form while already in one. Can anyone help?

The following Public Function will:

1. Open an External Access Database named Employees.mdb in the C:\Test Directory (C:\Test\Employees.mdb)
2. Print all the Last Names in the tblEmployees Table to the Immediate Window
3. If you so desire, a Macro within your Database can call this Function directly

Public Function fOpenExternalDatabase()
Dim wrkMySpace As Workspace
Dim dbExternal As DAO.Database
Dim rstExternal As DAO.Recordset
 
 'Create Microsoft Jet Workspace object
Set wrkMySpace = CreateWorkspace("", "admin", "", dbUseJet)
 
 'Open Database object from external Microsoft Jet database
'for exclusive use.
Set dbExternal = wrkMySpace.OpenDatabase("C:\Test\Employees.mdb", True)
 
Set rstExternal = dbExternal.OpenRecordset("tblEmployees", dbOpenDynaset)
 
rstExternal.MoveFirst
 
Do While Not rstExternal.EOF
  Debug.Print rstExternal![LastName]
  rstExternal.MoveNext
Loop
 
rstExternal.Close
dbExternal.Close
wrkMySpace.Close
 End Function

[NeoPa]

This'll confuse ADezii no end, but didn't we get robbed by the refs in UEFA this year?
Scanadalous!

Glad you got sorted here BTW. ADezii's our top man on macros and such.

[ADezii]

This'll confuse ADezii no end, but didn't we get robbed by the refs in UEFA this year?
Scanadalous!

Glad you got sorted here BTW. ADezii's our top man on macros and such.

This'll confuse ADezii no end, but didn't we get robbed by the refs in UEFA this year?
Scanadalous!

You are 100% right because I am totally confused. What exactly does the above-mentioned quote mean, Neo?

[NeoPa]

You are 100% right because I am totally confused. What exactly does the above-mentioned quote mean, Neo?

Spurs is the short name for a North London football team - Tottenham Hotspur. I'm guessing, with a name like SpursGirl, that the OP is also a fan.
We were (just) knocked out of the UEFA-Cup last week due to a number of consistently awful decisions by the refs in both legs (home and away). It would be no exaggeration to say that they were responsible for changing the score by about 5 goals to our detriment (As most of the decisions were penalties or free-kicks, it's impossible to be absolute). It's certainly true to say that we would have thrashed Sevilla with any sort of fair referee though. Even if only one of the legs was reffed fairly we would have got through without a problem.

[ADezii]

Spurs is the short name for a North London football team - Tottenham Hotspur. I'm guessing, with a name like SpursGirl, that the OP is also a fan.
We were (just) knocked out of the UEFA-Cup last week due to a number of consistently awful decisions by the refs in both legs (home and away). It would be no exaggeration to say that they were responsible for changing the score by about 5 goals to our detriment (As most of the decisions were penalties or free-kicks, it's impossible to be absolute). It's certainly true to say that we would have thrashed Sevilla with any sort of fair referee though. Even if only one of the legs was reffed fairly we would have got through without a problem.

Now I'm only partially confused!

[NeoPa]

Now I'm only partially confused!

Tell me which bit(s) are still confusing and I'll happily explain.