Завершено

Access 2016 - Sybase / ODBC queries reqeusted

Some queries needet. Access Database/Middelware available.

Description

- MariaDB (MySQL) = Source = ODBC

- Access 2016 = Middelware / queries

- SybaseDB = Target = ODBC

Create and/or Update from one Table MariaDB to one Table SynbaseDB.

Both DB are connected per ODBC. Query in Access 2016. Only access via ODBC can be used.

Remote Access & Excelsheet (with Field/Label-Names) available.

Query I - Update/Create

Table FK_Kunde

Table vtiger_accountcd = if cf_1367 = 1 then update/create Record

Table vtiger_accountcd = if cf_1367 = 0 then ignore/nothing/end (important for performance)

if 1 then "Table FK_Kunde" update 120 Fields (Excelsheet with allocations)

end = set value vtiger_accountcd / cf_1367 = 0

(optional if meaningful? -> transfer Data to Access 2016 then to Synbase = that´s my favorit, otherwise direct write in target)

Query II - Trigger

Trigger "Query I" every 60 secounds, or other Update-Trigger-Way?

If possible = Action-Button in a small Form for Start/Stop (activate/deaktivate) Trigger

Query III - Set 1

Table vtiger_accountcd / cf_1367

Set all records = 1

Action-Button in a small Form

Query IV - Set 0

Table vtiger_accountcd / cf_1367

Set all records = 0

Action-Button in a small Form

Excelsheet attached.

Квалификация: Программирование баз данных, Microsoft Access, SQL

Показать больше access forms update odbc, access issues sql odbc, access vba check odbc connection, odbc error access, connect to sybase from sql server management studio, sybase odbc driver, microsoft ole db provider for odbc drivers download windows 10, sybase ase odbc driver connection string, access 2007 vba odbc, access 2007 vba odbc dao recordset, vba access 2007 query odbc, access 2007 vba odbc dao, access ado examples odbc, access 2007 vba odbc ado, access front end odbc linked tables, access vba check odbc, access 2007 vba odbc sql server 2008, access vba ado odbc example, microsoft access vba list odbc system dsn, access vba sql odbc

О работодателе:
( 3 отзыв(-а, -ов) ) Soltau, Germany

ID проекта: #18946530

Поручен:

kusal77

I have massive experience with DATA base queries and trigger. I am a Dedicated Senior .Net Developer and Database Administrator with 20 years of experience in Web/ Windows and Android Developments,Administration, Больше

€200 EUR за 3 дней(-я)
(9 отзывов(-а))
4.4

8 фрилансеров(-а) в среднем готовы выполнить эту работу за €165

Neno585

Hello, as a both SQL/Access developer, I can build your queries/action button to perform actions. All instructions in description are clear but not sure what should be done with the fields attached in excel file. If yo Больше

€105 EUR за 2 дней(-я)
(36 отзывов(-а))
7.5
Agiletechstudio

Hi there, Sir i read your initial requirements and i have some question regarding to your access project. please send me message so that we could discuss it further.

€100 EUR за 1 день
(21 отзывов(-а))
5.9
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Больше

€250 EUR за 4 дней(-я)
(17 отзывов(-а))
5.8
hardikshah83

Programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Microsoft SQL, Больше

€100 EUR за 3 дней(-я)
(31 отзывов(-а))
5.4
huseyinaygun

Dear Sir/Madam, I have relational database design and development experience of 10 years. I performed the following database related jobs: - Oracle Financials (Oracle EBS) Project - Cognos BI project (MSSQL) - Больше

€200 EUR за 3 дней(-я)
(4 отзывов(-а))
3.0
Webbleu

Hello Web have gone through your requirement and would to take this opportunity to work on this project. Can you send a detailed requirement about your project. I have done 557+ projects successfully an Больше

€155 EUR за 3 дней(-я)
(1 отзыв)
2.4
reosys7

"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on si Больше

€208 EUR за 7 дней(-я)
(0 отзывов(-а))
0.0