PING: Cindy Winegarden

[43fan]

Cindy,

I post this directly to you because you were the only one to answer my
previous post about the ODBC problem. I've checked and I am running the
most recent driver. I'm the guy with the FP2.6 databases that I want to
link to from Access.

If I just link them using the internal driver for Access(for dbase files)
everything seems to work fine. I can add/change data in an Access form(or
directly in the table for that matter). But, if I use ODBC, I can "see" the
data if it's been added/changed in Foxpro, but I can't add new records, or
change existing data through an Access form(nor directly in the table view).

What could be causing this? Or, is it just a function that ODBC won't allow
with FP databases that old?

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.

 

[Joe Fallon]

Try adding a psuedo index in Access if you want to write to the tables.
Without a Unique Record Identifier, Access opens the tables as Read Only.

You can create a "Fake" index in Access that tells Access which columns make
a Unique record in the linked table. The index is only used by Access is
completely unknown to the Server.

The following example creates an index on an ODBC linked table. The table's
remote database is unaware of and unaffected by the new index. The following
example won't work if you simply paste it into Microsoft Access; you first
need to create an ODBC linked table called OrderDetailsODBC.

(CREATE INDEX Statement in Help has some examples)

CREATE UNIQUE INDEX OrderID ON OrderDetailsODBC (OrderID);

 

[Cindy Winegarden]

Hi Shawn,

There's no reason to post to a specific person. Doing so might actually
discourage others who might have something to add from joining in. Also, I
don't know the answer to every question, and I don't always have time to
read and answer questions.

 

[43fan]

Joe,

I'm not sure how to use the code you provided, or where to put it/do it,
etc... If I try to create an index using the design portion of the table, it
says this option isn't allowed with a linked table. Where/when would I run
the code to create the index?

Shawn

 

[Joe Fallon]

You write a query and paste it in as the SQL command. Then just run the
query.