Append records in AWA

Member_2_6069111
Member_2_6069111 used Ask the Experts™
on
Access Web App
I want to append records to a table w/ Lookup fields. That doesn't seem to work using a data macro. Its to many records to type them in individually. Any idea?
Best, TT
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014

Commented:
As far as I know you cannot do that. You'd have to connect to the underlying SQL Server from a local desktop app and run your import there.

BTW, Access Web Apps are on the way out, so I'd not invest a lot of time in them:

https://blogs.technet.microsoft.com/the_microsoft_access_support_team_blog/2017/03/31/access-web-apps-to-be-retired/
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
Scott is right. You can connect to the data and run action queries from the desktop.

it would be good to do more of the application from the desktop anyway

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start Today