row handle, please help!

i have a join query (view) like this:
select h.*,d.Name from Users h, Employee d
where h.EmployeeId=d.EmployeeId (i mean for lookup Employee.Name only)
when i try to insert a record, it say "row handle refered to a deleted row
or a row marked for deletion"
but the record gone until requery. (the current record get posted). if i try
this from Sql servers enterprises manager this process sucessfull without
any complain.
please help.

thanks for attention and reply.
regards,
Iwan


.

Relevant Pages

  • Re: Still Struggling...
    ... In my opinion it should be in separate tables regardless. ... Then you would use DeptID and SubjectID as foreign keys in other tables. ... in the employee table and live with a few empty address fields. ... that will basically just be "lookup" tables. ...
    (microsoft.public.access.gettingstarted)
  • Re: Drop Down on Table
    ... I didn't want you to create a lookup in the table; ... What you really need is just Employee ID, ... When I highlight the Last Name then to Lookup, I put Display Control ... Joan Wild wrote: ...
    (microsoft.public.access.security)
  • Access Database Appointment Help
    ... Primary Key - Client ID ... Table 2 (Lookup ClosedDays) has the following characteristics: ... Table 3 (Lookup Employee) has the following characteristics: ... I need help with the user form - I really want it to be a secure database, ...
    (microsoft.public.vc.database)
  • Re: Missing Fields from report
    ... group for references to the second commandment with very informative results. ... the useful lookup table. ... when a employee is selected in the form's combo box. ... is perfectly normal to display that information in unbound ...
    (microsoft.public.access.reports)
  • Re: Lookup based on a date being between a range
    ... mary was in column a1 and b2 would be the pay rate or dollar amount in sheet1. ... I want to lookup the correct hourly rate of an employee in a table. ... I want to lookup the correct Rate for Mary based on the date she worked. ...
    (microsoft.public.excel.worksheet.functions)