The BE of my db is located at my PC.
FE are then accessed by 3 of my staff on a shared folder.
To check how high the security of my dbase is, i opened the folder where the BE lies on one of the user's workstation and tried to delete it. Can't believe IT WAS DELETED!!! Why??? It should have been addressed by "User-Level Security Wizard", right???
I'm using Windows XP, Office 2003.
Sheila
I am so stupid! I just deleted the whole code for a form!! I had two days of work in it! I was creating a new form similar in layout to the original and had copy-pasted. i then deleted all the code from one of them, and then the other one by mistake!
Does windows store this stuff temporarily anywhere? can someone please help!??
I will be infinitely grateful!
I enter records into MS Access and then when I close it and reopen it, every once in awhile records that I entered previously are deleted. I am new to Access so it may be a simple problem such as saving the database but it is extremely frusturating when I enter customers into a database and then reopen it to find out voila half the customers I entered are not there. If anyone can help me it would be really appreciated. Thank you.
View 1 Replies View RelatedScreen view of Database Diagram (http://64.122.37.190/images/diagram.jpg)
Screen view of problem view (http://64.122.37.190/images/viewshifts.jpg)
I am working with a Access Data Project and MSDE database server. In the image you can see the tables that I am working with. I have a table, tblShifts, that has all of the shifts with clock in and out times for all buildings. I am trying to downsize this list to include only buildings that the user is matched with in tblManagerBuildings by using SUSER_SNAME() to get there current username. Seems easy enough.
Only I can't get it to work. It does give you only shifts in the buildings that you are assigned to. But when you go to delete or insert wierd things happen. If I have the query set up as it is in the "Screen view of problem view" link I get an error "The field 'shiftnum' is read-only" when I try to insert or delete. So I tried another way. First I set up a view that gives you all of the buildings that you have access to.
View all of the user's buildings (http://64.122.37.190/images/viewMyBuildings.jpg)
Then I connect that to tblShifts and get all shifts in the user's buildings:
Shift table connected to user's buildings (http://64.122.37.190/images/viewShifts2.jpg)
If I output the BuildingNum column when you go to delete a record nothing happens. If I output the username column I get the "The field 'shiftnum' is read only" error. If I don't output any of the columns from viewMyBuildings then when I delete a row it Deletes the Building and the User from ALL of the tables. Including all of the shifts associated with the building. AWWW! I know that this is possible. My problem is probably with having a many - to - many relationship, but I have been working on the for a day and a half and I think I took care of the many to many relationship properly. If anyone has any input PLEASE HELP!
Hi everyone
I have a problem that I have deleted some records from a table in my database and now after one week I need these records again. Can someone tell me how to get them?
This has got me stumped.
We have a massive db and on one of the screens the users can scroll through the records and view information they can also add new records. When the users enter the new record and go back to it it has been successfully stored in the relevant table even on exitin the form via the exit button (DoCmd.Close). However from time to time when the user enters the new record and closes the for via the close form button the new entry is not stored in the table and seems to have been deleted or not appended to the table.
We have no idea why this is happening as it doesnt happen all the time just from time to time.
Can anyone help please or has anyone come across this before !
Thanks for any help !
Someone created a form and then deleted it. When we try to use the find button on other forms, it keeps looking for the deleted form. When I look in visual basic, I can still see the removed form listed, but it is not visible on the form page for me to delete. How do I get rid of this residue.
Thanks
Sandyk
Can someone please help me. I was in the code view of my database and accidentally deleted a few lines of code and now everything i do is coming up with the same error message
Module Not Found
For every form I try to open it does this and even my buttons to close form and to exit system do not work.
Has anybody had this problem before?
Would anybody mind taking a look at it if I sent a zipped version? my email and msn is nicholaseary@hotmail.com
Hi
I would like to prevent the first 24 rows in a table from being deleted by the user, after these 24 rows they can be deleted. Is there anyway of protecting them etc without putting them in a separate table?
Hi All,
This is my first post here and I imagine there will be many more as I have only just started out using Access to create a database at work and I am sure that I'm breaking many rules along the way.
Anyway, over the weekend, my boss tried to add some information (to the "Memo" field) in a form that I have created from a table, went to close the form and got a message saying something along the lines of "this record cannot be saved, if you close it, information will be deleted.
Now, in the Memo field, is the text "#Deleted" - when I try to overwrite this and come out of the record, it comes up with the message "record is deleted". If I put information in any other field in the record, there is no problem.
Also, in the table, if I try to sort by the Memo field, it comes up with same message, "record is deleted".
Does anyone know what I've done and how I can solve this?
With thanks in advance.
Ronnie
can anyone please help me out with suggestions of how to recover records that have been deleted accidentally. :eek: thanks.
View 1 Replies View RelatedHi all,
I have deleted certain content from a table. After it I have compressed and repaired the database but later I found out that I need those deleted data. But now they are gone. Is there any possibility to recover it? Are there any tools or something?
Thank you very much for your help.
I have a table with a blank record at the begining and populated records thereafter. I used the cmd button wizard to create a delete button for that table. Is there a way to prevent the blank record (record 1) from being deleted by the command button but still allow all other records to be deleted?
View 9 Replies View RelatedHi All,
Is there an easy way to show that a record has been deleted (besides "audit trail")?
for example:
if record_id 2 was deleted, the fields can show "deleted"
thx
Hi all,
I have deleted certain content from a table. After it I have compressed and repaired the database but later I found out that I need those deleted data. But now they are gone. Is there any possibility to recover it? Are there any tools or something?
Thank you very much for your help.
Hello, I've got a table that looks something like this:
deviceID | name | ...
1 | a
2 | b
3 | c
4 | d
6 | e
where deviceID is an autonumber. Clearly device 5 got deleted, but if I go to "add record" I end up adding record 7. There are still other records in the db which need to link to device5, and I have all the info needed to recreate them, how do I override the autonumber and create a record with a specific deviceID?
Thanks,
-Eric
I have a textbox on a Subform which is updated when a record is double clicked in another Subform. This works fine until i move the mouse over the updated subform. Then the updated entry is replaced with #Deleted. The data is still in the table that gives the subform its value.
Also another form running has the same subform and it and the updated value is shown perfectly in this one.
Anyone know why this may be happening?
how can i have a query of deleted enterees ?!
View 6 Replies View RelatedI have the following set up:A table in access for PurchaseOrders
-A table in access for ShipmentDetails, PK linked to PurchaseOrders OrderNumber
-A table in access for payments, an index linked to the PurchaseOrders OrderNumber
-An SQL database table of purchase order details from our existing system, linked to PurchaseOrders OrderNumber
Now, I create a new record in PurchaseOrders with OrderNumber="ABCD01". All good.I create a new record in ShipmentDetails with OrderRef= "ABCD01". Still good, creating a form and adding fields shows the data is linked correctly.
I now add the CreditorCode field from the linked SQL DB, it automatically shows like it should.I try to use the form to delete the "ABCD01" record from the PurchaseOrders table and it deletes the record FROM THE SQL DATABASE! It's basically acting like Enforce Referential Integrity is turned on with deletes. This backend DB is used by other programs. I don't ever want my app to modify it.
How to track deleted records? I have a database that users login to and it tracks which records they make changes to but I do not have a way to track a deleted record. I read online about doing like an archive of the record to a table that will hold the deleted record and that made the most sense to me.
View 3 Replies View RelatedI created a simple database with a single table and a form so I can track patients enrolled in a study. I added a few test records to make sure everything was working properly. Now I'm ready to use the database for real. Only trouble is, when I erased the test records I find that I can't add new ones.
View 1 Replies View RelatedI am using Access 2013 and I had a column that was accidentally deleted a few months ago. Is there anyway to restore a deleted column? If not, I have the majority of the data from that column saved in an excel spreadsheet with another column that is common to the access file and the excel file. Is there any way to take the data from excel and have it match up using the data from the common column?
View 4 Replies View RelatedBy: Tony Hine (mail@TonyHine.co.UK)
Tel: +44 1635 522233
My profile on ecademy (http://www.ecademy.com/user/tonyhine)
I had a problem importing just one table I kept getting the message “Record is deleted” and no records were imported.
First I thought it may be because there were quite a few columns in the table so I tried importing just one column, however I got the same message “Record is deleted“ .
I considered it could be because the database was originally in a Company office workgroup. I wondered if the “Work group security” was causing the problem. I read up on this and found that importing the objects directly into a new database was one of the recommended ways of circumventing this problem. This was what I was already doing! So what was wrong?
Next idea, I exported all of the records into an excel spreadsheet. This was successful! So I then re-imported the records from the spreadsheet back into a table in the database.
There were a couple of problems, in that all of the text fields were converted to 255 character length. Although annoying I thought I could handle this problem. I proceeded making a few changes to this database, then I noticed that one of the fields that had been imported was originally a “Memo field” it had been converted to a text field with 255 characters. As soon as I noticed, I checked to see if any data had been lost by comparing this field with the original data. I found a significant loss of data so back to the drawing board!
All of the other tables had imported correctly, only this one seemed to be giving problems, I had tackled the size problem it was not a big table by MS Access standards, but I felt it could be the size, In particular the number of fields could be causing this error. But just trying to import one field at a time hadn’t worked?
Then it dawned on me what if I tried to import one record at a time --- that worked! So I wrote the query with a between statement I tried 10, then a 100, then a thousand records it worked fine! However when I tried 5000 records the error re-occurred?
I realized that I probably had some corrupt data in the table, so I set about systematically extracting a limited number of records until I found the area where the corruption was.
This worked but returned “0” records --- Between 11001 And 12000
“Between 12001 And 13000” Got error message “Record is deleted”
I got to 12800 all ok
12900 caused error
Error is in a record between 12800 and 12900
I will continue to whittle it down!
OK to 12819
The corrupt record is: 12820
I had found the corrupt record! Now all I had to do was create two queries one each side of this corrupt record to extract the information.
On inspection of this corrupt record I discovered that the memo field contained the following: “#Deleted “ I am going to attempt to modify the memo field and see if it fixes the corruption of the database.
My attempt at modifying the corrupt record, in particular the memo field containing “#Deleted” caused the error message to re-occur. “Record is deleted”
I have made a copy of the actual record 12820 and pasted it into a spreadsheet to send to the customer so that it can be checked in the existing data on their system.
Fortunately there were no related records in other tables affected.
Hi
I have a muli-user database that's been creating the odd strange record for me
two records that have been created have all the fields data as
#ERROR or
#DELETED
no matter what I do with these records I can't get rid of them or find out where they came from.
Can any help me just delete these out of the table?
Would be extreemly helpful as they are now getting on my nerves :-)
Cheers Homer
Hi all,
one of the databases at my place has started acting really strange and was wondering if anyone knows what could possibly be wrong?
there's only one big tble holding about 7.5 k records with approx 10 fields
info that was entered yesterday has now been deleted (by access?) and when you scroll down or go down to the end records, all those records that were there yesterday now show either #error or #deleted and then an error popup appears saying "Not Valid Bookmark"
The UID doesn't appear to be working either, i.e it's not incrementing properly?
any ideas?
I have a peculiar problem.
The sequence of events is:
1. The user reports that on clearing (deleting) data in a memo field within a table an error (sometimes) occurs which results in all fields for that record containing the word #deleted. The table can no longer be opened for update via a form. (Prior to deleting the data in the memo field the user had been using copy/paste data from the memo field into other fields within the record)
2. When I open the table in datasheet view, there is a record filled with # signs usually at the beginning of the table. I delete that ( I believe that is all that is left of the original record - but there is no other identifying data).
3. The primary key (autonumber) of that table is reset i.e. it is no longer designated as the primary key. I recreate it in table design.
4. All relationships with that Primary key are deleted.
5. I recreate the relationships, run a compact and repair and all is well except that the original record is lost and has to be recreated as well.
All this because a user deleted some data in a memo field!
The DB is split with the BE on a Windows 2003 Server and the users running their FEs on a Lan. Only Access 2003 is used.
I cant replicate the problem on my development system.
Any ideas very welcome