Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: surinder singh
  Where is surinder singh?
 mumbai
 India
 surinder singh
 To: Angelo Andales
  Where is Angelo Andales?
 Manila
 Philippines
 Angelo Andales
 Tags
Subject: RE: MS Access Table
Thread ID: 155225 Message ID: 155242 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Microsoft Office Automation
Date: Friday, December 28, 2007 12:03:40 PM         
   


check:
http://www.tek-tips.com/faqs.cfm?fid=5002
https://www.foxite.com/archives/0000070628.htm

> > Hello foxpert,
> >
> > I have program in VFP 9 that needs to open database made in MS Access, Can you please give me an idea on this matter, I really don't have any idea in opening database and tables made in Access programmatically, for this program I need to delete all records first to made sure that table are always fresh, and add all records from table in VFP to MS Access one by one. Help me please. Thanks in advance.
> >
> > Amphie S. Lucas
>
> Merry Christmas and Happy New Year to you Amphie Lucas.
>
> Why did you use MS Access in the first place. VFP already have a Database.
>
> You can visit this site for you to have background on MS Access
> http://www.bcschools.net/staff/AccessHelp.htm
>

>
> Based on your statement that You need to delete all records first to make sure that table are always fresh, and add all records from table in VFP to MS Access on by one. I'm thinking of a backup file, is that what you want? you can create another table in your VFP and set it as your achieve file where in all your data will be stored from the start of your business / company until what data you want.



-----------------------------------------------------------------------------------------------
Regards
Surinder Singh
Email: sur200@indiatimes.com
----------------------------------------------------------------------------------------
*If you understand what you're doing, then you're not learning anything.

ENTIRE THREAD

MS Access Table Posted by Amphie Lucas @ 12/28/2007 8:15:25 AM
RE: MS Access Table Posted by Angelo Andales @ 12/28/2007 10:46:54 AM
RE: MS Access Table Posted by surinder singh @ 12/28/2007 12:03:40 PM
RE: MS Access Table Posted by Amphie Lucas @ 12/29/2007 7:48:34 AM
RE: MS Access Table Posted by Angelo Andales @ 12/29/2007 1:17:08 PM
RE: MS Access Table Posted by ruel parayno @ 12/29/2007 2:54:49 PM
RE: MS Access Table Posted by Angelo Andales @ 12/30/2007 2:47:46 PM
RE: MS Access Table Posted by ruel parayno @ 1/3/2008 3:10:22 PM
RE: MS Access Table Posted by Amphie Lucas @ 1/2/2008 4:16:18 AM