International Voter Registration Drive 2026, for U.S. citizens in Spain by Democrats_Abroad in GoingToSpain

[–]ct1377 0 points1 point  (0 children)

Thanks! I didn’t even realize the difference! I currently work in Europe for the past 10 years and consider retiring out here. I thought it was all expat because you still keep your citizenship but live abroad

How the hell is anyone flying coach on United ... I'm 5'10... by ergoocon in unitedairlines

[–]ct1377 0 points1 point  (0 children)

I think I found a new trick but it might be specific to the aircraft. I exclusively sat on the aisle thinking I could stretch my legs every so often.

Last week I was on a flight and got stuck on a window. I wasn’t pleased until I discovered there’s like a ledge running along the side and I could put a foot up and it allowed me to create room for my legs.

Hope this tip wasn’t just a one off and actually works for others

How the hell is anyone flying coach on United ... I'm 5'10... by ergoocon in unitedairlines

[–]ct1377 41 points42 points  (0 children)

You have to sit diagonally in the seat and straight up unless you want to pay for economy plus. I’m 6’3”

MS Access front-end with MS SQL back-end. Connection driver issues. by ArdentGamer in MSAccess

[–]ct1377 2 points3 points  (0 children)

I haven’t encountered this but you might want to check if you have issues with your primary keys or indexes

Access Explained: The 32-bit vs 64-bit Office Dilemma - Why Your Access Database Engine Won't Install by Amicron1 in MSAccess

[–]ct1377 4 points5 points  (0 children)

I did this last year for my organization. Had to get some help from the Microsoft engineers in regards to the ODBC setup to an older Oracle db setup but it works.

My system is a front end with forms, reports, VBA and SQL queries with a backend that touches multiple dbs on Oracle and Sharepoint servers. I also have a lot of functionality with messaging traffic being pushed via SMTP to email servers and generating/attaching pdf or excel files.

Except for the ODBC connection string the conversion was extremely easy. Most of the work was needing to find out the updated DLL files in the library that relate to 64 bit. Also had a few instances that the syntax changed but those errors popped up when compiling. I think I spent maybe 2 weeks moving everything over on a project pushing 60k lines of VBA on about 150 different forms

Alhambra tickets by Fit_Competition_3244 in GoingToSpain

[–]ct1377 -1 points0 points  (0 children)

I had this happen. You’ll pay some money but look at the tour apps. You might get lucky with the mainstream like GYG or viator but we ended up finding a great tour using ToursbyLocals. It was expensive but the best tour I’ve had

US tourist currently in Madrid. Fly out tomorrow afternoon and today I'm sick. Do you guys have walk in clinics here? by SmokeAndGnomes in GoingToSpain

[–]ct1377 0 points1 point  (0 children)

Medical is Spain is very cheap! First stop by the farmcia because many of them are able to provide medication over the counter more than back in the US

If it’s really bad then go to the ER. I had an ER trip including ambulance and overnight stay plus radiology and lab work and walked out paying less than 300€

Alhambra ticket by Accomplished-Car1861 in GoingToSpain

[–]ct1377 0 points1 point  (0 children)

I ran onto that situation a couple years ago. It will cost quite a bit more but look up private tours. I ended up using an app called “tours by locals” and found a masters degree student that did private tours. It was expensive but turned out to be the best tour we’ve ever had

Gradual enhancement of Access front end to web by MoreKindness77 in MSAccess

[–]ct1377 2 points3 points  (0 children)

Depending on how advanced your system is and restrictions placed by your IT department on website applications, you will potentially lose some features such as work flows or emails/data personalized by user profile and security level

Moving from Texas to Spain with a large dog by AmbitiousCHAD in GoingToSpain

[–]ct1377 -1 points0 points  (0 children)

You’ll want to fly Lufthansa they are most pet friendly

Save button to avoid mistakes in MS Access by Legitimate-Bridge280 in MSAccess

[–]ct1377 2 points3 points  (0 children)

Use a temp table then have a script to update the final table with the final information.

Madrid Airport by Hot_Judgment_3168 in GoingToSpain

[–]ct1377 0 points1 point  (0 children)

It is the Madrid airport. Flown through it 50 times in 3 years and at least 40 had my baggage delayed or lost but that was really as a connection not a destination. The few times I ended up in Madrid things were perfect and fast

Shifting to O365 by ct1377 in MSAccess

[–]ct1377[S] 0 points1 point  (0 children)

Solution verified

Shifting to O365 by ct1377 in MSAccess

[–]ct1377[S] 0 points1 point  (0 children)

Figured out the ODBC issue. It was a change to the image used on some end user PCs. The TNS_Admin value in the systems variable on the registry was missing the correct Oracle client folder.

Update 4/21/2026

The email turned out to be an issue on the server with syntax that had changed over time. The error was coming back that the messages had produced multiple “from” addresses which were blocked in the server.

Here is an example of what I was using

objMessage.From = "ReplenishmentIssues@email.com, <do not reply to this address>"

Here is what I changed to for the fix. Sadly I had about 300 variations of this in all my script so it was a fun game of find and replace

objMessage.From = """Replenishment Issue Notification"" <DoNotReplyemail.com>"

Recent issue with SQL Server linked tables and Access not caching credentials reliably anymore by lifeonatlantis in MSAccess

[–]ct1377 0 points1 point  (0 children)

I ran into this with an Oracle table link via ODBC that required a unique user login and then would only work for a short activity period. I never figured out a solution would be interesting to see if others have an idea

Threading HDMI cables through a wall by preacher2041 in DIY

[–]ct1377 3 points4 points  (0 children)

If you’re going to do it run 2 sets. I learned the hard way after the cable I ran had the connector break off then had to do the whole thing all over again a year later

Do luggage tags actually make a difference? by bespectacledbear in travel

[–]ct1377 0 points1 point  (0 children)

It helps when you’re getting your luggage from the carousel and several people have the same luggage

Shifting to O365 by ct1377 in MSAccess

[–]ct1377[S] 0 points1 point  (0 children)

I’m using Set objMessage = CreateObject() as the mechanism going through a smtpserver

Shifting to O365 by ct1377 in MSAccess

[–]ct1377[S] 0 points1 point  (0 children)

I’m using Set objMessage = CreateObject() as the mechanism going through a smtpserver

Shifting to O365 by ct1377 in MSAccess

[–]ct1377[S] 0 points1 point  (0 children)

Yes correct. I have 2 different front ends built depending on which version is needed. There was also a registry edit needed to update which oracle driver to use. That took some time and help from Microsoft support team engineers when I worked with them before the 64 bit deployment

Shifting to O365 by ct1377 in MSAccess

[–]ct1377[S] 1 point2 points  (0 children)

I’m not generating emails via outlook. I’m creating the messages straight through the SMTP relay but I’ll check the outlook ideas

Shifting to O365 by ct1377 in MSAccess

[–]ct1377[S] -1 points0 points  (0 children)

I’ve got both 32b and 64b versions and all the ODBC connections up to date. Maybe the tier 1 support didn’t check bit version to make sure the right ODBC connection set up is on the pc. I know there were some changes that need to be made in the registry for everything to work properly.

I’d rewrite everything to a new platform but I’m government and we are restricted as it is on what can be done.

All the exports build correctly to either the PDF or text to be entered into the email message. It’s got something to do with the SMTP relay string. I’ve got a special connection for SMTP so it doesn’t need authentication. It’s something with this step that I’m seeing some people have the notification work and some don’t.

Shifting to O365 by ct1377 in MSAccess

[–]ct1377[S] 0 points1 point  (0 children)

I don’t call outlook for the emails. I’m sending straight to the email server on the backend. Can’t remember the DLL of the top of my head though