Suoritettu

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.

Taidot: Tietokantaohjelmointi, Microsoft Access, SQL

Näytä lisää: 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

Tietoa työnantajasta:
( 1 arvostelu ) Soltau, Germany

Projektin tunnus: #18946530

Myönnetty käyttäjälle:

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, Lisää

€200 EUR 3 päivässä
(2 Arvostelua)
2.6

9 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

€105 EUR 2 päivässä
(35 arvostelua)
7.4
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. Lisää

€250 EUR 4 päivässä
(14 arvostelua)
5.6
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 päivässä
(19 arvostelua)
5.3
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, Lisää

€100 EUR 3 päivässä
(24 arvostelua)
5.3
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) - Lisää

€200 EUR 3 päivässä
(4 arvostelua)
2.9
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 Lisää

€155 EUR 3 päivässä
(1 arvostelu)
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 Lisää

€208 EUR 7 päivässä
(0 arvostelua)
0.0
techbluesoft1

"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 Lisää

€208 EUR 7 päivässä
(0 arvostelua)
0.0