Opening workspace with different MDW file

[Webtree]

Hi All

I am trying to open a workspace with a seperate MDW file so I can
create a DB file for data exchange. 2 locations have different MDW
files for each location and need to exchange data. That data needs to
be protected, so I want a secured MDB file to transfer it across.

However I can't guarantee any users being present in either MDW. So I
thought a shared seperate MDW file, but i can't find a way using the
run time to create a db nevermind with a seperate mdw file.

PLEASE HELP ME

Many thanks
Mark

 

[Graham Mandeno]

Hi Mark

Try this:

Dim dbe as PrivDBEngine
Dim wks as Workspace
Dim db as Database
Set dbe = New PrivDBEngine
With dbe
.SystemDB = "C:\MyWorkgroup.mdw"
.DefaultUser = "Mark"
.DefaultPassword = "MarksPassword"
Set wks = .Workspaces(0)
End With
Set db = wks.CreateDatabase(...)

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.