I've got an Access 2003 database linked to a SQL Server 2000 database. In SQL Server (Enterprise Manager) - the field is listed as:Data Type: text, Length: 16, Allow Nulls = YesIn Access, the ...

I have created a report in an adp based on a query of a settlements table i have in my database. The field i am having trouble with is a calculated fields sum dropping cents. The field is ...

Still, you can also specify the field you want as the primary key for your database table. The Primary key in Microsoft Access is a field or set of fields with unique values throughout the table.