 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / January 2006Removing "marks" from database
Hello I've got project in my school which is Access database. My teacher said that if she notice any signs of using someone's else project, then she will fail that person. I've used some parts of my friend's database and now when I open my mdb in notepad, I can see names of my friend's labels, fields etc. names. It's strange because I've deleted all that fields via Access in my database. Is there any way to clean them ? I've already compacted and repaired my database. Greets, Emb > Hello > > I've got project in my school which is Access database. > My teacher said that if she notice any signs of using someone's else > project, then she will fail that person. > Is there any way to clean them ? Yes, do the work your teacher told you to do instead of copying part of it from your friend.  SignatureTim http://www.ucs.mun.ca/~tmarshal/ ^o< /#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake /^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me lmao, the "owner" of the db is set when a table/form/query/module/macro is set when the item is made... There is an easy way to fix it, but, that would be cheating, now wouldn't it? I would suggest this (This would be the HARD way): Make a NEW database, look at his work, and go through each object, and replicate it yourself. I know you wanna go the easy route, but, this will teach you more about how Access works. Trust me that it may seem stupid, but VBA is a great way to learn the basics of object orientated programming. ~Red > I would suggest this (This would be the HARD way): > Make a NEW database, > look at his work, and go through each object, and replicate it > yourself. This is the way I did but one or two times I copied my friend's query to my db to test why my version doesn't work and deleted it after checking but it seems Access still remember it "marks" > I know you wanna go the easy route, but, this will teach you more about > how Access works. Trust me that it may seem stupid, but VBA is a great > way to learn the basics of object orientated programming. I code C++ so I know something about object oriented programming :) Like I said before, I was looking at my friend's project and adapting it in mine and I must admit I've learned a lot of VBA ;) Could You give me this easy way of fixing that ? :) SignatureGreets, Emb You could compress the database after removing the offending objects, this should remove traces of his stuff. And, if your teacher asks, you can always tell him/her that you were trying to learn from your friend, so you imported his work, and was figuring out how it worked. I am sure, however, your teacher will not use a text editor to check for tracings of other peoples work. ~Red >Hello > [quoted text clipped - 6 lines] >Is there any way to clean them ? >I've already compacted and repaired my database. The usual way to recover from this sort of problem is to restore the database from a backup taken before you made those changes. You might be one of the few people who learns this before they start their first job. Learning that lesson is worth more than a few marks. SignatureBernard Peek London, UK. DBA, Manager, Trainer & Author. Create a new blank MDB. Import everything from your "cheater" MDB into the new blank MDB. This will cleanup the garbage you are seeing. SignatureHTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. > Hello > [quoted text clipped - 10 lines] > Greets, > Emb > Create a new blank MDB. Import everything from your "cheater" MDB into the > new blank MDB. This will cleanup the garbage you are seeing. Weren't you supposed to wait until AFTER the homework was due to tell him that? <g> > > Create a new blank MDB. Import everything from your "cheater" MDB into the > > new blank MDB. This will cleanup the garbage you are seeing. > > Weren't you supposed to wait until AFTER the homework was due to tell > him that? <g> Ya, I think Stephen kind of let the cat out of the bag. I quit smoking several days ago. I am still at the point where I will try to piss anyone off that I can. ;-) SignatureHTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. >> Create a new blank MDB. Import everything from your "cheater" MDB into >> the >> new blank MDB. This will cleanup the garbage you are seeing. > > Weren't you supposed to wait until AFTER the homework was due to tell > him that? <g> If you've just quit then the easiest target is yourself <g>. SignatureTerry Kreft > I quit smoking several days ago. I am still at the point where I will try to > piss anyone off that I can. > ;-) <SNIP> Always has been and always will be! :-) SignatureStephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. > If you've just quit then the easiest target is yourself <g>. > [quoted text clipped - 4 lines] >> > <SNIP> |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.