Peter,
You cannot use ADONET to create an Access database.
However if it is there you can use it, did you see this sample.
http://www.vb-tips.com/default.aspx?...1-d6dda3c888c8
I saw that you saw the link to ADO
ADO had in past some very famous football players.
I think that the most famous player was Ad Mansveld but he is not the only
one, however I can be wrong in that. It was a long time ago, in the time
there was also DOS which was number 4 and that kind of clubs.
Just after the introduction of proffesional footbal in holland and before
that.
However, I am not from theHague, I am and was never a real football fan.
Cor
"Peter Schoots" <Pe**********@discussions.microsoft.com> schreef in bericht
news:9E**********************************@microsof t.com...
I am trying to create an Access database in code. In VB6 I used the
following code to create a ADO database.
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strFileName & ";" & _
"Jet OLEDB:Engine Type=5")
How is this done for ADO.net?
With respect of the Query question: I used for a DAO database the
following
line to store a query.
newQdf = db.CreateQueryDef("StartingDate", strSql)
What is the equivalent for ADO? (I don't mean ADO.NET but the "old" ADO)
Peter Schoots
"Cor Ligthert [MVP]" wrote:
Peter,
In addition to Chris, you need to know what database for that.
However we have some samples on our website for that.
http://www.vb-tips.com/default.aspx
Search or take the AdoNet part.
I hope this helps,
Cor
"Peter Schoots" <Pe**********@discussions.microsoft.com> schreef in
bericht
news:92**********************************@microsof t.com... >I am an amateur programmer and trying to move from VB6 to VB.net.
>
> I can't figure out how to create a ADO.NET database in code. I know
> how
> to
> create a dataset and wonder whether there is a way to "export" it into
> a
> new
> empty database.
>
> Since I am at it: How do you programmatically store a query into an ADO
> database?
> I am using ADOX to create an ADO database.
>
> Thanks for any help.
>
> Peter Schoots