Search results

That is a direct quote from the Microsoft document itself. The one I linked to in my post. It literally says "the SYNTAX is deprecated" and will be removed in a future version of SQL Server. I went on to add that it's ambiguous, which this discussion seems to confirm. It is very confusing, as...

The term "TimeStamp" is supposed to be deprecated in favor of "RowVersion", but the function itself remains. The Learn article on Rowversion does appear to be ambiguous, though. The timestamp syntax is deprecated. This feature will be removed in a future version of SQL Server. Avoid using this...

One more reason to eschew macros and employ VBA.

What does that mean? You can't link PDF's directly from folders? Access developers do that all the time! All you need is a field in the table containing the path to the PDF....

Microsoft did make such a move a couple of decades ago. It never succeeded and DAO regained prominence. It's no longer an argument for ADO itself. There are other advantages to ADO, though, for situations where it makes sense, such as disconnected recordsets.

You didn't mention the elephant in the room for attachments: file bloat. Regardless of how well or how poorly the attachment field itself performs, inserting binary files (Word docs, PDFs, Excel sheets, images, etc.) inside the accdb doesn't make sense. Fight me to prove me wrong.

Experience is a good teacher. ;)

The_Doc_Man has addressed the underlying problem as well as the other key problem of splitting data into multiple accdbs. Storing binary files, i.e. PDFs, Word Docs, images, etc. inside an accdb is possible, but highly undesirable. And even more so with the large volume of information you need...

SSMA has been enhanced quite a bit in recent versions. Pre-migration reports, for example, are very informative about what will be moved and how, but more importantly most of the potential problems are flagged for your attention. Check out this video from last fall.

Given the uncommon approach here, it's hard to see how this can be a successful design. But assuming for a moment that you will eventually sort out the various problems it introduces, let's focus on what this statement means. "... insert employees1.*, employees2.*, employees3.* the results all...

Are you sure the full SQL is not there? Have you expanded the row height of those fields to inspect the entire contents of the field?

I settled on the tempvars alternative with the use of the criteria I explained above for two reasons. The VBA is about as simple as it gets. Two lines are needed. One to set the tempvars value One to requery the form. That's it. There is no need to swap or modify the row source or...

I get that, but this example was pulled from a demo that I wanted to be fully explicit. In most cases I would not specify the table as you point out. How it works in more detail. The row source for the combo box is: SELECT P.PublicationID, P.PublicationTitle FROM tblPublication P...

Can't you set it in Outlook globally and not need to do anything in Access about it?

I use a series of helper functions in VBA, rather than the basic TempVars!lngPublicationID for a couple of reasons. One is that it forces the evaluation of the expression, which isn't always the case. Some people use Eval(TempVars!lngPublicationID) for the same reason. I also like it to ensure...

One of my favorite techniques for filtering queries that are used as recordsources for forms and rowsources for list and combo boxes involves tempvars. Here's an example. SELECT tblpublication.publicationid, tblpublication.publicationtitle, tblpublication.volume...

Rule 2 applies to your business and only to your business. I doubt that in other organizations a doctor can be restricted to a single specialty. In fact, a brief internet search turns up more than one counter-example: You can impose the rule on your organization and allow each doctor one...

I also want to explore a second potential problem I see here. I need additional background to understand. Do all of your staff have one and only one specialty? Is it possible for Dr. Wally to specialize in both internal medicine and infectious diseases? If Dr, Wally is hired into one role, does...

The problem lies, at least in part, in the table design. However, having read this thread again, I can't figure out what your tables actually look like. Please help us out. Create a screen shot of the relationships window. Show only the tables relevant to this part of the database so that it...

80+ --> 30+ That definitely confirms my assumption about the relative complication of layout and design. How complicated in the query that supplies records from which the field list is drawn?