Problem with liked tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have change my access db so my tables is in a SQL server
in my db i have a form and in this form i have another form
the second form get ots values from a uodate query this work fine
when the tbale is in ACCESS but not if the tables are on my SQL
server, and in the first form i have some fields there take the value
from the second form and calculate them, this work also if the tables
are in ACCESS but not if the table are on my SQL server?

Maybe some one can help? If there a way ?

regards
Alvin
 
Hi
Now i have make it so its works(a littel bit)
in my form i have this cobobox and when i selct a value in this
normally the other fields change after this value, but when i use
linked table to my sql i have to change another field and when i do that
i get this message "another user have make a change in the table " when i
hit the "ok" button then all works fine all my update and so on, but why
dosn't it work in the first combobox ?

regards
alvin


"alvin Kuiper" skrev:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best way to deploy Access read-only database that is linked to SQL tables 6
sql db default value in access 1
Insert Into a SQL table via Access 2007 8
Access Passing the value to a table 1
SQL Server Backend: linked tables or no more bound forms ? 4
SQL Upsizing Problem with Left Join Queries 19
DELETE FROM a table WHERE... 1
sql server linked table not accurate 7

Back
Top