Chris Wendel
asked on
Cannot add new field to a table Access 2016
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?
close all forms, reports, or queries that use the table
go to the design view of the table to modify its structure
go to the design view of the table to modify its structure
ASKER
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.
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
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
ASKER
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?
ASKER
That worked. Must have been locked by someone else using it.
please know that web databases will be depreciated -- NOT desktop databases -- so, looking forward, it would be good to change how things are done ...
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.
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.
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.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Also, when the app is split, as it should be, ALL table and relationship changes MUST be made to the BE.