Topics Search

Unable to remove link to table

Unable to remove link to table
Views: 5
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:

More topics

 

How to remove a linked table

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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
 

History Table

Preview
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.
 

How to upload images in a form

Preview
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?
 

Using Linked Table Manager --Can't get it work

Preview
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

Preview
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

Preview
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?