problem binding link tables and subforms in MS access 2007

[shandoo27]

hi,
I have successfully bound the sub forms in MS access to the tables present in the database and run the application .

Now i wish to have a bigger database and thus shifted to oracle for database.Thus i created tables in oracle database and linked them to MS access using ODBC . But now my subforms are not working at all . They are not showing the data properly and they are not editable too . I can't even add a new row through the sub form now . Could anyone guide me as to what problem it could be ?

Note: the link table names and the previous access tables names are the same .

 

[HiTechCoach]

Sounds like you have primary key issues. When linking, did you identify the primary key fields?

I would recommend looking at these articles:

ODBC


Curious, what version of oracle are you using?