novaBBS - comp.databases.ms-access - Can't Sort Excel with Access Data Source

Can't Sort Excel with Access Data Source

<3f56a280-20d7-43b3-bab8-e7522ad67389n@googlegroups.com>

https://www.novabbs.com/devel/article-flat.php?id=534&group=comp.databases.ms-access#534

copy link Newsgroups: comp.databases.ms-access

X-Received: by 2002:a05:600c:511c:: with SMTP id o28mr11859389wms.96.1635902652928;
Tue, 02 Nov 2021 18:24:12 -0700 (PDT)
X-Received: by 2002:a4a:528e:: with SMTP id d136mr2854772oob.50.1635902652308;
Tue, 02 Nov 2021 18:24:12 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.128.87.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-access
Date: Tue, 2 Nov 2021 18:24:11 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=100.0.87.206; posting-account=aD5szwoAAABb__OwpgcFTqRK5TPVKp1O
NNTP-Posting-Host: 100.0.87.206
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <3f56a280-20d7-43b3-bab8-e7522ad67389n@googlegroups.com>
Subject: Can't Sort Excel with Access Data Source
From: cin...@smbpartners.com (Cindy Krist)
Injection-Date: Wed, 03 Nov 2021 01:24:12 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

by: Cindy Krist - Wed, 3 Nov 2021 01:24 UTC

I've inherited a database that is used by Excel files where they use an Access query as their data source. The user used to be able to sort and filter the spreadsheet. Now that I've moved the database and Excel file to a cloud server (both on the same server), the user can no longer sort nor filter the data.

I exported the data to a new Excel file and tried using this new file as the data source instead of the Access db, but have the same issue.

Thanks in advance for the help

"Help save the world!" -- Larry Wall in README

devel / comp.databases.ms-access / Can't Sort Excel with Access Data Source

Subject	Author
Can't Sort Excel with Access Data Source	Cindy Krist