Migrating from MS ACCESS 97 to SSEv

  • Thread starter Thread starter Garry
  • Start date Start date
G

Garry

I am writing an application to migrate an Access 97 database file to SQL
Server Everywhere database file in VB.NET
I have code that builds the required tables in a new SSEv database file,
"CREATE TABLE", but am stumped at not being able to detect if the Access
field is AUTOINCREMENT.

I use standard methods to connect to the Access database, ADODB

The code field.Properties("ISAUTOINCREMENT").Value always returns false
even when the property value is AutoNumber in Access.
Also field.Properties("KEYCOLUMN").Value always returns False even when a
field is the primary key.

Does anyone have any solutions.

ADOX did not help either giving similar results



Garry
 
¤ I am writing an application to migrate an Access 97 database file to SQL
¤ Server Everywhere database file in VB.NET
¤ I have code that builds the required tables in a new SSEv database file,
¤ "CREATE TABLE", but am stumped at not being able to detect if the Access
¤ field is AUTOINCREMENT.
¤
¤ I use standard methods to connect to the Access database, ADODB
¤
¤ The code field.Properties("ISAUTOINCREMENT").Value always returns false
¤ even when the property value is AutoNumber in Access.
¤ Also field.Properties("KEYCOLUMN").Value always returns False even when a
¤ field is the primary key.
¤
¤ Does anyone have any solutions.
¤
¤ ADOX did not help either giving similar results

Using ADOX it is a COLUMN object property called AUTOINCREMENT and not ISAUTOINCREMENT.


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top