Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
spaLOGICng's latest activity
S
spaLOGICng
replied to the thread
Solved
I used to be able to copy objects from one database to another but now I get error code 3734
.
Thanks for your input. Yes, and that is one of the most common causes. It is important to clean up VBA Record Set Activity as well, like...
May 17, 2024
S
spaLOGICng
replied to the thread
SSMA_TimeStamp field never gets updated
.
I was beginning to like you Pat. My apology for going off on a tangent but I am not the one that brought up SSMA or Hidden Indexes to...
May 15, 2024
S
spaLOGICng
reacted to
GPGeorge's post
in the thread
SSMA_TimeStamp field never gets updated
with
Like
.
You're getting there. It took me a while to come around on this one. :cautious: I always remove the autoindex code words because they...
May 15, 2024
S
spaLOGICng
replied to the thread
SSMA_TimeStamp field never gets updated
.
By default, Access will create an Index on any begins or ends with any of the names in the auto-index box as seen here. As to why...
May 14, 2024
S
spaLOGICng
replied to the thread
SSMA_TimeStamp field never gets updated
.
Are you referring to the purple line references here? It actually does not list the Field name. Apart from that, the FK Column Name is...
May 14, 2024
S
spaLOGICng
replied to the thread
SSMA_TimeStamp field never gets updated
.
I believe you are replying to me... As I said, I believe the issue is the Analyzer Report. There is no such thing as a hidden index. I...
May 14, 2024
S
spaLOGICng
replied to the thread
SSMA_TimeStamp field never gets updated
.
I ran your Script George, and I ran one that I have to list All Index, neither show the FK Column as an Indexed Field. I truly think it...
May 14, 2024
S
spaLOGICng
replied to the thread
SSMA_TimeStamp field never gets updated
.
Okay, I am going to follow these steps. but in a nutshell, when I run the DB documenter Report, this is baffling. I do not think it is a...
May 14, 2024
S
spaLOGICng
replied to the thread
SSMA_TimeStamp field never gets updated
.
I am not the OP, I am a commentor and this is kind of like a sub-thread. Someone referred to SSMA not creating "HIDDEN" Indexes. I did...
May 14, 2024
S
spaLOGICng
replied to the thread
Save the names of tables, forms, and reports in a Microsoft Access database to a table named "ObjectNames.
.
You can refer to AllTables, AllQueries, AllForms, AllReportss, AllMacros, and AllModules under Application.CurrentProject. You can loop...
May 14, 2024
S
spaLOGICng
replied to the thread
SSMA_TimeStamp field never gets updated
.
When I create Tables, I always use Number Fields to relate Tables. Very very seldom if ever will I use a Text Field for a FK. When I...
May 14, 2024
S
spaLOGICng
replied to the thread
SSMA_TimeStamp field never gets updated
.
It is in SSMS. I included this because it can generate full Database Scripts, and when you select the Dependent Object option, the...
May 13, 2024
S
spaLOGICng
replied to the thread
SSMA_TimeStamp field never gets updated
.
There have been a lot of recent updates to SSMA, but I have been using it exclusively for years and have never seen a missed index on a...
May 13, 2024
S
spaLOGICng
replied to the thread
SSMA_TimeStamp field never gets updated
.
I have never seen or never heard of a hidden index, not in Access, and not in SQL Server.
May 13, 2024
S
spaLOGICng
replied to the thread
SSMA_TimeStamp field never gets updated
.
Understood. Not sure why the never dawned on me. As you can see in this snippet, the Northwind DB that Iused SSMA to create the Tables...
May 13, 2024
Home
Members
Top
Bottom