Search results

Hi, For the past several years, I have used the following front-end updater: "Application Starter for Microsoft Access (versions 2000 and later) Version: 4.4" http://www.peterssoftware.com/aps.htm My database has an Access front-end and MS SQL Server backend. I have had the front-end stored...

Hi, OK, I think we are close. So, for best practice, it is OK to use a view that is based upon a single table. Though, if the view is using joins and such (like many of my Access forms are based upon), then is the solution to use 2 subforms or maybe have a continuous form at the top which is...

Hi, I recently discovered that I have been making a design mistake when using SQL Server views. I previously would have a view and allow the user in an Access form to change data in the view. However, I learned that this is not a good solution. A better solution is to have the user make their...

I found that just by installing a SQL Server 2014 local instance and then importing the backup everything worked great. I never could figure out what the issue with the 2012 instance was. Though, as long as the speed is back to normal, I am happy. Thanks.

Excellent. I will test it out. Thanks.

Hi, OK... so, my connection method is just fine. Perhaps I installed SQL server in an incorrect way that would make it so slow? Thanks, Chris

Hi, Can you please send a link to what a newer connector is? Thanks -Chris

Hi, I have been using a local SQL Server 2012 Instance which I link to using the below VBA code. Everything has been going fantastic for years until I upgraded my computer recently. I installed a local instance of SQL Server 2012 on my computer and then imported the database that stores the...

Hi, Final note... after researching derived tables I discovered that CTE's are the best choice for me. You calculate and create the new column in a CTE, then you are free to use that column name anywhere in the query. This is a perfect solution that accomplishes what I have previously done in...

Great advice on the views. That is what I have been trying to avoid. OK. So, the correct solution is using a derived table in the view. I will definitely go in that direction. My current method is creating insanely messy code that is impossible to troubleshoot since each column is using data...

Hi Colin, Yes, I always assign a PK for SQL Server views when using them in Access. I am very interested in hearing what the two-step approach is you are referring to. I am migrating all of my Access queries over to SQL Server views. Though, this issue of not being able to feed one column...

Hi, Galaxian, I am using Access 2010. Though, I do the same thing in Access 2016. For example, I can create a field: Within the same query I can do the following FullName: [FirstName] & " " & [LastName] FullNameWithTitle: [Title] & " " & [FullName] FullNameWithTitleAndRank: [Rank] & " " &...

Hi, I have been using access for several years now and am getting up to speed in SQL Server now. In Access, you can create a new column that is based upon other columns in the table. Then, within the same query, you can use the new column as a basis for a new calculated column and so on. My...