Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tanvir ahmad
  Where is tanvir ahmad?
 rajnandgaon
 India
 tanvir ahmad
 To: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 Tags
Subject: RE: Create Access Database at runtime
Thread ID: 249087 Message ID: 249098 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: General VFP Topics
Date: Monday, December 28, 2009 12:59:01 PM         
   


> > Hi experts
> > i m using Access Database as back end.
> > when user change financial year, i need to create new database and table in access.
> > How i Create Access Database and tables at runtime in VFP ?
> >
>
> Hi Tanvir,
>
> You can probably use AdoX.Catalog.Create() - untested:
>
> Local oCatalog As AdoX.Catalog
> oCatalog = NEWOBJECT('AdoX.Catalog')
> oCatalog.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\test55.mdb")
> 

>
> (FWIW, I agree with Martin that access.MDB is probably not the very best back-end format in the world.)
>
>
> hth
> -Stefan

hi
my client demanding ms access or sql database, but they are using only two or three pc in LAN, all pc have os xp-sp2 , they can't use ms sever.

ENTIRE THREAD

Create Access Database at runtime Posted by tanvir ahmad @ 12/28/2009 10:46:28 AM
RE: Create Access Database at runtime Posted by Martin Krivka @ 12/28/2009 11:04:22 AM
RE: Create Access Database at runtime Posted by Stefan Wuebbe @ 12/28/2009 11:54:53 AM
RE: Create Access Database at runtime Posted by tanvir ahmad @ 12/28/2009 12:59:01 PM
RE: Create Access Database at runtime Posted by tushar @ 12/28/2009 1:17:24 PM
RE: Create Access Database at runtime Posted by M. Akram Bhatti @ 12/28/2009 1:29:05 PM
RE: Create Access Database at runtime Posted by ho me @ 12/28/2009 2:32:01 PM