Unable to remove link to table
It used to have a proper name but now just says 'a', so I have no idea to which table it's linked.
If I try to open it, look at it in design view, etc. I get an 'Invalid Argument' message.
If I try to delete the link, I get an 'Invalid use of null' message.
Renaming it still works, but that's about it.
I've tried compacting and repairing the front end but that achieved nothing. It may be causing no harm, but I'd like to get rid of the link.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I link a table to my database. But how to remove such links from the database with VBA?
I append this data to the transactions table. The problem I am encountering is I am unable to delete a tenant from the tenants table because of its relation to the transactions table. I do not want to remove the tenants transactions. I want the table to be a history of transactions.
When I use the More Options > Delete List menu option on the right-click menu of one of the linked tables, a message appears that says "You are about to delete the list and all its data from the SharePoint Site. Do you want to continue?". That sounds like what I want it to do (remove the list from SharePoint but keep the table in Access). But when I proceed, not only does it remove the list, it also deletes the table in MS Access!
Is there no way to break the link between an Access Table and a SharePoint list once established
I know I could just import the table but its a big table!
The reason I ask is that an excel workbook also uses a connection to this file (a Dbase file) and when I am running queries in Access that use the linked table in excel it says the link isopened exclusively by another user I.e me!
I've found that people are suggesting to store images on hard drive, not on the database directly. They suggest to store the image link in a text field. I'm agree with them.
But what I didn't find is how end user will upload a new image? Or, remove an existing one?
I want 2 command buttons right below those images that will enable end user to add/remove an image from form of that employee/new employee. When someone will click on the add image, a browser window will appear and he'she will be able to select the image.
Access will save it's link itself. While deleting, access will delete its link too and display no photo image.
I've programming experience in C (but not in VB).
How can I do that?
I am getting a debug error when a click on it.
Run-time error '2110':
Microsoft Office Access can't move focus to the control Link.
Private Sub cmdDeleteImage_Click()
Me![Link].Enabled = True
Me![Link].SetFocus <-----error is here at first.
Me![Link].Locked = False
Me![Link].Text = ""
Me![Link].Locked = True
Me![Link].Enabled = False
What am I probably doing wrong? Why will not the front end show in the Linked Table Manager? What should I do next? This is a very important database to the office
from the Control Wizard. I have spent a long time creating this form - and have used quite a bit of code to create pop-up calendars, hint text, etc. so starting over is really not an option.
I did not realise that creating an unbound form was going to be such a nightmare!
My problem is - I am obviously unable to create new records or save any input data as the form is not linked/bound to a table. I was told I would need to create headings in a table and link each individual text box, combo box etc.