Access add record command button not working with SQL backend

[falroc]

I created a Access 2007 database that had a add record command button that worked just fine until I split the database and made Sqlexpress 2005 the backend. Now, when I click on the add record command button all I get is the error "You can't go to the specified record. My question is why and what can I do to fix it?


Thanks in advance.

[ck9663]

There are a lot of reasons. Did you change your connection string? Can you properly connect to your db?

-- CK

[falroc]

Everything else works all other command buttons such as delete record. I can add a record when I have the datasheet view up and manually go to the last record(new). I have tried it with a macro and VBA and I get the same error both ways. I am really stumped.