Search results

  1. S

    How to keep access link after upsizing

    I am currently transfering two access DB, A and B, to SQL Server. Using Upsizing wizard, the job was completed. However, one of tables in Access DB A has Access link to one of tables in DB B. Can we keep the link in SQL Server? If the link is still existing in SQL DB, how can I check the link is...
  2. S

    First step to design Database?

    We currently have corporate level Oracle DB server in corporate headquarter. And corporate level decided us (Business Analysts) to limit our accessing DB, because of the burden of data transaction. Therefore, we decided to make a small MS Access DB into network drive, download monthly some parts...
  3. S

    Call Access Table from Excel?

    I am trying to make an KPI(Key Performance Indicator) Excel file. from the each cell, I like to call multiple tables with a conditional query. Is this possible? Best regards, Suk
  4. S

    Import error.

    Where is usually debug file located? I am currently importing Excel file, and getting an error. It doesn't have a specific informations. Thanks,
  5. S

    access decentralized mdb files

    I am a business analyst. I am currently thinking about the best way to access decentralized mdb files. We actually have 9 different analysts. their monthly jobs are usually with following processes: 1) Run different queries from Oracle DB to make specific raw data 2) Download it to their PC 3)...
Back
Top Bottom