VB.NET 2009 1

[sanjay84]

I've searched the net many hours for code on how to create a new access database file (.accdb or .mdb) in VB 2008.

I've tried the method of creating a file and adding the .accdb or .mdb extension but it won't accept it because it hasn't the proper structure.

Anyone who has an idea?

 

[HarleyQuinn]

Something like this?

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[sanjay84]

something like that, I allready tried to insert that snippet it didn't work. haven't found a clear cause for it.

thanks for the suggestion

 

[HarleyQuinn]

Hmm, worked fine for me. Did it error for you? If so what message did it return?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[sanjay84]

ok i'm experimenting with the visual basic 2008 express edition.

I copy paste the code and get an error here:

Dim cat As Catalog = New Catalog()

type catalog is not defined, I think it doesn't accept the imports ADOX statement

 

[HarleyQuinn]

Have you set the COM reference to Microsoft ADO Ext. 2.7 for DDL and Security?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[sanjay84]

Nope, I've just read it on a MSDN article

thanks and next time I'll read the f*cking manual !

 

[HarleyQuinn]

No worries, glad you got it sorted

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.