ODBC, won't let me enter data in FP 2.6 table...

[43fan]

I'm linked to Foxpro for DOS 2.6 databases, using Access XP. It links the
db's/tables fine, but only to display. It won't let me enter data(or change
existing data) on a form, in the table, anywhere.

What am I doing wrong?

Thanks!
Shawn


--
It's not just based on number of championships won. Richard Petty won
200 races and 7 Daytona 500s in his 30+ year driving career. He also has
the most top-5s (555), top-10s (712), poles (126), laps completed
(307,836), laps led (52,194), races led (599) and consecutive races won
(10 in 1967) of any driver in NASCAR history.

 

[Cindy Winegarden]

In

I'm linked to Foxpro for DOS 2.6 databases, using Access XP. It
links the db's/tables fine, but only to display. It won't let me
enter data(or change existing data) on a form, in the table, anywhere.

Hi Shawn,

Have you tried using the VFP ODBC driver or OLE DB data provider? Both are
available from
http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx.

 

[43fan]

In

Hi Shawn,

Have you tried using the VFP ODBC driver or OLE DB data provider? Both are
available from
http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx.

Cindy,

Just downloaded it, and installed it. Is there something else I need to do
then? I'm very much a beginner when it comes to ODBC, and not very
knowledgeable. Just downloading and installing had no effect on my being
able to modify data(or even add new records) to the Foxpro 2.6 db's thru
Access.

Prior to this, I'd just "linked" to the db's, without using ODBC, and it
seemed to work. I'd used one of the dBase links.

What I'm also curious about is, do the .cdx files get updated in any way?
Or, when going back to FP 2.6, do I need to re-index the files to make sure
all indexes are in sync?

Thanks so much!
Shawn

PS - feel free to email at (e-mail address removed) or (e-mail address removed) if
you wish to answer there instead of here.

 

[Cindy Winegarden]

In

Just downloaded it, and installed it. Is there something else I need
to do then? I'm very much a beginner when it comes to ODBC, and not
very knowledgeable. Just downloading and installing had no effect on
my being able to modify data(or even add new records) to the Foxpro
2.6 db's thru Access.

Here's something I've posted before that may help. Not all of it may apply
to you:Start with the latest ODBC driver for FoxPro and Visual FoxPro, available
from http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx.
Download and install it. (If you have trouble doing this, post back.)



You will need to determine whether you have FoxPro "free" tables or a
"database container" (contains metadata about the tables themselves). To do
this, navigate to your data directory and look for the presence of a DBC
file. If it's there you have a "database" otherwise you have free tables.



Now open up the ODBC dialog. In WinXP it's Start > Administrative Tools >
Data Sources (ODBC). Choose either the User DSN or the System DSN. (The
difference lies in whether you want other people to be able to see it if
they use your machine.)



Click Add... Scroll down to the Microsoft Visual FoxPro Driver. Scroll over
to verify that it's version 6.01.8629.01. Click Finish.



Now you're at the ODBC Visual FoxPr Setup dialog. In the first box (Data
Source Name) enter a friendly name that you will use to recognise this data
source - My FoxPro Data Source. You can add more text in the description
box.



Below are two options. Choose Visual FoxPro database (.DBC) or Free Table
Directory - whichever you have determined is correct.



Browse to locate your directory, or your specific DBC file.



You can click the Options>> button for more choices. The defaults should be
ok. "Exclusive" refers to whether you want to have exclusive access to the
data while you're using it. "Null" allows you to enter Null values or not.
Older FoxPro tables do not allow Nulls. "Deleted" means to hide deleted
records. This one's important if you are working with primary keys - more in
a minute. "Fetch data in background" will allow you to see the first few
lines of a large tablel while the rest is being retrieved. You can also
indicate a collating sequence if you're using a non-English alphabet.



Click OK and you're done.



Now, about deleted records. When a record is deleted in a FoxPro or Visual
FoxPro table it's merely marked as deleted and filtered out, but is still
physically present in the table. If you have a unique index and you delete
the record with a key value of 123 you can not enter another record with
this value, even though you can't see the record. To get rid of records
entirely, you must issue a PACK command. However, the best rule to follow is
to not reuse primary keys.

<<