Migrating from MS ACCESS 97 to SSEv

Tech-Archive recommends: Fix windows errors by optimizing your registry

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


.

Relevant Pages

  • RE: Database File Locations
    ... we cannot detach a database file from the service. ... Is it the SQL Express? ... a database file and copy it to a production server, ... Microsoft Online Community Support ...
    (microsoft.public.vsnet.general)
  • Re: SQL Server 2000 SP4: Memory leak or normal performance?
    ... I'm not an SQL person at all but I've been ... Being that it's a server with 4GB RAM and we're not making use of the ... I was starting to think it was the size of the database file ... The database size is not causing any memory bloat. ...
    (microsoft.public.sqlserver.setup)
  • Re: Local datastore for visual basic .net aplication on a pda
    ... You don't need a backend server to use ... > most of the database access controls and etc available on the full .net ... here's my questions: Is there any way to use an sql ... > database file as an local datastore without the SQL server running? ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: MS SQL Database Question
    ... > I have shared hosting that can support SQL databases. ... With SQL 7 and above, you can detach a database file from the server, ...
    (microsoft.public.inetserver.asp.general)
  • Re: Log Button Clicks?
    ... Now I just have to determine if my writing to the log file is going ... to interfere with IIS writing to the logs. ... >> Web Developer / Programmer ... > database file also. ...
    (microsoft.public.dotnet.framework.aspnet)