access to sql

[swamp]

Hi,

I have two access based programs
I joined the two databases and copied them in to an sql
database only problem here is that I had to change the
access date form in to text ....(small question)



Now I have removed all the tables in the access project
and linked all the tables that are now in sql data base by
using odbc
this all works very nice
I can get everthing open with my access program but I do
not seem able to add records (the big question)

what am I doing wrong?

thanks for your help

 

[Joe Fallon]

You need a Primary Key on each table to add and edit records.
Add PKs in SQL Server nad then delete and re-create the links.