Ad: Manage updates with the Download App
ie8 fix

Office & productivity software forum: MS Access - 'Object Bound to table' - cannot edit

by: sheilasabado April 4, 2010 5:15 AM PDT

Like this

0 people like this thread

Staff pick

MS Access - 'Object Bound to table' - cannot edit

by sheilasabado - 4/4/10 5:15 AM

I cannot edit a table located in the server. It always gives me an error that says "Either an object bound to table 'PHONE_DATA' is open or another user has the table open.." (please see screenshot below)

[IMG]http://i838.photobucket.com/albums/zz304/contactopia/ABS_FE.jpg[/IMG]

But I am sure that there is nobody in the network that is accessing the specific database or table except for me. I also have full permission in the server.

I would really appreciate your help on this. Regards.


Reply
Report offensive post
Email to friend

Is this the same problem

by MarkFlax Moderator - 4/4/10 11:18 AM

In Reply to: MS Access - 'Object Bound to table' - cannot edit by sheilasabado

as you reported here?
http://forums.cnet.com/5208-6129_102-0.html?threadID=389443

If so, it is best to keep to one discussion as it avoids confusion and duplication of content.

Assuming it is the same, then all I can say is that the same thing happens with a networked Excel spreadsheet file. Since it cannot be edited by more than one person at a time, it cannot be opened for editing if anyone else is using it. However you can open it as Read Only.

Mark


Was this reply helpful? (0)   (0)

Staff pick

Reply
Report offensive post
Email to friend

Not the same problem.

by sheilasabado - 4/4/10 9:16 PM

In Reply to: Is this the same problem by MarkFlax Moderator

Hi Mark, thank you for your reply. I'm not sure on how it can be the same problem. Since this thread says that I cannot edit the table where the forms are linked while NO user is accessing it, meaning I am the only one using it and the other thread says that only 2 users can open a form even for the purpose of Read Only at the same time. I know you can only edit when other users are not accessing the said table and I made sure that everyone have their forms closed and I am the only one who has access to the table at that time.


The other thread is different. And also regarding the excel spreadsheet, you can arrange an excel workbook to be shared and changes to be allowed by one person at the same time through, Tools and Share Workbook.

Regards,
Sheila


Was this reply helpful? (0)   (0)

Staff pick

Reply
Report offensive post
Email to friend

Ahh, my error then.

by MarkFlax Moderator - 4/5/10 2:59 AM

In Reply to: Not the same problem. by sheilasabado

Thanks for that Sheila, and I hope others here will be able to help with your problems.

I didn't know that about sharing Excel spreadsheets. I learn something new everyday here, happy

Mark


Was this reply helpful? (0)   (0)

Staff pick

Reply
Report offensive post
Email to friend

"A table on the server".

by Kees Bakker Moderator - 4/5/10 12:54 PM

In Reply to: MS Access - 'Object Bound to table' - cannot edit by sheilasabado

That's a rather unclear description. Let me see what it can mean:
1. A certain table in a certain database on a MS SQL Server, Oracle, MySQL (whatever) database.
2. All tables in that database.
3. All tables in all databases on that server.
4. A certain table in a certain .mdb file on a Windows 200x server that I access via a drive letter that my own mdb-file links to.
5. All tables in that .mdb file
6. All tables in all mdb-files on that server.
7. All tables in all mdb-files on all servers.
8. My mdb-file is on a Windows share (say f:) and I can't edit a certain table in this mdbf-file.
9. My mdb-file is on a Windows share (say f:) and I can't edit any table in this mdb-file.

By the way, what do you mean with 'editing a table'. The data view or the design view?

Kees


Was this reply helpful? (0)   (0)

Staff pick

Reply
Report offensive post
Email to friend

Clarification

by sheilasabado - 4/5/10 9:17 PM

In Reply to: "A table on the server". by Kees Bakker Moderator

Hi Kees,

Let me see if I can clarify it a bit.

We keep two files:
1 - ABS_BE.mdb which is located in a Microsoft 2000 Server. This is the Back end database where all the data is stored.
2 - ABS_FE.mdb which is distributed to all users. It has a form linked to PHONE_DATA table which is located in the ABS_BE.mdb.

I am trying to edit PHONE_DATA table ABS_BE.mdb (Design View) to be able to add more field. Before I do this, I made sure every user has their own ABS_FE.mdb closed and checked if the ABS_BE.mdb located on the server has no ABS_BE.ldb 1kb file which indicates someone has it open.

I hope this makes things more clear.

Thanks,
Sheila


Was this reply helpful? (0)   (0)

Staff pick

Reply
Report offensive post
Email to friend

Re: editing table

by Kees Bakker Moderator - 4/6/10 12:22 AM

In Reply to: Clarification by sheilasabado

I've never seen this particular error message, although I've used this same construct.

What happens if you copy this data-mdb to your own PC, do the change and copy it back? Logically speaking, one expects the same error. If so, it becomes a game of elimination and work-arounds to find the culprit. It could be something like a macro that runs at opening the database.

The worst that can happpen is that you have to make a new database, make a new table definition in that database and import the data from the old database. Can't be more than half an hour work.

Kees


Was this reply helpful? (0)   (0)

Staff pick

Reply
Report offensive post
Email to friend

Re: editing table

by sheilasabado - 4/6/10 2:22 AM

In Reply to: Re: editing table by Kees Bakker Moderator

That is exactly what I did for a work-around at the time that I needed to make the changes to the specific table. I copied the ABS_BE.mdb in my PC and made the changes in my own copy. It did allow me to edit the database in Design View and I had to copy it in the server to replace the original file.

I was also wondering whether the Macros are the cause of this problem. Anyway, I'll try your suggestion and do an elimination and see which of these macros are causing the problem.

Thanks Kees.


Was this reply helpful? (0)   (0)

Staff pick

Reply
Report offensive post
Email to friend

MS Access - Either an object bound to table "XXX" is open...

by evagg - 5/27/12 7:04 AM

In Reply to: MS Access - 'Object Bound to table' - cannot edit by sheilasabado

I'm no expert, but here's how I solved, or g0t around this problem. Right click on the name of the table in Access Objects and left click on open. When the table opens, right click on the top margin of the table bar. Left click on close all. Now right click on the name of the table and left click on Design View and it should open for editing. Hope it works for you.
Regards,
Gary


Was this reply helpful? (0)   (0)

Staff pick

Reply
Report offensive post
Email to friend

More Discussions

Forum Icon Legend

  • UnreadUnread
  • ReadRead
  • Locked threadLocked thread
  •   
  •   
  •   
  •   
  •   
  •   
  •   
  • ModeratorModerator
  • CNET StaffCNET Staff
  • Samsung StaffSamsung Staff
  • Norton Authorized Support TeamNorton Authorized Support Team
  • AVG StaffAVG Staff
  • avast! Staffavast! Staff
  • Webroot Support TeamWebroot Support Team
  • Acer Customer Experience TeamAcer Customer Experience Team
  • Windows Outreach TeamWindows Outreach Team
  • DISH staffDISH staff
  • Dell StaffDell Staff
  • Intel StaffIntel Staff
  • QuestionQuestion
  • Resolved questionResolved question
  • General discussionGeneral discussion
  • TipTip
  • Alert or warningAlert or warning
  • PraisePraise
  • RantRant

You are e-mailing the following post: Post Subject

Your e-mail address is used only to let the recipient know who sent the e-mail and in case of transmission error. Neither your address nor the recipient's address will be used for any other purpose.

Sorry, there was a problem emailing this post. Please try again.

Submit Email Cancel

Thank you. Sent email to

Close

Thank you. Sent email to

Close

You are reporting the following post: Post Subject

If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.

Offensive: Sexually explicit or offensive language

Spam: Advertisements or commercial links

Disruptive posting: Flaming or offending other users

Illegal activities: Promote cracked software, or other illegal content

Sorry, there was a problem submitting your post. Please try again.

Submit Report Cancel

Your message has been submitted and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.

Close

Your message has been submitted and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.

Close

You are posting a reply to: Post Subject

The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to the CNET Forums policies for details. All submitted content is subject to CBS Interactive Site Terms of Use.

You are currently tracking this discussion. Click here to manage your tracked discussions.

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

Sorry, there was a problem submitting your post. Please try again.

Sorry, there was a problem generating the preview. Please try again.

Duplicate posts are not allowed in the forums. Please edit your post and submit again.

Submit Reply Preview Cancel

Thank you, , your post has been submitted.

> Click here to view your post. > Manage your tracked discussions. > Track this discussion. Close

Thank you, , your post has been submitted and will appear on our site shortly.

Close