Regarding Accessing External database using MS-Access and MS-Visual Basic

Regarding Accessing External database using MS-Access and MS-Visual Basic

Post by gbha » Wed, 01 Apr 1998 04:00:00

Hi from Srinivas
I have a problem when I have an attached a table from an external
Database(foxpro version 2.6 for Dos,*.dbf) to Access 2.0 database.I am
using Visual Basic on Windows-95.
I need to Delete or Update records in the external Database(Attached
Table) and want to reflect those changes in the attached table (i.e in
Access) using Visual Basic.
There are two ways of doing it.
1) Use a Tabledef object(Visual Basic) to create a attached table in
Access and then carry out necessary actions like Delete or Update on the
External table. But this Tabledef is Readonly and not letting me to
Delete or Update the attached External table.

This is the help in VB about deleting records for a Externally attached
Foxpro Database.
Deleted Records:
In most cases, if you Delete a record when working with External data,
the record is actually removed from the source table.  When working with
FoxPro tables, however, Deleted records aren't actually removed until
the table is packed using FoxPro commands or utilities.  The Jet
engine's CompactDatabase method of the DBEngine object works only on Jet
Databases; it has no effect on Microsoft FoxPro Databases.
You can tell the Jet database engine not to include deleted records by
setting the Deleted parameter of the initialization settings to True.
If you set the Deleted parameter to False, all records are included in
any Recordset objects you create, even deleted records.

I tried this by setting the Deleted Parameter = true in the
MsAccess20.ini(in windows directory)
I then opened the Access database and checked the external table. But
still I dont have the most recent or refreshed view of the external
This didnt work.

2) Use the OpenDatabase directly on the external database using the
Connect string and then open a Recordset and then carry out necessary
actions like Delete or Update on the External Table.
But still I dont have the most recent or refreshed view of the external
It works only when I open the Foxpro Database (version 2.6 for Dos) and
Pack and Reindex it.
Could someone suggest me is there any other way to get around this
problem.Should the external Database opened in Exclusive mode for action
related Queries(Delete or Update)
Which is the better method using Tabledef method or OpenDatabase method.



******** VISIT US AT ***********
Company    : Hall Kinion/RTP
Website    :
Location   : WILMINGTON, NC
Job Type   : Full-Time Salaried
HALL KINION/ Technical Recruiter-NEVER A FEE!

Hall Kinion is the largest full-service tech recruiting firm in the Silcon
Valleys of the world. We work with top technical companies to offer the best of
permanent and contract placements in North Carolina and across the United
States and the U.K.

2-5 years Visual Basic and RDBMS (Oracle, Sybase, Access or SQL Server).

Plusses: web technology experience, Java, Visual C++.

Multiple positions in Raleigh, NC or Wilmington, NC. Pay is excellent; good
learning opportunities too! Permanent, full-time opportunity!

Travel Required          :None
Educational Requirements :None
Required Skills
* Visual Basic
* MS SQL Server
Definite Pluses
* Java
* Visual C++
* Web Browser Technology
Why use me to find you the best job possible? IT SPECIALIST THAT WORKS WITH
OVER 1500 Companies Nationwide, (150 Locally) = THE BEST JOBS
Contact Information:
Reference : SJ113234
Debbie Bush

Phone: 800-365-3031
Fax No: 919-572-6550
***********************  ****************************

                The On-Line, On-Target Job Finder for Computer Professionals  

** Post Your Resume and see results immediately!! ** Always free **
** Post jobs for 30 days for $100, up to 250 postings $350/month
** Matching Resumes E-mailed daily
**  Your ads are virtually guaranteed to be seen by jobseekers on the NET **

                    ** Automatic Posting to **
   ** Yahoo            ** Americas Job Bank    ** Career City    *** ClassifiedsWarehouse
   ** HeadHunter.Net   ** Classifieds 2000     ** Usenet Newsgroups
               *** OVER 40 MILLION HITS/MONTH COMBINED !!! ***

***********************  ****************************

2. INGRES with VAX COBOL or 'C' Contract Vacancies

3. GA-Atlanta-98153--Visual Basic-MS ACCESS-RDBMS-ORACLE-Programmer-Visual Basic and Access

4. SQL Server 7 backup and recovery

5. Dynamic SQL

6. Visual Basic, Access Basic or MS-Access??

7. Searchable fields

8. WA-SEATTLE-89609--Visual Basic-MS ACCESS-UNIX-Database Integrator / VB, Access, Sybase

9. PLease someone help me, editing fields in Access database using MS Visual Basic 5.0

10. TX-HOUSTON-105339--Visual Basic-MS ACCESS-ORACLE-Web Development-Visual Basic Programmer/Analyst