>Here's a new one on me.
>
>1. Create a new table in an existing database. Add a few records to the table. The database and the table are on a network in the same folder. modi database shows the table is in the database.
>
>2. run "validate database recover". Every cks OK.
>
>3. run "select * from newsurveys!surveyyears where _year < gnRptYear order by _year"
>Produces an error that says there is no backlink from the table to the database, would you like to create one? ANS Yes.
>Followed by an error that says the table must be opened exclusively.
>
>Can anyone explain this to me?
>
>Thanks

1. Make a backup.

2. Try to open SurveyYears table. Would it prompt you for backlink?

In Create table statements always add FREE clause if you want to create a temp table (though why would you want to do it?)