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]

Re: Removing "marks&quo t; from database

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]

Re: Removing "marks&quo t; from database

Embrion wrote:
[color=blue]
> 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.[/color]
[color=blue]
> Is there any way to clean them ?[/color]

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]

Re: Removing &quot;marks&quo t; from database

Uzytkownik "Red" <douglas.dion@g mail.com> napisal w wiadomosci
news:1137005810 .400840.252610@ f14g2000cwb.goo glegroups.com.. .
[color=blue]
> 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.[/color]
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"
[color=blue]
> 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.[/color]
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]

Re: Removing &quot;marks&quo t; from database

In message <dq3jn9$de8$1@i news.gazeta.pl> , Embrion
<embrion44#WONS PAM#@wp.pl> writes[color=blue]
>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.[/color]

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]

Re: Removing &quot;marks&quo t; from database

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]

Re: Removing &quot;marks&quo t; from database

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" <embrion44#WONS PAM#@wp.pl> wrote in message
news:dq3jn9$de8 $1@inews.gazeta .pl...[color=blue]
> 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
>
>
>[/color]

[pietlinden@hotmail.com]

Re: Removing &quot;marks&quo t; from database


Stephen Lebans wrote:[color=blue]
> Create a new blank MDB. Import everything from your "cheater" MDB into the
> new blank MDB. This will cleanup the garbage you are seeing.[/color]

Weren't you supposed to wait until AFTER the homework was due to tell
him that? <g>

[Randy Harris]

Re: Removing &quot;marks&quo t; from database


<pietlinden@hot mail.com> wrote in message
news:1137025089 .385205.108290@ f14g2000cwb.goo glegroups.com.. .[color=blue]
>
> Stephen Lebans wrote:[color=green]
> > Create a new blank MDB. Import everything from your "cheater" MDB into[/color][/color]
the[color=blue][color=green]
> > new blank MDB. This will cleanup the garbage you are seeing.[/color]
>
> Weren't you supposed to wait until AFTER the homework was due to tell
> him that? <g>
>[/color]

Ya, I think Stephen kind of let the cat out of the bag.

[Stephen Lebans]

Re: Removing &quot;marks&quo t; from database

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.


<pietlinden@hot mail.com> wrote in message
news:1137025089 .385205.108290@ f14g2000cwb.goo glegroups.com.. .[color=blue]
>
> Stephen Lebans wrote:[color=green]
>> Create a new blank MDB. Import everything from your "cheater" MDB into
>> the
>> new blank MDB. This will cleanup the garbage you are seeing.[/color]
>
> Weren't you supposed to wait until AFTER the homework was due to tell
> him that? <g>
>[/color]

[Terry Kreft]

Re: Removing &quot;marks&quo t; from database

If you've just quit then the easiest target is yourself <g>.

--

Terry Kreft


"Stephen Lebans" <ForEmailGotoMy .WebSite.-WWWdotlebansdot ...@linvalid.co m>
wrote in message news:utjxf.1538 65$Ph4.4692654@ ursa-nb00s0.nbnet.nb .ca...[color=blue]
> I quit smoking several days ago. I am still at the point where I will try[/color]
to[color=blue]
> 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.[/color]
<SNIP>

[Stephen Lebans]

Re: Removing &quot;marks&quo t; from database

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" <terry.kreft@mp s.co.uk> wrote in message
news:xc2cnYtToo 4iy1veSa8jmw@ka roo.co.uk...[color=blue]
> If you've just quit then the easiest target is yourself <g>.
>
> --
>
> Terry Kreft
>
>
> "Stephen Lebans" <ForEmailGotoMy .WebSite.-WWWdotlebansdot ...@linvalid.co m>
> wrote in message news:utjxf.1538 65$Ph4.4692654@ ursa-nb00s0.nbnet.nb .ca...[color=green]
>> I quit smoking several days ago. I am still at the point where I will try[/color]
> to[color=green]
>> 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.[/color]
> <SNIP>
>
>[/color]