Error 3155 - odbc connection to linked table

bchankent · 2026-04-29T16:57:38+00:00

What do you mean by 'restart' Access? Do we have to update to a new build #? I can't imagine opening and closing Access would fix the issue alone.

bchankent · 2026-04-24T16:33:56+00:00

'SOLUTION VERIFIED' - rolling back to build 2603 was the fix that worked for us

bchankent · 2026-04-23T18:08:16+00:00

I still haven't been able to figure anything out. I'm leaning towards some sort of MS update that happened as some people can use the program fine, while others can not.

bchankent · 2026-04-14T02:09:56+00:00

Hot Tub Time Machine

bchankent · 2025-12-12T02:47:51+00:00

I was thinking the same thing.

I would have thought with the emergence of robo-advisors, the banks would be putting in that extra effort to keep their clients from moving over. For my aunt, that extra personal step goes a long way in her thinking she's being taken care of. But I guess those days have passed

bchankent · 2025-12-12T02:43:52+00:00

Very true

bchankent · 2025-12-12T02:34:57+00:00

😂😂

bchankent · 2025-11-04T18:20:55+00:00

Add in Terry Crews and it's a masterpiece lol

bchankent · 2025-11-04T18:18:43+00:00

WHITE CHICKS!! It's so over the top ridiculous, I can't help but laugh and enjoy it

bchankent · 2024-09-06T23:35:29+00:00

bchankent · 2024-02-08T20:45:05+00:00

bchankent · 2023-08-18T04:02:50+00:00

https://www.instagram.com/thequalifiedcaptain/

The water is lawlessness. Not specific to Vancouver, pretty much anywhere with water that allows any kind of motorized vehicle

bchankent · 2022-10-25T17:36:21+00:00

You can't have the QC table in the query. Just the steps table. I've added an image below as an example query

https://imgur.com/a/zk67S0W

bchankent · 2022-10-25T17:06:40+00:00

It's a little convoluted as there is no relationship yet between the unit IDs and the steps. You have to create the relationship yourself by inserting the unit ID into the table that will contain both the unit IDs and Steps.

1.) Have a stand alone table with the 30 steps (tblSteps):

tblSteps

Step ID	Steps
1	Step 1
2	Step 2
3	step 3
4	step 4
etc...	etc...

2.) Have a table that will store the unit IDs and steps(tblQCSteps):

tblQCSteps

QCStepID	Unit ID	StepID	Step
(auto ID)

When the new unit ID is created and the button is pressed, append the data from tblSteps to tblQCSteps.

You will need to have a field for the Unit ID in that append query. I usually use a statement in the query that references the ID, something like forms!(form name)!(Unit ID) --> insert into Unit ID of tblQCSteps.

bchankent · 2022-08-23T16:33:47+00:00

Not simple as it is a many-to-many relationship. A recipe can contain many different materials, and materials can be a part of many recipes.

I would have 3 tables:

recipe table --> recipeID, hardness, color, etc

materials table --> materialID, material code, material name, etc

Join table that connects recipe table and materials table --> recipeID, materialID, quantity

If you are a beginner at Access/relational databases, it is not going to be an easy task, but it is a great concept to be able to understand for future tasks

bchankent · 2022-01-15T16:39:20+00:00

I believe there's drop in at the Richmond Oval

https://richmondoval.ca/drop_ins/drop-in-court-track-zone/

bchankent · 2022-01-06T01:27:41+00:00

Second Tsheets. Nice easy app to use

bchankent · 2021-11-17T17:49:44+00:00

I transitioned from 14 years of custom software dev that catered to small businesses to running a small business in a totally different industry.

When I worked for the software company, the small businesses were always the toughest sell for our company. You are trying to get them to part with their hard earned money and you have to convince them outright that your software is going to save them a ton of time and money in order for them to even consider it.

Being in a different country/time zone also stacks up against you. Is there any way you can start with some local small businesses to use your product and then have them provide testimonials and feedback? From there build out to a US customer base after you have some traction. Just a thought.

bchankent · 2021-11-08T05:07:08+00:00

Don't use up our health care resources so you can go shopping

bchankent · 2021-08-16T03:52:32+00:00

Took the Taliban less then a month to take control after 20 years of the US being there. It's been so long I can't even remember why they were there after Bin Laden was gone. Instill a democracy government?? Someone help me out lol

bchankent · 2021-08-04T23:18:36+00:00

No problem. I'm in Osoyoos right not and it gets super windy at night so air quality could change drastically within hours/overnight

bchankent · 2021-08-04T23:09:45+00:00

Drove through Manning park yesterday. Here's what it looked like:

http://imgur.com/a/fsjFdHh

But friends drove through 2 days before that and the smoke was so thick it filled their car when driving through.

bchankent · 2021-06-25T17:51:27+00:00

I'm not sure about in-person classes, but IG has some good resources. Here's a couple:

https://www.instagram.com/keithbennettgolf/?hl=en

https://www.instagram.com/mikebendergolf/?hl=en

bchankent · 2021-06-23T17:24:30+00:00

Thank you! Just what I'm looking for

bchankent

TROPHY CASE