Recent content by spitzmuller

Ok, figured it out! This page has general hands-on information about linking tables from mysql servers into access: http://www.washington.edu/computing/web/publishing/mysql-access-3.5.html The following webpage has valuable tips to make the odbc-linked tables work flawlessly...

Hi there I tried to link some tables that reside on the mysql-Server on my local machine into a new access database using the ODBC 3.51 driver everything worked fine with no errors. But when I open the linked table in Access, all entries have #deleted values, although when I check via...

Thanks for all your help so far. But it still doesn't work. I created a hidden form and i open it from the Form_Open-Routine of my Main Window. When the hidden form's unload function is called, i can set Chancel = True as much as I wan't, I can't prevent the Database from closing. I guess...

Hi PaulF Well, maybe your users can, but my users definitely cannot do that (as in: they are total windows newbies). Otherwise yeah - you're right.

Love it too!! Thanks so much for this hint! Greets Simon

Hi out there Is there a simple way to export the tables (and maybe the relationships as well) of an Access 2003 Database into SQL-Format, so that it can be read into mySQL? Or does anyone have another suggestion on how to transfer a database from Access to mySQL? Thanks in advance for...

Hi out there Finally got the right connection string working: instead of reconnecting the linked table to the backend I create a new linked table with this code: Dim td As TableDef Set td = CurrentDb.CreateTableDef(TableArray(Nr), dbAttachSavePWD, TableArray(Nr), ";DATABASE=" & dbPath &...

Hi mstrmage1768 Tanks for your reply. Your code works fine if a form window within access is closed with the "X" But I am talking about the Access-application window itself (the mother window if you want). There is no UnLoad-Event for Access itself... Simon

Hi out there Great Forum! But couldn't find an answer for this one... I'd like to stop the closing process of access when a user hits the X in the upper-right corner of the application window. I'd like then to ask the user if he is sure and if he clicks yes close access, if he clicks no cancel...

By the way: I am using Access 2003 (upgraded from Access 2000 about a year ago)

Hi PHV Thanks for the link. But it still doesn't work. I keep getting an error: 3170 Couldn't find insatallable ISAM In the above code, i have just replaced td.Connect = ";DATABASE=" & dbPath with td.Connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath & ";Jet...

Hi out there I have a Front-End database that contains links to tables in a password protected backend database. The two databases reside on a server and the user start the database from there. Due to IT-restructurisation, the location where the databases are saved will change a few times...

Thanks Remou Quite clever, really! Should have come up with it myself. Still odd that there's no "Keep together with last detail" Option in Access for this. Have a star. Simon

Hi there This must be a common problem but I couldn't find a thread that helped... I would like to print a group footer with the last detail (if it doesn't fit on the page and a new page is required). Right now I sometimes get the group footer on a new page without any data and that's quite...

Hi out there I have a report that - using VBA - is configured based on user input. That input is possibly invalid and then opening the report will throw an error, which I would like to intercept and then let the user know in a decent way. This is the code that I use to try to open the report...