Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Creating Database file w/o Access or SQL

 
   Database Help (Home) -> Visual Basic RSS
Next:  Rounding text box to 2 decimal places  
Author Message
Randy

External


Since: Apr 08, 2004
Posts: 2



(Msg. 1) Posted: Fri Apr 09, 2004 12:22 am
Post subject: Creating Database file w/o Access or SQL
Archived from groups: microsoft>public>vb>database (more info?)

When I had VB 6.0 there was a feature that allowed you to create an Access
DB file w/o access. I cannot find the same feature in VB.net 2003, and I
don't have access to Access or an SQL server. Does anybody know how to do
this?

Regards,

Randy.

 >> Stay informed about: Creating Database file w/o Access or SQL 
Back to top
Login to vote
Ivan Dormain

External


Since: Jun 15, 2004
Posts: 4



(Msg. 2) Posted: Tue Jun 15, 2004 11:20 am
Post subject: Re: Creating Database file w/o Access or SQL [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hey Randy


One way is to reference the "Microsoft ADO Ext. 2.7 for DDL and Security"
library, this will provide you with
a Catalog Object:

Dim obj As New ADOX.Catalog
obj.Create ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\sample.mdb")

This will create the sample.mdb file, then you have to create the database
objects (tables, etc)

Use appropriate params etc for your DB the above object also exposes:

Table
Group
Column
Index
etc..

Hope this helps.

"Randy" <r_galliano RemoveThis @yahoo.com> wrote in message
news:udhTHmdHEHA.3356@TK2MSFTNGP11.phx.gbl...
> When I had VB 6.0 there was a feature that allowed you to create an Access
> DB file w/o access. I cannot find the same feature in VB.net 2003, and I
> don't have access to Access or an SQL server. Does anybody know how to do
> this?
>
> Regards,
>
> Randy.
>
>

 >> Stay informed about: Creating Database file w/o Access or SQL 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Cannot Delete Pocket Access File - I'm creating a Pocket Access file (via an EVB application) on a mobile device running PPC 2002. When the user logs off the EVB application, I want to delete the Access file (stored in the /Temp folder). However, I am unable to do this because the..

Creating reports in VB6 - Hi All Please can you advise on the best way to create reports in VB6, my application is linked to a MySQL database. I want to create a Purchase Order Report from a query linking 4 different tables what is the easiest way to do this. Cheers

reading a text file? - Help! :( Is there a way to automate the importation of a text file in to VB, with out having to use the import text wizard every time? Below is a sample the the file and the inofrmation I need. ( the file is actually much larger then this) but this wil...

how do u open a word file in VB?? - hi, i want to open a word file in my c drive. how do i do that in VB? i want to open it when i click a button. thanx devin

I need help with some VB or SQL programming for a database. - I need some VB or SQL coding to finish up an access database program. I am trying to choose selected records from an access table based on certain criteria. Example: 2 records needed out of 4 total records and the code should choose the 2 records with...
   Database Help (Home) -> Visual Basic All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]