Search results

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...

Just to clarify: 1) If you're using MySQL and not SQL Server, you'll need to distribute MySQL ODBC driver since they are not installed on Windows PC by default as is the case with SQL Server. 2) I wouldn't call File DSN a DSN-less connection, exactly. As Pbaldy said, it's convenient for...

Examples of this? As far as I know, nullable foreign keys seems to be part of the standard. I just verified that nullable foreign key is allowed on SQL Server 2008 R2 and I'm pretty sure it is true with MySQL & PostgreSQL though I''ve not tested it, nor would I want it anyway.

I suggest you read the article about cascading to null which hopefully brings out the difference between "Required" property (which corresponds to NOT NULL DDL) and foreign key. Personally I don't like the idea of allow null foreign keys and make my foreign keys required most of time.

DCrake - No. 2007 is solidly 32-bit only. Just to be clear here - there's two senses of how we can use "32-bit/64-bit" - WRT the OS or WRT the application. In your scenario, you are likely dealing with 64-bit OS but 32-bit Application (e.g. Office 2007). Because Office 2007 is still 32-bit...

First of all, does he REALLY need 64-bit Office? The chance are that he doesn't and would be better off with just 32-bit Office. Microsoft currently recommends against installing 64-bit Office and your user must have went out of his way to get it to install 64-bit. But assuming there is a legit...

If your web host allows remote connection, yes. Some may require you to use some form of VPN or remote login, but as long you work it out with web host, this'll work much better.

Just to be explicit: I'm led to believe that the security of data is primarily centered around securing the web server and avoiding use of certain code that would allow exploits (e.g. SQL Injections) and less to do with physical storage of data. In other words, many web server communicate with...

I'm also aware that some have succeeded in using Access database as a web host, but since your intention is to use it interactively, I think you'll find it a bad idea. Why not just use a free RDBMS (SQL Server Express? MySQL? PostgreSQL?) that you can place on your web host, base your websites...

Just to help Jeannette (welcome to AWF!) out - Recovering from corruption Preventing corruption