Recent content by driep01

That will be very helpful. I saw that there was an item about the SSMA. Where can I get hold of the recording? Regards, Phlip

Hi, I rebooted my laptop before the uninstall and re-install and that did not help. I'll try something else. Phlip

Hallo, Thanks for the reply. "Are all of the tables in the accdb local to that one accdb, and not linked tables?" - Yes it is. "Do you know why that matters?" I think it is because the linked tables do not contain the meta data to enable the migration process to create the information in SQL...

Good day, I am very frustrated; I am trying to migrate a backend Access database to Azure SQL Server. When I select the Access Database the SSMA for Access only show two tables out of a total of 19 tables (incidentally, the two tables were created today 26-mar-2024) It is a 2016 Access...

Hi, I got a solution from another response on this site. In your "DLookup("Password", "tblUsers", "[UserID]=" & Me.txtUserName.Value)" the "Me.txtUserName".Value must be in single quotes. Something like this might help (see text in red added): DLookup("Password", "tblUsers", "[UserID]= '" &...

Hi, Thanks for the response. I found the error - I forgot to also include the x_groupType in single quotes.:p Regards, Phlip

Hi, I have a similar problem with the RT error. I have tried the solution posted but still get it. Here is the function: Public Function getGroup(x_stn0 As Long, x_groupType As String) Dim v_groupval As String Dim v_classgroup, v_pracgroup, v_tutgroup As String v_classgroup = "C" v_pracgroup...