Thread Subject:

Create Access Database in Matlab using active x server

I have been using the following commands to use an existing Microsoft Access database:
fn = 'test.accdb';
svr = actxserver('access.application');
adb = svr.DbEngine.OpenDatabase(fname);

This works great. How do I create a new database? I have tried the following:
svr.Application.DBEngine.CreateDatabase('test2.accdb')
I get the following error:
No method 'CreateDatabase' with matching signature found for class
'Interface.Microsoft_DAO_3.6_Object_Library._DBEngine'.

Any ideas?

You want to use m-code to CREATE a new database? Hummmm, not sure you can do that. Why not just create the DB, using MS Access itself, and do your database stuff in your database. THEN, connect to the DB and do your Matlab stuff in Matlab. That's how I'd do it. Check out these links for some ideas of how to use Matlab to connect to Access:
http://www.tristanfletcher.co.uk/Matlab%20Access.pdf
http://www.mathworks.com/help/database/ug/database.html
http://www.mathworks.com/matlabcentral/newsreader/view_thread/277424



"Molly " <matlabquestions@gmail.com> wrote in message <k3qhu7$r31$1@newscl01ah.mathworks.com>...
> I have been using the following commands to use an existing Microsoft Access database:
> fn = 'test.accdb';
> svr = actxserver('access.application');
> adb = svr.DbEngine.OpenDatabase(fname);
>
> This works great. How do I create a new database? I have tried the following:
> svr.Application.DBEngine.CreateDatabase('test2.accdb')
> I get the following error:
> No method 'CreateDatabase' with matching signature found for class
> 'Interface.Microsoft_DAO_3.6_Object_Library._DBEngine'.
>
> Any ideas?

According to the CreateDatabase doc you must supply a second argument (that specifies a locale).

Within VBA this would be something like
Application.DBEngine.CreateDatabase('test2.accdb',dbLangGeneral)

Since MATLAB doesn't recognize the dbLangGeneral constant (nor its cousins) you need to do a little work to find what that (string) constant is defined as.

It seems that the following works:
>> svr = actxserver('Access.Application');
>> createdDB = svr.DBEngine.CreateDatabase('test2.mdb',';LANGID=0x0409;CP=1252;COUNTRY=0');

Phil.