tan 10
New Member
Hi, I have tested my databse and everthing works fine but then have given it to a customer and the following part of the code does not seems to be updating as required.
Set rs = db.OpenRecordse t("LTOT_second_ oxygen2", dbOpenDynaset)
rs.FindFirst "[HospitalNumber] = '" & Me![general_info.Ho spitalNumber] & "'"
If rs.NoMatch Then
rs.AddNew
rs![HospitalNumber] = Me![general_info.Ho spitalNumber]
rs.Update
End If
Any ideas why this could be-I am stumped!!!?????
Could this have anything to do with access permissions set by an IT department? At the moment i havent set any form of workgroups, permissions etc as its only a beta trial database with one client.
10 1413
Hi, I have tested my databse and everthing works fine but then have given it to a customer and the following part of the code does not seems to be updating as required.
Set rs = db.OpenRecordse t("LTOT_second_ oxygen2", dbOpenDynaset)
rs.FindFirst "[HospitalNumber] = '" & Me![general_info.Ho spitalNumber] & "'"
If rs.NoMatch Then
rs.AddNew
rs![HospitalNumber] = Me![general_info.Ho spitalNumber]
rs.Update
End If
Any ideas why this could be-I am stumped!!!?????
Could this have anything to do with access permissions set by an IT department? At the moment i havent set any form of workgroups, permissions etc as its only a beta trial database with one client.
More likely has to do with missing vb library references. Go to vb editor, select Tools>Reference s.....Any show as "Missing"?
tan 10
New Member
no all the references are there.i have tested it on 5 pc's (including one totally clean) and it works fine in both a full and runtime version-its just this client.im not sure if its something to do with opening a recordset in code? permissions with this?
no all the references are there.i have tested it on 5 pc's (including one totally clean) and it works fine in both a full and runtime version-its just this client.im not sure if its something to do with opening a recordset in code? permissions with this?
You need to provide more info ......your version of Access, your operating environment (Windows XP, etc.). Is your application split, etc.
1. In your recordset code, you did not post your declarations. Did you declare (dim) the recordset as a DAO/ADO Recordset? Are vb library references set for DAO, ADO?
2. Does client machine have same version of Access?
3. Are any ActiveX controls being used in the application that have to be registered with Windows Regsvr32.
4. Has MDW workgroup security file been properly set up?
tan 10
New Member
i am using access 2000 on xp operating system-this is also what the client has.i have also tested on a vista op and that was fine.
yes i have included:
Dim db As DAO.Database
Dim rs As DAO.Recordset
I do not use any activex controls, but i have not set any workgoup security files (could this be where my problem is?)
i am using access 2000 on xp operating system-this is also what the client has.i have also tested on a vista op and that was fine.
yes i have included:
Dim db As DAO.Database
Dim rs As DAO.Recordset
I do not use any activex controls, but i have not set any workgoup security files (could this be where my problem is?)
The system MDW was probably set up for you during the install. You should be able to verify that the System.MDW file exists (refer to article in link). The update failure you originally alluded to seems more like it could be related to not granting the proper permissions to the shared folder where the mdb/mde file has been placed.
Using MyComputer on the Windows Desktop, Right-click on the shared folder where you have the mdb/mde installed and select Sharing And Security. The Properties dialog box for the folder should display four tabs: General, Sharing, Web Sharing, and Customize. Select the Sharing tab, and it should be divided into two sections: Local Sharing, and Network Sharing And Security. Make sure the Network Sharing is set for the shared folder, and that local sharing is turned off.
2. Log on as an administrative user, right-click the shared folder in question, choose Properties, click Security, click the Advanced button, and click the Effective Permissions tab. Select a user or group to view the effective permissions for that user or group on the specific file or folder. Are they correct?
See this link for an excellent reference for security . http://www.uky.edu/~dsianita/622/access_security.pdf tan 10
New Member
how come they can update information through the data entry form then and note through code? i could not find the effective user permissions from the advanced tab
how come they can update information through the data entry form then and note through code? i could not find the effective user permissions from the advanced tab
Good question. On one hand.....since no (application) user level security has been set up, everyone has full access to the database....on the other hand, if full permissions have not been granted to users of the shared folder (via Windows security), only a windows system administrator would have add/update/delete privileges to shared folder...and just because you can enter info on the forms doesn't mean the underlying tables were updated.
tan 10
New Member
thats the bdd thing though, any data entered via the data entry form is added to the tables, just not the data that should be updated via the code
tan 10
New Member
hey, thanks to everyone for all their help! the problem is sorted.the database had been saved to all users/application data, so that when the database was opened by a limited user updates and additions via open recordset were not allowed. i solved this by simply moving the folder to the C:/ drive - phew
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Ted Byers |
last post by:
This is quite frustrating! In the documents, and in the newsgroups, I see
simple instructions like the following:
===============================================
==========Beginning of Ray's example=================
===============================================
Suppose you want to run class com.xyz.Main. Then create a manifest file
like this:
======== main.mf starts on the next line ====
|
by: mb12036 |
last post by:
All-
Having a problem installing a DB2 client on a machine running AIX
version 5.0. Client appeared to install one time succesfully, then
was uninstalled and a reinstall was attempted. For some reasons, it
does not complete the reinstall. See the status report from the GUI
installer at the end of this note. Errors are towards the bottom.
Everything installed in /usr/opt for DB2 but the sqllib folder that is
supposed to be created in...
|
by: mcbill20 |
last post by:
Hello all. I just installed Oracle 10g developer tools on a machine
running XP Pro and Office XP. Before this I had just the Oracle 9
client installed. I the previous configuration, I was able to access
any of the Oracle tables on another machine but now I am having
problems. Unfortunately, I don't remember the correct syntax for the
ODBC connect string and I am hoping that is my whole problem.
I am trying to connect to an Oracle 9...
|
by: matvdl |
last post by:
I have a system that was originally developed in asp - the pages are saved in
SQL (there are over 10,000 pages) and saved to a temp directory in the server
when requested by a client.
I have updated this system and changed the pages that are saved to the
server as aspx - everything works fine and pages can be served - but
Its not impossible for a single client to request 100 plus pages in one
session - as each page is requested it is...
|
by: Carl Gilbert |
last post by:
Hi
I would like to know that best way of adding data to the session state
object.
I have a page with a series of links such as:
designs.aspx?categoryID=1
designs.aspx?categoryID=2
When I get to the designs page I can then add the chosen category to the
| |
by: James |
last post by:
I have a VB windows forms application that accesses a Microsoft Access
database that has been secured using user-level security. The
application is being deployed using No-Touch deployment. The objective
in utilizing this new deployment method is to reduce the maintenance
overhead as well as making it easier for my users to setup and run the
application initially. I have VS 2002, Windows XP, Access XP(2000
format).
He is my problem....
|
by: gn |
last post by:
I have a form that is used for adding, updating and deleting records in
a table, everything works fine except that one of the fields uses a
list box, this works fine for adding a new record but will not work for
updating a record, when you click off that record and back on it has
reverted to it's previous value. All the other fields which are
textboxes update just fine.
What is the difference?
|
by: Ian Mackenzie |
last post by:
Hey Guys
I have just upgraded from V8,2 to 9.1 Express C and have hit a couple
of problems.
Here we go:
I have created an app in delphi, which connects with the following
connection string:
Provider=IBMDADB2.1;Password=****;Persist Security Info=True;User
|
by: lotus18 |
last post by:
Hi everyone
I have a little problem in updating a record. I know how add a new record and check if the inputted new data is existing or not as what they have discussed in http://www.thescripts.com/forum/thread733529.html.
Now, my problem is... How can I check if updating data is existing or not? Please help!!!
Here's my sample code in adding a new entry:
Public dbConnection As New ADODB.Connection
Dim dbPath As String
|
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: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |