Viewing 15 posts - 1 through 15 (of 273 total)
First, I should note that you are responding to a thread that from 7 years ago, with the most recent post nearly 4 years ago. Second, as far as I...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
November 13, 2020 at 3:01 pm
According to the presenter in Vienna, if you define them as Datetime2 (2) that seems to work without problems. That gives you 1/100th (10ms) seconds precision. Hope that helps.
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
May 28, 2020 at 4:00 pm
This is a known problem, and there are some workarounds which may or may not be acceptable in your situation. See the following link for the info.
https://docs.microsoft.com/en-us/office/troubleshoot/access/access-linked-table-deleted
I also am...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
May 28, 2020 at 3:37 pm
I presume our paths have crossed somewhere in the past, but haven't been able to figure out where and when.
First, lets make sure we are talking about the same thing. ...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
April 14, 2020 at 4:49 pm
There are a number of good resources in evaluating your options. One of my favorites is:
https://www.fmsinc.com/MicrosoftAccess/SQLServerUpsizing/index.html
Others you might consider:
I spent 20 years working with SQL Server...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
April 13, 2020 at 10:42 pm
Since several weeks have passed, I hope you have sorted this out. First of all, it's not clear whether you are using Integrated Security, or Standard Security. Your question suggests...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 12, 2019 at 7:11 pm
The * in that refers to this:
*As of January 14, 2020, Office 365 will no longer be supported on Windows 7 SP1.
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
October 28, 2019 at 5:10 pm
A few things to note:
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
October 28, 2019 at 4:35 pm
For some strange reason, the post I made last week seems to have disappeared. So I shall try again:
I suspect your issue has to do with the primary key on...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
April 29, 2019 at 5:27 pm
One of the most common issues where you get the **#Deleted** message is where you have a boolean (Yes/No) field in the SQL Server table that doesn't have a default...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
April 19, 2019 at 6:29 pm
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 28, 2019 at 10:16 am
Sorry for the delay in responding. And yes, it is essentially the sort of code that William suggested. It sounds as though you are dealing with a continuous form that...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 27, 2019 at 4:06 pm
Are your users getting those kind of ODBC errors from a form where they are adding/editing data on a form? Or are they adding or editing data at the table...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 22, 2019 at 10:28 am
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 6, 2019 at 3:15 pm
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 6, 2019 at 2:40 pm
Viewing 15 posts - 1 through 15 (of 273 total)