Create mdb and mdw

[Ralph Boswell]

Hi,

I would like to create secure databases, each database created linked
with a separated mdw file. Thus I create a database named whatever.mdb
with a corresponding whatever.mdw. I do not want to join an existing
mdw but create it on the fly and add specific users.

I have tried the following ADOX method :

catalog.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DbName
& ";Jet OLEDB:Create System Database=True;Jet OLEDB:System Database=" &
DbSystemName

DBname and dbsystemname being respectively the database name and the
associated mdw file name. the mdb is well created but no trace of the
mdw file.

Is the another way to do this simply. Any reference or code is welcome.

Thanks in advance,

Ralph

 

['69 Camaro]

Hi, Ralph.

Unless you know how to use the proprietary Jet API's, you won't be able to
code this. However, there's a free utility to create workgroup information
files. See the following Web page for the download and the instructions:

http://www.trigeminal.com/lang/1033/utility.asp?ItemID=13#13

If you absolutely must have the code to programmatically create the
workgroup information file, then please contact Q-Built Solutions to
purchase it.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Ralph Boswell]

Hi Gunny,

Used the trigeminal stuff. Seems to work.

Thanks,

Ralph

 

['69 Camaro]

You're welcome. Glad it helped.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)