Strange results on Join (1 Viewer)

[GohDiamond]

Hello ALL,

Using Access 2013 here.

I have 2 tables

1. tbl_Profile - with UserIDs, User Names, and User Related data
2. tbl_Assets - with AssetIDs, Asset Names, Asset OwnerID and Asset Related Data

Asset OwnerIDs will always be one of the Profile UserIDs

When running a query to get the NAME of the Asset Owner we join Profile.UserID to AssetOwnerID and run the select query to Pull the NAME from tbl_Profile

Makes sense so far right.

ALL the UserIDs and, therefore, AssetOwnerIDs are 9character length, alphanumeric IDs.

Now there are thousands of assets and tens of thousands of possible owners to choose from. There are indicies on both these ID fields.

Everything had been working fine for about a year now and suddenly the query has produced results that do not exist in either of these ID fields (Raw Source Data) that looks like this:
$897720-KTC8QH04HRUF (Note: all Upper Case)

Does anybody know what may be causing this aberration?

The results should look like :
lptop1234 (note: all lowercase)

Thanks in advance for any insight and advice
Cheers!
Goh

 

[jdraw]

Have you tried a compact and repair to see if there may be corruption?
Tell us more about the application. How many simultaneous users?
Is this a split front end/backend set up?

 

[GohDiamond]

Split FE/BE = Yes
No Simultaneous users - One user at a time
Yes I do a C&R at the end of each day on both FE and BE

I'll try RECREATING the tables in another DB, import them into the BE, and refresh the links to see if that will fix it.

CHeers
Goh

 

[GohDiamond]

Implemented the proposed Fix and did C&R on both FE and BE
Everything worked fine today, so, I'll just keep a watch on it for a bit.

Thanks for the guidance,
Cheers
Goh

 

[jdraw]

Good stuff. Thanks for updating us with latest status.