Cannot add new field to a table Access 2016

Chris Wendel
Chris Wendel used Ask the Experts™
on
I am fairly new to access but I am playing around with the Product Inventory Template offered by Microsoft for a small business operation. I want to add a new field to the PurchaseOrders table that will calculate taxes automatically for me because right now taxes must be added manually to the table rather than through a form. Since the table already has a Taxes field, I just need to add a Tax Rate field so that I can right a quick script that will calculate the taxes for me. When I try to insert a new field nothing happens, it just disappears immediately. I assume that there is some sort of lock on that table, but I cannot find a lock of any kind. Does it have to do with this table being attached to a form?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017

Commented:
Once you reconstitute a template, it becomes just like any other database and anything can be modified.  Make sure that you are the only user in the database because certain changes cannot be made if multiple people have the database open.

Also, when the app is split, as it should be, ALL table and relationship changes MUST be made to the BE.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
close all forms, reports, or queries that use the table

go to the design view of the table to modify its structure

Author

Commented:
Tried this an I cannot get it to work. still when I try to add a new field it does nothing. There are some tables I can add a new field to and some I cannot.
CompTIA Security+

Learn the essential functions of CompTIA Security+, which establishes the core knowledge required of any cybersecurity role and leads professionals into intermediate-level cybersecurity jobs.

crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
are some of the tables linked? If so, as Pat said, you must be in the back-end to make changes.
      in the navigation pane, look at the icon before the table ... if it has an arrow, then it is linked.
      You can also see connection information when you hover over a linked table in the nav pane.

Might another person have the database open? Where is the database stored? if on a network, what happens if you copy it to your local drive and change the copy?

what subscription/package do you have? For product information, look under File, Account -- and then on the right

Author

Commented:
It is a web based database so I am wondering if this is the issue, What is the best way to copy all of it to my local drive?

Author

Commented:
That worked. Must have been locked by someone else using it.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
please know that web databases will be depreciated -- NOT desktop databases -- so, looking forward, it would be good to change how things are done ...
Distinguished Expert 2017

Commented:
I agree with Crystal.  This is going to be a worse deprecation than anything we've seen before because unless you are running your own in house SharePoint Server where you can control the version, Access Web Apps will go the way of the dodo bird in 2018.  You can't just hang on  by not upgrading as many people did with the desktop versions.  Now that MS has people under their control with the subscription model, your destiny is no longer your own.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
Chris, for most of the web templates, there is also a desktop template, which would be a better starting point. Access desktop databases have incredible power and can link to data stored in all kinds of formats.

To answer your question about copying data out of the web database -- one way is to make a report database while you are in the web database.  You will be able to open this report database with desktop Access; it will have linked tables and then you can transfer the data to something local.

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 7-Day Free Trial