Search results

Just to answer dfenton's question - basic SharePoint edition (which is free with any Windows Server product, IIUIC) supports the capability to synchronize data. I believe the ability to synchronize Access objects does require more expensive version but I've not found the ability to synchronize...

Correct. I tend to prefer using implicit evaluation for where I expect a boolean evaluation because it more closely resemble the behavior of other languages and thus is useful for cases where we may not get the expected True value. For example, if you call an API that returns (in theory) a...

It's termed "Conditional Compilation" which basically allow you to write different code and select one of them for different use. If you google, several people wisely suggest that one use late binding for maximum compatibility when using other libraries especially when you distribute Access...

Yes, if the project wasn't written for SQL backend in mind from start.

Right. With first two cases, Jet is smart enough to first evaluate them and translate them into a hard constant and send the query as such. With last case, nothing Jet can do about it but just suck it up and evaluate each row one at a time. BTW, just to be explicit - this isn't just true for...

Well, if the function does something like this: WHERE myFunc() = True; or WHERE myCol = myFunc(); Then Jet can optimize it away. The real trouble come in this: WHERE myFunc(myCol)=True; This require re-evaluation of function for every row, and thus cannot be optimized away so Jet has no...

Here's what I do when I need to hook into Outlook and create Outlook if it's not already running: In its own module: Option Compare Database Option Explicit #Const EarlyBind = 1 'Set to 0 & remove reference before distributing! #If EarlyBind Then Public Function GetOutlook() As...

As SQL_Hell alluded, SQL Server is your backend now. In Access, you had two files, one front-end and one back-end. You enforced RI in Access back-end. You replace the Access back-end with SQL Server... but RI still stays in the SQL Server. Access front-end (or indeed, ANY front-end clients)...

Be careful about which backend you're doing this with. Giving 0 to MySQL will return the incremented value, IIRC. I would be wary toward messing with the autoincrementing behavior because this is one of least portable aspect of SQL.

Yes, that's correct. Some people think that if they change backend to SQL Server, Oracle or whatever, it'll magically increase speed. That seldom happens and if they've developed it without considering the server-client architecture, there may be some re-engineering required to optimize the...

Why not use MySQL's Workbench for GUI interface? The recent release is pretty full-featured. As for a simple way to import Access table, I'm not aware of any free program that does it- I see few commerical programs offering this but I'm of mind it's best to do it from scratch in MySQL -...

Be aware that they added calculated fields mainly for web applications but the old school method was to do it in the query. So instead of creating a field to calculate the Month name based on another column's month, create a base query that does the same thing then base all your derived queries...

Lagbolt, that would be appropriate if we wanted count of elements but I think we wanted count of occurrences (e.g. the delimiter).

BTW: you can cut it down to one line: HowMany = Ubound(Split(strInput, strDelimiter, , vbTextCompare)) But that may be a bit too cryptic...

Clever, Bob!

Something like this, maybe. Dim c As Long Dim i As Long i = 1 Do i = InStr(Mid$(strTest,i), ",") If i Then c = c + 1 End If Loop Until i = 0 Debug.Print "Number of occurances was: " & c (untested)

FWIW - if you already have a existing MySQL infrastructure and you don't want to lose, you may want to see if SQL Server's linked server allow you to work with MySQL tables, most likely as a part of replication schema so your Access client can sync with MySQL data. (I don't know if it's even...

DPortas - thanks for that tidbit. I have to admit I can't remember ever encountering a composite primary key referenced as a foreign key - AFAIK, the behavior is identical when we talk about single-field primary key but I was able to reproduce the error you described with composite primary key.

Well, if client installation is such hinderance, the option is to use SQL Server Express which is free and most Windows already has SQL Server ODBC drivers installed. With 2008 R2, you can have up to 10 GB database.

Actually, regardless of how you connect, whether with DSN or not, regardless what type of DSN you use, you are still required to ensure that there are client software installed for the RDBMS of your choice. You may instead program in your front-end file to check that the MySQL ODBC driver is...