tan
Last Activity: Jul 10 '07, 06:53 AM
Joined: Oct 30 '06
Location:
-
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 -
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 codeLeave a comment:
-
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 tabLeave a comment:
-
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?)Leave a comment:
-
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?Leave a comment:
-
problems adding/ updating on client pc
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... -
Thats an excellent idea!!! i think it will work...thanks!Leave a comment:
-
I am getting a file in use error ie 32 using err.lastdllerro r at time of copy execution. It's odd because i can copy an open databse in development/ full access but not in the runtim version. I tried copying an unopen file in the runtime version and the apiCopyFile worked fine...its simply to do with not being able to copy an open file and I have no idea how to get around this now!Leave a comment:
-
apiCopyFile failure in Access Runtime version
Hi, I have installed a runtime version of my Access 2000 programme on a pc (XP OS SP2). I have a button on my main swich menu that is used for the user to backup the database using the apiCopyFile method. This works fine on my development pc but produces a copy failure error on the runtime version,and I cant for the life on me figure this one out. I have also tried to use FileSystem object to no avail (and in fact ran into more issues with that due... -
updating primary keys in other tables automatically
Hi, I curently have 7 tables in my db, all with the same primary key, and 1 form showing all these fields (primary key form only 1 table). Is there anyway that once a primary key has been entered on the form that it can update all the other primary keys (in this case hospital id). I need to be able to do this so that the form will show the information when i re-enter (ie all tables must have entered information for the form to appear again). Or do...
No activity results to display
Leave a comment: