ChloeRadshaw
06-07-2009, 06:08 AM
Ok - I admit it - I know very little about Access but am using it on a project at the moment.
I have two questions:
1) Why does Access force you to write [fieldName]???
2) have a table which I have imported data into and have specified the primary key column myself. This column contains Ids that have been generated and are not continuous. Is there any way to change this fields to AutoNumber but prevent Access from changing the Ids? Also presumably you need to tell access that the next free Id is > some number?
How is this done?
I have two questions:
1) Why does Access force you to write [fieldName]???
2) have a table which I have imported data into and have specified the primary key column myself. This column contains Ids that have been generated and are not continuous. Is there any way to change this fields to AutoNumber but prevent Access from changing the Ids? Also presumably you need to tell access that the next free Id is > some number?
How is this done?