473,324 Members | 2,214 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Removing "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

Jan 11 '06 #1
11 2012
Red
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

Jan 11 '06 #2
Embrion wrote:
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.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Jan 11 '06 #3
Uzytkownik "Red" <do**********@gmail.com> napisal w wiadomosci
news:11**********************@f14g2000cwb.googlegr oups.com...
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 ? :)

--
Greets,
Emb
Jan 11 '06 #4
In message <dq**********@inews.gazeta.pl>, Embrion
<em****************@wp.pl> writes
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.


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.

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.

Jan 11 '06 #5
Red
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

Jan 11 '06 #6
Create a new blank MDB. Import everything from your "cheater" MDB into the
new blank MDB. This will cleanup the garbage you are seeing.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Embrion" <em****************@wp.pl> wrote in message
news:dq**********@inews.gazeta.pl...
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

Jan 11 '06 #7

Stephen Lebans wrote:
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>

Jan 12 '06 #8

<pi********@hotmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Stephen Lebans wrote:
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.
Jan 12 '06 #9
I quit smoking several days ago. I am still at the point where I will try to
piss anyone off that I can.
;-)

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
<pi********@hotmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Stephen Lebans wrote:
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>

Jan 12 '06 #10
If you've just quit then the easiest target is yourself <g>.

--

Terry Kreft
"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com>
wrote in message news:ut**********************@ursa-nb00s0.nbnet.nb.ca...
I quit smoking several days ago. I am still at the point where I will try to piss anyone off that I can.
;-)

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

<SNIP>
Jan 12 '06 #11
Always has been and always will be!
:-)
--
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Terry Kreft" <te*********@mps.co.uk> wrote in message
news:xc********************@karoo.co.uk...
If you've just quit then the easiest target is yourself <g>.

--

Terry Kreft
"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com>
wrote in message news:ut**********************@ursa-nb00s0.nbnet.nb.ca...
I quit smoking several days ago. I am still at the point where I will try

to
piss anyone off that I can.
;-)

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

<SNIP>

Jan 12 '06 #12

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: Fred | last post by:
There is a setting in INIT.ORA that has the unintended side-effect of making sure the ALTER SYSTEM KILL SESSION command has immediate affect. Without this setting, I've seen some instances where...
1
by: David Furey | last post by:
Hi I have an XML documnet and a XSLT document as shown below THe XSLT document brings back a filtered docmument that has the VendorName that starts with a particular sub-string This works as...
2
by: DraguVaso | last post by:
Hi, I have a simple question regardign the syntax: do I have to need double quotation marks or single qoutation marks in my XML? For exemple:µ <?xml version="1.0" or <?xml version='1.0'
4
by: Greg | last post by:
I keep getting an error when I have a tick mark in a text value that I am searching for in my XPath Query. Example: <Authors> <Author LastName="O'Donnel"> <Author LastName="Smith">...
5
by: Matt | last post by:
I will be grateful if someone explians this part colfree = FALSE; upfree = FALSE; downfree = FALSE; of the code below. I don't understand how this marks the downward and upward diagonals....
3
by: msnews.microsoft.com | last post by:
Hello All, In the "Find Dialog" (Ctrl-F) of the IDE there is an option called "Mark All". When I click "Mark All", this marks the occurences of my search text. How will I clear this mark? ...
4
by: Terry | last post by:
I have a form that my wife uses to update her tennis racket website. I modified it to allow data entry, modify, and delete. If you enter an id number you get the matching record if there is one. ...
31
by: The Bicycling Guitarist | last post by:
Hi. For many years I have been using &quot; for double quotation marks in the HTML code, but the opening and closing quotation marks render the same in my browser. I'm considering going through and...
6
by: newholborn | last post by:
Hi everyone. I have some questions, which should be rather easy to reply, but as I am working on PHP, JavaScript, XML, CSS, Photoshop and other stuff at the same time, my head, which is about to...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.