Removing "marks" from database

[Embrion]

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

[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

[Tim Marshall]

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

[Embrion]

Uzytkownik "Red" <do**********@g mail.com> napisal w wiadomosci
news:11******** **************@ f14g2000cwb.goo glegroups.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

[Bernard Peek]

In message <dq**********@i news.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.

[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

[Stephen Lebans]

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

[pietlinden]

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>

[Randy Harris]

<pi********@hot mail.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.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.

[Stephen Lebans]

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********@hot mail.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.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>