Search results

Those settings go into a passthrough query you create in Access and that query should be the very first thing you do when you open Access. The settings like OPTION and INITSTMT are MySQL-specific parameters that you write in the connection string. So basically, in Access, you create a new...

Possibly only because Navicat sets the timeout to a different setting. If you look at the link I cited above and note the last post, we basically do the same thing, setting the timeout to a bigger value.

Okay, I thought that was the case - I helped a poster with similar problem. See if this helps you also.

Presuming you have two table with both primary key and foreign key defined: Click the bottommost icon on the left toolbar to select "Place relationship upon existing columns" (or you can press key "6" to select the same tool) Select the Foreign Key column first Select the Primary Key on the...

In Workbench, you'd select "One-Many Identifying Relationship" to create a relationship with referential integrity (to borrow Access' parlance) between two tables. Yes, you'd need it to use InnoDb database engine. MySQL is different in that you get to choose between different database engine...

When you get that "ODBC -- call failed", what do you get when you read all error messages contained in the DAO.Errors collection? Look at this if you're unfamiliar with DAO.Errors and how to use it.

Brian, I hope only the best for you and your wife.

Of course. Everyone agrees with the sentiment, "Someone else should pay their fair share." As long the "someone else" isn't themselves and fair means "enough for me, too!" Thus, the problem inherent in taxation.

raskew, This may be easier to do using a PivotTable. If we're going to do it in SQL, I imagine we need to have two subqueries, one grouping on month and other grouping on expense category, then join them together.

See if this overview helps?

You could also do this: Dim ssIn As String: ssIn = "G;Y;M;0;1;9;6;8;0;0;0;0;0;0;5" Dim v As Variant Dim c As Long, i As Long v = Split(UCase(ssIn), ";") c = Ubound(v) For i = 0 to c iSum = iSum + (InStr(sCharPool, v(i) - 1) * (16 - (iCount - 1)) iCtrl = (iSum Mod 36) Next i...

If you have a PivotTable form, you can just do this behind the form; Me.PivotTable.Export , 1 'plExportActionOpenInExcel

Doug says yes. You may also find this helpful, too.

once, after you link a new SQL table.

Yes, you would want to remove "dbo_" that Access adds so you don't have to change your code. As PeterOC says, it's possible to do it via code. Something like this for example: Public Sub StripPrefixFromTables() Dim tdf As DAO.TableDef Dim db As DAO.Database Set db = CurrentDb For Each tdf In...

Yes, assuming the following: 1) You replace your old Access tables with linked SQL tables 2) The new linked SQL tables is renamed to be identical as their Access replacement. It'll work because Access database engine is capable of working with any SQL backend (via ODBC) and thus will try to...

Cool. That'll help. Their response does sound expected, though. It's not typical for any business to disclose too much about future plans anyway. I imagine they don't want to make promises that they won't keep, etc., etc. Even if they merely released a runtime version for Mac only, I think...

FWIW, if I were you, I'd leave a note with MacBU letting them know that. No guarantee they'll respond but not telling them is certainly not going to make this a reality. I'd totally love to see it become a reality especially in light of how they resurrected VBA for Office 2011 (they had removed...

Yes, that's basically how I ended up with Mac, too. I was having nothing but headaches with my old Dell and since then I'm firmly convinced that the whole model of installing anti-anything is pretty much the wrong way to do it and we have to make decisions (block or unblock this program? check...

Last time I worked with encryption, I mainly used strings because I can't otherwise hold a 256-bit SHA hash in hex values. This way, it's also easy to convert between string and byte arrays. This is valid. Dim s As String Dim r As String Dim b() As Byte s = "Hello, World!" b = s r = b...