Search results

It was a mistake in one of the queries that made me believe that records were lost. Thanks SQL_Hell for the help. Subject may be closed.

Extensive Access program with a dozen macros. This morning I tried to open a macro in design, resulting in a crash of Access2010; other macro's also cause a crash when opening. The macro's run ok, without crash.:banghead: I get the following message on the screen, approx translation inbetween...

I work with Windows. Opening the file with wordpad shows no readable file. Can't open it with access or excel

Somehow I lost some 50 records in a table, all records are of the same date. I asked the provider of MySql backen db to give me a backup of the dB. They sent me: full backup of the database as like on the server. I don't how to open that file. The provider could also send me a dump file...

Thanks Michael for yr reply. The query result is used to make reports. A max of 1500 records if I can include the CourseYear as a parameter in the SPT else some 6000 records. I use a second query to further narrow down the selection for more specific records (e.g. to enter a course number or...

Got an extensive Access program on my PC with a backend mysqldb with a provider. I know how to get a Pass Through Query running for a simple query but I get stuck with the following SPT query (SQL Pass_through): SELECT Bankbook.Date, Bankbook.SeasonID, Bankbook.Data1, Bankbook.Data2 FROM...

I let the problem rest for some time, sorry for not replying earlier. Dynaweb: I've been looking for "properties'" but I am unable to find them. Mind you I am working with Access2010. A second question I have is the sql language. I am able to strugle my way through VBA but would have to start...

I have been working with Access(front end) and Mysql (back end) for over a year now. Would like to backup MySql to my PC and store. I have used AccessMySQL Convertor (Soft Galaxy); but that US based program makes mistakes with the date: 10th August becomes 8th October; no matter what I change on...

Thanks Banana; the alternative method worked best. I found out that creating the relations in mysql is easy as well. Relations all work now, next job is to improve the speed of th eslow reports.

Thanks Banana; I had the dB engine changed to INNODB. In Workbench thing look very easy te create the relations; I point to 1:n and cursur changes to 'special' but I can't do anything with it. I have attached a prntscrn (workbench.zip). Please help, getting desperate.

I have got my backend dB 9 tables (in MySQL) for my Access application on an external server. I need to create relations between some of the tables. For this pupose I dowloaded MySQL workbench; I created an EER diagram but am unable to create the desired relation. I picked up somewhere that the...

I have some very slow reports in Access program with mysql backend; and I am trying to improve that by building pass-through-queries (PTQ). I got a few of these queries working and the speed is ok; but I have the following questions: 1. Each time I activate a PTQ, I need to log on thru the ODBC...

I found it: Use ' around Seizoen-id SELECT BankboekID, Datum, 'Seizoen-id', OntvangenE, BetaaldE from Bankboek It works, thanks for the help

Fields in the table Bankboek are (in Dutch): Seizoen-id, BankboekID, Datum, OntvangenE, BetaaldE

Bob, SQL doesn't accept square brackets. SELECT (BankboekID), (Datum), (OntvangenE), (BetaaldE) FROM Bankboek; ----- works ok But not: (seizoen-id) What to do?

Thanks Bob, Mind you I am new in Mysql; this was the very first pass through-query. MySQL query: SELECT [Seizoen-id], BankboekID, Datum, OntvangenE, BetaaldE from Bankboek I entered the query directly on the website, it doesn't work there either; i get the error message: MySQL retourneerde...

I found that the name in de querry listing differed for the name in the property screen of that query. One should use Property name. problem solved

I tried the square brackets [season-id]; doen't solve my problem. pls help

Got a column: Season-id If I make a pass through-query, I get an error: Unknown Column. Is there a simple solution, else I will have to change the name of the column into e.g. SeasonId (but it has an impact on many forms and reports, would hate to that) Pls help.

Thanks, I found it!:)