s_Generation Import error

[Max]

I am importing records from an old DB to a new FE. Both tables are Access97
and have exactly the same design. The code is designed for users to upgrade
remotely.

I am using the following SQL:

INSERT INTO PatientOutcomes SELECT * FROM PatientOutcomes IN
'D:\ORAC\Installations\Warr\Logdat97.mdb' WHERE ((PatientOutcomes.PatientID)
Is Not Null);

This triggers a message:

The microsoft Jet engine does not recognize 's_Generation' as a valid field
name or expession.

I am not using replication and neither of the tables contain this field. I
have repaired and compacted both databases.

Any suggestions?

Thanks,
Max

 

[Joan Wild]

I am importing records from an old DB to a new FE. Both tables are
Access97 and have exactly the same design. The code is designed for
users to upgrade remotely.

I am using the following SQL:

INSERT INTO PatientOutcomes SELECT * FROM PatientOutcomes IN
'D:\ORAC\Installations\Warr\Logdat97.mdb' WHERE
((PatientOutcomes.PatientID) Is Not Null);

This triggers a message:

The microsoft Jet engine does not recognize 's_Generation' as a valid
field name or expession.

I am not using replication and neither of the tables contain this
field. I have repaired and compacted both databases.

That old DB was replicated at some point. You can hunt around
www.trigeminal.com for more information.

In the meantime, you should be able to get the data by specifying the fields
in the SQL statement rather than using '*'

 

[Max]

Thanks for your input Joan.

That old DB was replicated at some point. You can hunt around
www.trigeminal.com for more information.

In the meantime, you should be able to get the data by specifying the
fields
in the SQL statement rather than using '*'