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
2 2160
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
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.
Sign in to post your reply or Sign up for a free account.
Similar topics |
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 be correct. I 've tried several
other things, also leaving out the
adOpenDynamic, adlockOptimistic.
If I run this code as VBA in an Access database, it works without problems.
<%
|
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 some of them are not
working because of "recordset is not updatable". Looks like VB is not
working. I don't understand on most of my co workers' computers, the
same database is working fine. On 2 machines, the DB has the same
problem. The Access...
|
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 belongs
to any of those. I have checked all permissions, locks, etc.. - can't
find anything out of the ordinary that would explain it. Deleted the
DistinctRow - no change. The SQL version is below - anyone notice the
problem or have any...
|
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
receive the message "Cannot apply filter on one or more fields
specified in the filter property".
here is the code for the recordset creation:
Set conn = New ADODB.Connection
Set rsSQL = New ADODB.Recordset
|
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 query: QryICTMassDistribution3) , I then use a form and
the code below to create a new record in the corrispondence table to show
what corrispondence has been sent to various companies.
| |
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 AdOpenStatic, even if I choose
adOpenDynamic. If anyone has any thoughts, please let me know. The form
works great for viewing, but I cannot update or insert any new records.
Below is the code I am using:
connectstr = "DSN=SAP_PG;uid=postgres"
Set conn...
|
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 clause'.
CCDE is a field from one of the table and is not a field I am updating.
I uses MyODBC with VB6 and MySQL 5.
|
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 the user to add/change/delete any data, apparently as a result of adding a GROUP BY clause to a View used indirectly as the form's Record Source.
I really don't believe that this restriction needs to be there, and I'm hoping that someone can suggest...
|
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)
I am unable to edit or add any records from the forms, when the data is viewable from sql server connection.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |