Adding Record

[Ravi]

Hi I am connecting to a SQL server using access project.
I created a form and use the wizard to create a button to
add a record. The problem I am having is when I attempt
to add a record, Like access 2000, access projects does
not go to a blank field for me to add a new record. I
does not autonumber either. Can someone please help me.
Thanks.

Ravi

 

[Rod Gill]

Hi,

This is a Microsoft Project group. See access.adp.sqlserver group.

Your answer though is likely top be that you must have a primary key in your
tables for an Access Project to add new records.

--
Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/