Search results

Hello MS Access Expert, Suppose I have a table Y with 30K records and I have two queries in MS Access which are identical (SQL = Select x from Y where x = "a"). When I open the first query the results appear instantly. While keeping the first query open, I subsequently open a second identical...

Yes, it appears to be a Windows issue then. Is anybody else experiencing the slow open phenomena as well. See attached. Thank you

Yes it is. It is maximized. Nice inquiry Josef. MS Access is maximized when the Folder is maximized it’s just not getting the Focus.

It doesn't George. ODBC;DRIVER=ODBC Driver 17 for SQL Server;SERVER=DESKTOP-5FFFFFF;Trusted_Connection=Yes;APP=Microsoft Office;DATABASE=NewBrunswick;;TABLE=dbo.Employees

I asked a colleague and he confirmed he is experiencing the same behavior, MS Access not maximizing in Shift mode, on his machine. He also confirmed another behavior that is happening on his MS Office 64 bit machine. MS Access is randomly opening slowly. See attached video. I think this...

Yes that is what I wanted to confirm. If I use a DSN File to create the ODBC links than I can distribute the FE to another machine without the other machine having the DSN file. Thank you

Thanks for your response isladogs. This only occurs if I hold down SHIFT with MS Access. If I open without holding SHIFT, MS Access opens maximized. Since there is no SHIFT mode with MS Excel I cannot test this behavior with Excel.

Hello MS Access Expert, I observed that if the Folder is not maximized, MS Access opens maximized in shift mode. If the folder is maximized then MS Access only opens in the taskbar. I have attached a video to demonstrate this behavior. Does this occur on everyone's machine? I am using MS...

Pat and George, I apologize for my late response and thank you for yours. I understand that for Schema Changes in the SQL Server Backend the ODBC links need to be refreshed. My follow up question was why do we need DSNless VBA code, if when using a DSN file to create the ODBC links the links...

Thanks Pat. How about my interpretation of table links being DSNless using a File DSN? Is my understanding correct. Only User Machine Data includes the DSN in the connection string. ODBC;DSN=NewBrunswick;Description=NewBrunswick;UID=jrwei;Trusted_Connection=Yes;APP=Microsoft...

Hello MS Access Expert, When I open an .accdb file using shift mode it does not Maximize on my screen. It merely appears in my Taskbar and then I have to click it to maximize it on my screen. The peculiar aspect is that if the file is Not in a folder but rather on my desktop it always...

Thank you for everyone's response

Thanks pbaldy

When I connect using a DSN file the ODBC connection is the following without any reference to DSN on my machine: 1) ODBC;DRIVER=ODBC Driver 17 for SQL Server;SERVER=DESKTOP-5FFFFFF;Trusted_Connection=Yes;APP=Microsoft Office;DATABASE=NewBrunswick;;TABLE=dbo.Employees When I connect using User...

Hello MS Access Expert, If I have ODBC Driver 17 for SQL Server in the ODBC connection string I presume that would require me to install this driver on the client's machine? However, suppose the client gets a new computer later on and it has ODBC Driver 18 installed. Will that break my ODBC...

I just learned that creating the ODBC connection via a DSN file makes the links DSNless. Why the need for the DSNless code that I referenced?

Thank you so simple. :) For multiple ODBC links the code below works well but the code is basically deleting the table definition and recreating it without DSN in the connection string. I already have this code in the program so I will use it as a solution...

Hello MS Access Expert, I noticed that when I delete a field from the SQL Server table the ODBC connection subsequently breaks. Additionally, if I add fields to the SQL Server Table the ODBC connection does not break but the newly added fields do not show up. The only solution that I have...

Hi Minty, Eval () resolved the issue. Thank you. I am curious however, why is the Eval necessary?

Let me know if the video explains the issue clearly. I am very curious why this inconsistent behavior is occurring. The recording volume is very dim for some reason so please max out the volume. :)