Unable to remove link to table

A colleague who's 'had a bit of Access training' kindly removed all links from the front end, for reasona that escape me, and I'm putting them back in. However, I have a link to one table that I can't seem to get rid of.

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.

Sponsored Links:

Related Topics

How to remove a linked table
DoCmd.TransferDatabase acLink,.

I link a table to my database. But how to remove such links from the database with VBA?


How do i remove access 2010 security
I have a Access 2003 database converted to access 2010, and some time ago I set a password or user security, and no I would like to remove it but no matter what I do I am unable to remove this security


How do i remove access 2010 security
I have a Access 2003 database converted to access 2010, and some time ago I set a password or user security, and no I would like to remove it but no matter what I do I am unable to remove this security


Unable to create new record in Forms
I have 1 of 1 record showing in a form (created from a simple Table!) that has 4 subforms attached to it. No new records are possible, it will not forward to a blank form. I created a new form with just one subform and it works as it should but don't want to rebuild from scratch. Data tab in the subforms is set properly to link to the primary key of the form - Link Master Fields and Link Child Fields


Unable to view code & module in a database
I have just checked out following link where there is a sample .mdb file which track idle time and logout user from the database after a certain time.

Could anyone help me out to view the codes and modules in sample file attached (HRForm.zip) in below link as I am unable to view anything. Its also doesn't seems to be .mde format.

Also like to know how this can be done to hide everything (forms, query, tables) in a database. without converting it into .mde format (Attached file has a good example on this


How to upload images in a form
I've an employee information table and its form. Every record contains different images.

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?


History Table
I am trying to create a history table that keeps track of all transactions ever processed. The transaction is created from data from a table of tenants and the payment amount entered on the form.

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.


Using Linked Table Manager --Can't get it work
I have used a split Access97 DB for years, with no problems. In preparing for some computer moves, an office person moved the backend of the database and broke the link. We have been unable to get the link re-established. When bringing up the linked table manager, the front end file does not show as a file option--only one DB that I do not need to link to. I have both saved to a USB flash drive for now. When trying to open the front end, it gives the error message that the path is invalid, which of course it is. The front end is password protected, but we know the password, so that is no problem. I have changed PCs over the years and have upgraded the PC that the DB resides on, with no problems until now.

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


Break link between Access 2010 table and a linked list in SharePoint 2010
Does anyone know how to "unlink" a table after linking it to a SharePoint list in MS Access 2010? I created an Access 2010 database and then linked the tables in it to a SharePoint site using the SharePoint button under Database Tools on the menu ribbon.

All that worked perfectly. However, now I need to unlink the tables without deleting them.

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?


Break link between Access 2010 table and a linked list in SharePoint 2010
Does anyone know how to "unlink" a table after linking it to a SharePoint list in MS Access 2010? I created an Access 2010 database and then linked the tables in it to a SharePoint site using the SharePoint button under Database Tools on the menu ribbon. All that worked perfectly. However, now I need to unlink the tables without deleting them.

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


Have a form completely unbound and dont know how to link to table
I have created a form using the DesignWizard, but have not created it from a table. I basically made all of the text boxes, combo boxes, etc.

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.


Unable to import or link tables through odbc in Access SP2
I recently upgraded Office to SP2. Now, whenever I'm in Access and I click
File.Get External Data.Link Tables. and I click on Files of Type and
select ODBC, the entire dialog box disappears. This never used to happen
when prior to upgrading to SP2. Now I can't link to any tables. Has anyone


Error while trying to add delete link button.
I am trying to add a button that will delete a link containing the image link into a table.

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].SetFocus
Forms![Employee Table].Form.Requery
Me![Link].Locked = True
Me![Link].Enabled = False


Can't enter data into a table
I am able to link to an Oracle table through an ODBC connection and update records (directly in the table).

I gave detailed instructions on how to do so to another user. She tells me she is able to see the table, but she can't enter data--she gets a "ding" sound when she tries. I am unable to replicate this situation--it always works for me.

Does anyone know what might be stopping her from entering data? I looked around the Internet for a while, and could not find anything about this issue.


Access: query to remove rows with repeated values in a column?
I'm trying to come up with a query that removes rows where a certain column has the same value (for instance, the column's value is the same in rows #503, #677 and #1020).
There are two catches:
- I can't specify the value (or values) to be checked for repetition, the query has to check for any repeated value;
- I can't also specify the number of repetitions, the minimum is 2 but there's no maximum.

I want to remove all repeated rows, except for the first one. Also, it can't be just a View, I have to actually remove these rows from the table.

I've been thinking, but can't come up with anything. "SQL DISTINCT *" doesn't help because I have to look for repetitions only in this specific column. Perhaps some way of using"SQL DISTINCT [ColumnName]", but I've been unable to form the whole query.

I've also googled about this, but none of the results helped me (either they involved 2 columns, used Distinct in a way that doesn't help my case, used Views or involved 2 tables).


Unable to open table in design view
I am working with a database built in Access 2000 and which has been converted to Access 2007. Since the conversion, the main table is unable to be opened in design view for changes with the following message:

Either an object bound to table XXX is open or another user has the table open. do you want to open the table as read-only?

We have tried several times to open the table ensuring no other users have it open and no other objects are open and running.


Linked tables, data type different
I want to link two tables together, both tables has a field called opr_nbr
This is the operation number (05 for example)
The trouble is in one of the tables the data is a number in the other is text.
The fields are outputs from legacy systems, I want an easy way to link these tables so that I can perform queries on them.

the problem I find is im getting a data mismatch error, as the data is showing as not the same.

When looking at the tables one shows 05 and the other would show 5

is there a way of converting the field during a query. I am unable to modify the table itself, only query from it.

I have been scratching my head on this one for a few days, done some searches on here and still come up with nothing. Hopefully one of you guys can


Link Excel to Access: unable to edit values
I am using Access 2007 with Windows-7, I linked my Access file to a worksheet, but am unable to edit values on the linked table. No message, just won't allow it. When I open the excel file independently of Acccess, it works fine. Eventually, after some combo of events that I don't understand yet, I can't open it for editing and I get some message about in use by somebody else. (there is nobody else.) I downloaded a test mdb and xls file, written in A97. that was posted in this forum in 2009, but that wouldn't work either. Is there some special action that has to be taken wit A2007?


link tables - choose when to link
Is there a way in Access to have a linked table but not have the link open all the time I.e. just to relink/refresh from the source when I decide

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!


Copying a linked table
I have set up a bit of code to copy an exisiting table and change the name slightly:
DoCmd.CopyObject , "TblDetail_" & PWyr, acTable, "TblDetail"

(Where PWyr is an integer which is set earlier)

TblDetail is stored in the back end of my database, and this code is running in the front end. TblDetail is a linked table in the front end.

When running the code, it all seems to work fine. The new table appears with the correct name & data in it.
It has the linked symbol by it, so I thought it had worked perfectly, storing the table in the back end and automatically creating a link to it in the front end.

This is how it acts, anyway. You are unable to open the table in design mode as it tells you its stored somewhere else, and you can succesfully refresh the link etc

BUT. If you go into the back end, the table doesn't seem to be there