What are the parameters for the DAO OpenDatabase method?

[David Anderson]

I have an Access 2000 app that I have just split into a front and back end,
with all the tables in the back end. Both databases have User-Level Security
enabled. I make frequent use of the Seek method in my app and this no longer
works after the split. My Access bible is the Access Developer's Handbook by
Litwin, Getz & Gunderloy and this tells me to expect such problems but also
states that I can resolve it by using the OpenDatabase method of the DAO
Workspace object.

Unfortunately, the online help system for Access 2000 has been very flaky on
my PC ever since I installed Access 2007 and I can't look up how to use the
OpenDatabase method. I've also failed (so far) to find any guidance in the
MS knowledgebase. Can anyone please point me in the right direction. To be
more specific, what exactly do I put between the brackets at the end of the
following line of code to identify my back end database?

Set MyDB = DBEngine.Workspaces(0).OpenDatabase(??????????)

David

 

[David Anderson]

I found the answer just after posting to the newsgroup! I used the full path
to the back end database file, with a double-quote mark at each end. Not
sure why I didn't try that before, but it's after midnight here in the UK
and my brain is shutting down for the night...

David

 

[Douglas J. Steele]

While it only mentions Access 97, the method shown in
http://msdn.microsoft.com/archive/d...97/html/microsoftaccessuser-levelsecurity.asp
will work for Access 2000 as well.