Recent content by medaccess

  1. M

    link between access and excel

    Hi, I have an access database in which I have some fields which should be calculated from 2-3 excel sheets for each record. I have a field in access in which I attach the excel sheets for each record. It is difficult to calculate data through a function or macro in excel and then manually enter...
  2. M

    publish to access services

    Yes I feel that something is wrong. Customer ID number from table 1 linked to the same field (customer ID number) in table 2. None of them are PK. PK in tables 1,2 are record numbers but different fields (Customer record number and order record number). These are PKs, and order record number is...
  3. M

    publish to access services

    Hello, Thanks for the reply. I deleted the relationships to do that but it failed:( Simply: I have 5 tables: 1. Customer ID table (Record No (autonumber) as primary key). 2. order ID table (order record No (autonumber) as primary key). 3,4,5. features of order The links are one-to-many. customer...
  4. M

    publish to access services

    Hey guys, I created an access database. We decided to publish it on server to enable us use all the MS Access features. We gonna add new records online and view the records. I found that it is incompatible for publication Access services (error code: ACCWeb105016). My linked fields are numerical...
Top Bottom