473,725 Members | 1,720 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

AIUTO: Collegamento tabelle MySql ad Access

Ciao a tutti...
Premetto che non sono molto pratico di MySql (anche se ho già fatto
qualche piccola applicazione che sfrutta questo DBMS)
Ho un problema da risolvere molto importante.
Ho un DBMS MySql dove sono presenti solo i dati (le tabelle). In un
DataBase Access 2000 ho creato le maschere per la gestione e le varie
stampe per l'analisi. Al Database Access devo collegare le tabelle
presenti nel Db MySql. Il tutto gira su Pc con Windows 2000
PICCOLA PARENTESI:Prima avevo anche i dati in formato access, ma ora
per motivi di accesso contemporaneo ho pensato di spostare le tabelle
in MySql.
Ho installato MySql e il driver 3.51, ho creato le mie tabelle
(importandole da un'altro DB) e ho fatto il DSN di Sistema (tutto
sembra funzionare correttamente, i vari test di connessione si
concludono con successo).
Nel mio Mdb client, all'apertura, ho inserito questo codice per la
----------------codice di esempio------------------
strCn = "DRIVER={My SQL ODBC 3.51
Driver};SERVER= localhost;DATAB *ASE=GesPeg;USE R=civettini.f;P A
SSWORD=prova;OP TION=35;"
Set tdf = .CreateTableDef ("Anagrafe attività")
tdf.Connect = strCn
tdf.SourceTable Name = "Anagrafe attività"
CurrentDb.Table Defs.Append tdf ---> Qua mi dà errore
Ma quando tenta di fare l'Append della tabella al Db di Access mi si
presenta il seguente errore: "3170: Impossibile trovare ISAM
ANCORA PIU' STRANO: Se provo a fare il collegamento alle tabelle di
MySql in modo manuale(File -> Carica Dati Esterni -> Importa -> ODBC
Databases -> DSN..), vedo il DSN, ma quando faccio il doppio click non
si apre nulla... invece io mi aspetto di vedere le tabelle presenti nel

DB di MySql per scegliere quali collegare.
Le prove le ho fatte in un PC (Windows 2000 sempre aggiornato) dove mi
autentico su un dominio con i privilegi di amministratore. Mentre nel
Pc che ho a casa, dove lavoro in locale sempre come amministratore ed
ho Windows XP funziona tutto correttamente.
Sapreste aiutarmi, ho fatto varie prove ma senza risultati.
Non so più cosa fare
PS: Se apro il Db MySql con "MySql Administrator", funziona tutto
correttamente: vedo il mio db con le relative tabelle e i dati.

Nov 13 '05 #1
0 4282

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Lt Müller | last post by:
hallo, zwecks der Übersichtlichkeit bei der Ausgabe von DB Daten in eine Tabelle würde ich gerne jede zweite Zeile andersfarbig markieren. Die Daten werden über eine while Schleife ausgegeben. Danke für Tipps Lt Müller
by: Pito81x | last post by:
Ciao a tutto il news Ho un problema: in access ho una tabella collegata ad un'altra tabelle di un server Oracle (fin qui tutto ok) solo che quando da VB apro la mia tabella Access esso mi chiede la user name e password per effettuare il collegamento alla tabella Oracle..... Qualcuno mi sa dire come posso fare per passargli la pwd??? grazie
by: Pohl | last post by:
Hallo Zusammen, in der Access Datenbank mit Produktionsdaten werden tägliche Auswertungen benötigt. Zur Zeit gibt es einen Tagesauswertung als Aceess Bericht. Eine zukünftige Anforderung besteht darin, die zusammengefassten Tages-Leistungen (1 Datensatz) als neue Zeile in ein vorhandenenenes Excel-Arbeitsblatt automatisiert (VBA) zu exportieren. Die Möglichkeit "DoCmd.TransferSpreadsheet acExport" ist da nicht geeignet, da ich nicht...
by: amir | last post by:
Hallo Ihr Experten, ich möchte aus einem Formular aus, eine bereits vorhandene Laufendenummer aus einer Tabelle.spalte auslese und dazu noch eine 1 addiere und dann das Ergebnis in ein Textfeld auf diesem Formular eingeben! Danach werden weitere Daten von dem User eingegeben und dann werden alle diese Daten (die neue Laufendenummer auch) in der gleichen Tabelle als neuer Datensatz gespeichert. Ich denke an:
by: dangia | last post by:
Salve a tutti. Ho uno script asp per un guestbook che funziona a meraviglia se non che interpreta le date in formato USA. Oggi 7 dicembre lo fa diventare 12 luglio. Capisco molto poco di asp, penso di dover modificare a funzione. Function ConvDate(passDate) ConvDate = DatePart("yyyy", passDate) & "-" & DatePart("m", passDate) & "-" & DatePart("d", passDate) & " " ConvDate = ConvDate & DatePart("h", passDate) & ":" & DatePart("n",
by: Cheryl Langdon | last post by:
Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to communicate with a MySQL database table on a web server, from inside of my company's Access-VBA application. I know VBA pretty well but have never before needed to do this HTTP/XML/MySQL type functions.
by: Vanessa | last post by:
Hi there I am an Access developer, and I have written applications for a 30 telephone call center, using the standard multiuser jet engine, it all works fine, but I want to move our systems onto MySQL, as we get the odd #DELETED# (that old chestnut) so that it is more stable, I have installed mysql and myodbc and configured it in data sources (ODBC) and it works fine (done the TEST). But when I try to export a table from the mdb
by: valzi | last post by:
Salve a tutti, dovrei scrive questo programma in linguaggio visual basic.....solo che non ho molta dimestichezza con questo linguaggio.....c'è qualcuno che può darmi un aiuto o una dritta su come fare? vi ringrazio Un file di testo di lunghezza ignota contiene le misure di temperatura di una reazione chimica. I valori misurati hanno parte frazionaria, sono separati da uno o più spazi e sono distribuiti su più righe. La temperatura viene...
by: Atli | last post by:
This is an easy to digest 12 step guide on basics of using MySQL. It's a great refresher for those who need it and it work's great for first time MySQL users. Anyone should be able to get through this without much trouble. Programming knowledge is not required. Index What is SQL? Why MySQL? Installing MySQL. Using the MySQL command line interface
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.