Search results

I have never really used arrays to any degrees. I am trying to create a function to split a string by tabs, but I am struggling to get it to work even with spaces (not even tried tabs yet). I keep getting a type mismatch compile error but I can't see why. Can any advise? Public Function...

Thanks for that, its been a long time since I looked into data types and it looks like bigint wont be required in my lifetime. It is always good to make mistakes, I won't forget this in a while, although I could have done without 3 hours of experimenting at getting nowhere this afternoon tbh...

Solved! I had a need to import fresh data daily with each file containing potentially hundreds of rows. So in my infinite wisdom I decided that rather than use integer as the datatype for IF_ID. I would use BIGINT (this first time I have ever done such a thing). It appears BIGINT exceeds the...

Why is that? I went on a training course for using Ms Access with MS SQL around 15 years ago and was told that the SQL table must have a timestamp else it would not perform reliably. In the last 15 years I must have created scores of databases (I use databases for almost everything). In every...

It isn't the unique record identifier. The unique record identifier and primary key is IF_ID is.

The table has Option Explicit stated and compiles fine. I added dbOpenDynaset, dbSeeChanges as recommended, it made no difference: Whereas on SQL Server I get

No to first question Yes to second primary key is configured in the table on SQL server

I have written a procedure that imports a text file and enters each line into a table on a MS SQL Server Database. 10 On Error GoTo err_ReadInFile Dim strTextLine As String 20 Dim intFile As Integer: intFile = FreeFile Dim db As Database Dim rs As...

Well done, I designed the database structure quite a while ago and then it got mothballed. I thought all the tables were empty and never even thought to look. But on inspection there are three entries in tblStandardMeetingInvitees but the tblMeetings has no records, hence the error. All good...

The fields are: tblStandardMeetingInvitees (child table) SMI_ID varchar(10) Unchecked Keyfield M_ID varchar(10) Unchecked MD_Category varchar(20) Checked SMI_Person varchar(50) Unchecked SMI_Email varchar(100) Checked timestamp timestamp Checked tblMeetings (parent table) M_ID varchar(10)...

Don't worry answering just established it is part of redemption

I don't appear to have SSIS or SSRS. Historically I have always written error messages to a text file located on a shared & mapped company drive. But most of us have been working from home for the last 12 weeks and what is happening is some users are not mapped to the drive so I do not get an...

I don't have access to Azure unfortunately.

Thanks, what is CDO?

I am trying to create a relationship between two tables in server management studio using the relationships dialog box. The master table tblMeetings has a primary key "M_ID" of datatype varchar(10). The child table tblStandardMeetingInvitees also has a field "M_ID" of datatype varchar(10)...

In all vba routines/functions I include error trapping that sends me an email with error details whenever a user encounters an error. I use this to get feedback from users to continuously improve the database. I have done this for some time without there being any issues. But last week I...

It would appear there is an even later release than the 2nd June one. There was aa release on 9th June: https://www.computerworld.com/article/3205187/office-365-a-guide-to-the-updates.html

Good idea, thanks for all your help.

Hi Minty, thanks for that, it has a good chance of being the issue because it only happens in DAO which I am using, other tables and passthrough queries report the number fine. I've spent close to a day trying to fathom out what is wrong with something that appears to be coded fine! One...

I use a version control system on all my databases to force users to use the latest front end version. Each front end has a hard coded variable dblThisVersion which I increment with new releases. On a SQL server there is a table that stores the latest version number for each database (this I...