Hi -

No idea if I should be concerned about this, but here goes anyway. SQL Express 2008, VDF 15.1 running on Win 7 Ultimate.

I've converted a System File to SQL Express. As with all converted, I did not convert Recnums.

SQL Exp. shows no Recnum field, Table Explorer & DBBuilder don't either. However, even after making a change to the table, the FD file still shows a Recnum field. On top of that, the INT file starts with field #8, instead of #1 like all the others.

I can save fields in the table & everything seems OK, but this doesn't seem right.

Table Explorer:

Click image for larger version. 

Name:	SysFile.PNG 
Views:	180 
Size:	3.6 KB 
ID:	3329

FD:

Code:
#REPLACE FILE1 SysFile
#REPLACE SysFile.Recnum |FN1,0
#REPLACE SysFile.CompanyName |FS1,1
#REPLACE SysFile.Address |FS1,2
etc.
Int:

Code:
DRIVER_NAME MSSQLDRV
SERVER_NAME SERVER=GARRET-PC\SQLEXPRESS;Trusted_Connection=yes;DATABASE=Yankee
DATABASE_NAME SYSFILE
SCHEMA_NAME dbo

SYSTEM_FILE YES
TABLE_CHARACTER_FORMAT ANSI
USE_DUMMY_ZERO_DATE YES

FIELD_NUMBER 8
FIELD_LENGTH 6

FIELD_NUMBER 9
FIELD_LENGTH 6
etc.
Any input appreciated -