Hi

My MS-Access 2003 "Form" is bind to a SQL server 2000 table but I
wonder why doesn't it accept the following command and displays an
error that "You can't go to the specified record". It works well with
MS Access tables but creates problem when the backend table belongs to
SQL server :

DoCmd.GoToRecord , , acNewRec


Can anyone help me with solving this problem.


cheers!!!

sajid_yusuf@yahoo.com wrote:[color=blue]
> Hi
>
> My MS-Access 2003 "Form" is bind to a SQL server 2000 table but I
> wonder why doesn't it accept the following command and displays an
> error that "You can't go to the specified record". It works well with
> MS Access tables but creates problem when the backend table belongs to
> SQL server :
>
> DoCmd.GoToRecord , , acNewRec
>
>
> Can anyone help me with solving this problem.
>
>
> cheers!!![/color]

Is the new record icon enabled on the form?

What is your recordsource?

Have you set an UniqueTable?

I know in A2000 you had to do some tricks to get your recordset to be
updable... (but that was released before SQL2000).
--
regards,

Br@dley

Does the SQL Server table have a primary key defined? (I suspect it does if
you can update existing records.) Can you open the Table in Datasheet View
and add a new Record? (If not, then it is likely a matter of user
permissions in SQL Server.)

Larry Linson
Microsoft Access MVP

<sajid_yusuf@yahoo.com> wrote in message
news:1140594075.314470.224480@f14g2000cwb.googlegr oups.com...[color=blue]
> Hi
>
> My MS-Access 2003 "Form" is bind to a SQL server 2000 table but I
> wonder why doesn't it accept the following command and displays an
> error that "You can't go to the specified record". It works well with
> MS Access tables but creates problem when the backend table belongs to
> SQL server :
>
> DoCmd.GoToRecord , , acNewRec
>
>
> Can anyone help me with solving this problem.
>
>
> cheers!!!
>[/color]

Larry Linson wrote:[color=blue]
> Does the SQL Server table have a primary key defined? (I suspect it
> does if you can update existing records.) Can you open the Table in
> Datasheet View and add a new Record? (If not, then it is likely a
> matter of user permissions in SQL Server.)[/color]

Of a BIT field that doesn't have a default value.....
[color=blue]
> Larry Linson
> Microsoft Access MVP
>
> <sajid_yusuf@yahoo.com> wrote in message
> news:1140594075.314470.224480@f14g2000cwb.googlegr oups.com...[color=green]
>> Hi
>>
>> My MS-Access 2003 "Form" is bind to a SQL server 2000 table but I
>> wonder why doesn't it accept the following command and displays an
>> error that "You can't go to the specified record". It works well with
>> MS Access tables but creates problem when the backend table belongs
>> to SQL server :
>>
>> DoCmd.GoToRecord , , acNewRec
>>
>>
>> Can anyone help me with solving this problem.
>>
>>
>> cheers!!![/color][/color]

--
regards,

Br@dley