Search results

My first reaction would be a shrug of the shoulders. Unless you are critically short of space on the drive where the SQL Server instance is installed, it should not matter. It's not like Access where we have a hard 2GB file size limit. Even if you are using SQL Server Express, it's not that...

I decided to see what Chatty and Claude, a couple of my AI buddies, have to say about benchmarking performance for various database platforms. I figure they should have access to a lot of that kind of research which I don't have without hours of crawling the web. Unfortunately, it turned out...

In Post # 1 you indicated, "We dumped MS SQL Server for MYSQL as relational database due to speed we have been using this MYSQL databases with MS Access as front end and has proved to be reliable and our users like the speed compared to MS SQL Server which makes the speed horrible even if you do...

The inquiry at hand isn't about the names of tables or fields. The inquiry is about datatypes, e.g. like the one in your error message regarding a multi-value field. So, while you resolved your problem by switching from the wildcard to specifying field names, it's still ambiguous about why...

You've talked about tables and columns but not described nor shown any of them in your responses. In that environment, it's difficult for anyone to know what might have happened, nor to guess at possible reasons for the problem.

I thought about suggesting a full text index on this field, but like Tom said, I'm not convinced it would be all that helpful in this scenario because it's intended for a different kind of problem. It couldn't hurt to try, if only for your own learning.

It's easy to miss the importance of the distinction between date values and date formats. Arnel alluded to that in post #2 in his explanation of how to address the problem, and Minty further explained in post #7. The key point is that Format() does NOT change the date value stored in the field...

Having done some work with PowerApps for smart phone and tablet environments, I can tell you the main reason we don't write our apps to work on smart phones is that--except for some really simplistic applications-- their form factor and screen size militate forcefully against that approach. Your...

This could be one of those times a small repo database with sanitized data could be useful in helping diagnose a problem.

Somewhat different contexts, but I get the point. I've used a hammer to decommission ancient hard drives before disposing of the obsolete computers they were in. More than once, though, I've been delighted to find a backup of a file last used 12 or 13 years ago on an external hard drive. On...

Ah, a developer after my own heart. You just can't have too many backups.

My first thought would be to consider differences in ambient lighting between the two locations. I know I get different effects from closing or opening the blinds on the window behind my desk. Probably not as great as you describe, but definitely noticable.

Perhaps, if you want to use Adobe Acrobat to convert PDFs to PNGs, a good starting place would be the Adobe site. https://www.adobe.com/acrobat/hub/how-to-convert-pdf-to-png.html

What exactly have you tried so far? Do you have a copy of Adobe Acrobat 9.0 already? Have you investigated whether it even has that capability? VBA is a Microsoft Office product. Does Acrobat 9.0 even use VBA?

Winner.

I don't have direct contact with the MS Access team any longer. With all of the other priorities already on their plate, I don't think I'd try to insert this particular initiative into their plans anyway. I'm also skeptical that adding such a guide would make all that much difference anyway...

As I said, there have been many such attempts to provide guidelines for designing and building normalized relational databases, some brilliant, some less so. I bet a search right here at AWF would turn up more than one. The problem, as I see it, isn't a lack of written guides. The problem is...

A guide? Not a document as such. That's actually beyond the scope of the charter for Microsoft templates in general. We went to some trouble to provide a consistent Relationship Diagram for the Developer version because otherwise it's generated in the muddled state typical of newly created...

What theDBGuy was referring to: https://learn.microsoft.com/en-us/sql/tools/bcp-utility?view=sql-server-ver17&tabs=windows

Well, the crash is locking the database, so it makes sense that all are impacted the same. I qualified my comment about the problem by saying "if" it is caused by shutdown of a laptop. So that's not a definitive consideration. Rather, if a process is being interrupted during a write operation...