473,320 Members | 1,699 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Recordset is not Updatable error when linking tables

53
Hi,

A coworker of mine can not link or import tables into her Access database files, whether its from the server or from her own harddrive. When she tries, she is getting the message "Recordset is not Updatable." I asked her to put the database file and the excel file on the server so I can try it from my computer and everything worked perfectly fine from my computer.

Does anybody know what the problem is from her computer and how I can fix it?

Thanks in advance,

Raza
Jul 25 '08 #1
2 2146
Stewart Ross
2,545 Expert Mod 2GB
Hi RZ15. Could you advise where your friend is trying to run the DB from? If it is from her hard disk then the lack of updatability is a real puzzle, but if it is on a shared network drive there may be a permissions issue with your friend's network rights preventing write updates. I am most familiar with Novell Netware systems, and for users to have full update rights to the shared database they would need to be granted Read, Write, Edit, Create and Delete permissions.

-Stewart
Jul 27 '08 #2
RZ15
53
Hi RZ15. Could you advise where your friend is trying to run the DB from? If it is from her hard disk then the lack of updatability is a real puzzle, but if it is on a shared network drive there may be a permissions issue with your friend's network rights preventing write updates. I am most familiar with Novell Netware systems, and for users to have full update rights to the shared database they would need to be granted Read, Write, Edit, Create and Delete permissions.

-Stewart

Hmm, it is possible that she was running the file from off the server and does not have the rights (even though she should). She is on vacation, so I will check with her on Thursday when she comes back and then let you know if the problem is still there.

Thanks.
Jul 28 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Martin van Vliet | last post by:
Hello, When I try to run the following code I get an error: "Recordset not updatable". It is possible to show data from the same table on a webpage, so the database name and the table nam must...
4
by: cronept | last post by:
Hi, I made a database and split it to one back end and one front end. I am using Access 2000. I put the front end db on my co workers' computers and the back end on the server. The problem is...
7
by: Martin Lacoste | last post by:
I have a very basic query that Access 2000 will not allow to be updatable. I've gone through all the situations in the help file where data cannot be updated, and I don't see that this query...
2
by: Patrick Gonzalez | last post by:
Is it possible to use the built-in filter functions (ie. "Filter by Selection", etc..) when a form's recordsource has been set to a recordset object during the load event. When I try to do this, I...
13
by: Jan | last post by:
Hi I have a database that I use to keep track of the sales promotions that we send to companies. I normally send a mailing based on a subset of the companies in the database (found using the...
3
by: Sim Zacks | last post by:
I have a postgresql backend with an access front end and I am trying to redefine the recordset of the form to use an ADO recordset. The problem is that the CursorType always changes to...
5
by: zMisc | last post by:
Are there any tricks in updaitng a JOINed recordset? I joned to tables and when I try to change a field on the recordset and update it, I get this error: "Unknown column 'CCDE' in 'where...
17
by: radio1 | last post by:
Configuration: Access 2002 and SQL Server 2000 using a .ADP Project. I would VERY MUCH appreciate anyone's input into this problem I'm having. I have a form in Access that does not permit...
3
by: ruthboaz | last post by:
Hi, I am upgrading the current ms access .mdb file to a .adp with sql server back end. I have been converted tables, forms, reports to .adp.. The tables are reflected at the server. a) ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.