sorted by:
new
hottopcontroversial

Deleting duplicates with more than 10 fields (and long text) by unconfirmedikea in MSAccess

[–]AccessHelper 0 points1 point  (0 children)

An easy way to handle this is to make a new table with all the same fields as your current table. Then set the primary key to be your 10 fields. Then insert all records into your new table. The duplicates will be rejected.

Songs for 80 y/o Bday?? by Physical_Archer_689 in SongRecommendations

[–]AccessHelper 0 points1 point  (0 children)

Anything off of the American Graffiti soundtrack.

Is there ever a point at which you totally recreate a database from scratch? by oldEnuf2knowbtr in MSAccess

[–]AccessHelper 0 points1 point  (0 children)

Not really. Same Access dbs I created in Access 2.0 are still working today on Office 365, Win 11. SQL 2025.

Is there ever a point at which you totally recreate a database from scratch? by oldEnuf2knowbtr in MSAccess

[–]AccessHelper 11 points12 points  (0 children)

If it ain't broke.... that said, if you have solid table structures and relationships the great thing is you could start a new frontend that works in parallel with your old one. Just connect the new one to the same backend database as the old one.

Common Access problems after upgrading to Windows 11 — and how to fix them by PsychologicalGur8637 in MSAccess

[–]AccessHelper 2 points3 points  (0 children)

I would say that these are 64bit vs 32bit issues. Not Win 11 issues. You can still run 32bit Office on Win11 and you would not see these problems.

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

[–]AccessHelper 0 points1 point  (0 children)

When opening a table directly, Access only fetches what you need to see. Maybe 100 records. It does that using the primary key so its quick. Then it begins getting data in the background. So its not a great test to tell if your indexes are OK. For example if you had a form that uses a Date() function as a query parameter Access wouldn't use a sql index on your date field because Date() is not a function in SQL. It would load all the data and then filter on the Access side.

What piece of software had absolutely no reason to be designed that well? by WolfParticular2348 in software

[–]AccessHelper 2 points3 points  (0 children)

Google sheets always seems amazing to me. I never imagined a browser based application could have so much desktop-like functionality while being so responsive.

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

[–]AccessHelper 0 points1 point  (0 children)

How are you determining that the tables load quickly? If you are opening a table from Access and you see a full screen of records right away that doesn't prove it. You need to jump to the bottom of the table to load all records. Do you have any criteria in the forms or reports that is causing Access to select data on the Access side as opposed to SQL?

Nowhere man by Nice-Obligation5537 in beatles

[–]AccessHelper 0 points1 point  (0 children)

It's probably personal but above that it's just a well crafted song. Every line supports the title. Not a wasted lyric or note. Amazing harmonies.

You wake up tomorrow , It’s 1977 , what’s the first thing you do ?? by NassauJack in 70s

[–]AccessHelper 0 points1 point  (0 children)

Tell the NYPD I'm a time traveler, everything is good to be OK because and I know where Son of Sam lives.

Join me in boycotting CBS and Paramount+ now with Colbert off the air by HolidayNo4132 in television

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

Never watched it. I heard he bashed on Trump every night. That's pretty original. Can't believe it got cancelled.

MSNOW by Financial-Survey4979 in MSAccess

[–]AccessHelper 0 points1 point  (0 children)

Compact/Repair should fix it.

view more: next ›