converting access db to mysql

[Bolt Upright]

Re: converting access db to mysql

Check this link

http://www.convert-in.com/acc2sql.htm

Nerver used it but it looks interesting.

Cheers



"chicha" <mario@blindsig ht.org> wrote in message
news:chd16b$jso $1@bagan.srce.h r...[color=blue]
> Thanks guys for your replies!
>
> I see now I phrased my post in a completely wrong way.
>
> First of all, what I'm trying to do here is to get some guidance and
> friendly advice to get me started. I HAVE to do this project, I was told
> to. For any of you who read somewhere between my lines "please could
> somebody do this for free instead of me??", I just must stress that that
> was NOT my idea for this post. There are easier and more reliable ways to
> cheat at faculty then using newsgroups...
>
> I'm new with db's but not with PC's. What I should have written is that I
> got the database made in Access 2000 (.MDB) which doesn't work with Access
> 2003. I know this is wrong, and that it should work, but it doesn't. I
> spoke with the author/professor assistant who obviously did it using
> "Databases for dummies" book and he said he's sure it works but has
> bugs(!!!). He doesn't know what bugs though :). That's why he gave me the
> whole thing to put it in mysql. When I tried it in 2003, sure as hell, it
> didn't work, bug or no bug. It opened and loaded, but didn't read
> relations nor data. It works in A2000 because the whole "office of
> construction in mech. eng." at my faculty uses it. I'm not gonna tell that
> guy he did it all wrong, because he knows it. He knows I know it too.
> Saying it loud would mean my academical suicide. I'll rather use Access
> 2000 and fix it there.
>
> I mentioned it in the post because I thought someone could offer an
> advice. My apologies that I haven't explained the situation more
> thoroughly, I thought it was uneccessary. It would save me from you guys
> thinking I'm complete idiot or lousy cheat.
>
> Thanks to all of you guys who provided insightfull info and links, I
> appreciate it. I'll check it out, and see what can be done.
>
> Cheers,
>
> Mario
>
>
>
> rkc wrote:
>[color=green]
>> "chicha" <mario@blindsig ht.org> wrote in message
>> news:chcfuv$n00 $1@bagan.srce.h r...
>>[color=darkred]
>>>Hey people,
>>>
>>>I have to convert MS Access 2000 database into mysql database, the whole
>>>thing being part of this project I'm doing for one of my faculty
>>>classes. My professor somehow presumed I knew db's and gave me long list
>>>of things to do with that particular database, first thing being that
>>>particular conversion. Truth is that I don't know a first thing about
>>>db's, let alone using mysql... I downloaded mysql form www.mysql.com and
>>> still searching for MS Access 2000 (it doesn't work with 2003 I have,
>>>or I don't know how to make it work).
>>>
>>>Any kind of help will be welcomed and highly appreciated!!![/color]
>>
>>
>> If your a quick study, Google can be your best friend.
>>
>> If you have approx. $100 USD and a 2 week window, go to rentacoder.com.
>> Someone from Pakistan will do your job for you for that price with glee.
>>
>> If neither of those works for you, you're probably F%#*ked.
>>
>>
>>[/color][/color]

[chicha]

Re: converting access db to mysql

Thanks, thanks, thanks!!!

I spent this few days doing my research and thanks to your kind answers
and ideas I finally have idea what's going on.

Database I got to work on, now finally loaded up in Access 2003 but
cannot be worked with since it has password protection. I got the
username and password together with the db form that guy who made it,
but program just doesn't reckognize neither of those... it doesn't even
prompt me to use them, it just says I don't have permission to open/run
any of components. Although he made username for me, now it's nowhere
tzo be found, only Admin.

Obviously there's something wrong with db itself. Now I applied to get
faculty's copy of Access 2000 with student license (that's gonna take
some time...), then I'll see what's going on. When I make it work in
both 2000 & 2003 Access I'll start thinking about conversion.

I'll send posts about my progress.

Thanks again for your replies!!

mario



Bolt Upright wrote:[color=blue]
> Check this link
>
> http://www.convert-in.com/acc2sql.htm
>
> Nerver used it but it looks interesting.
>
> Cheers
>
>
>
> "chicha" <mario@blindsig ht.org> wrote in message
> news:chd16b$jso $1@bagan.srce.h r...
>[color=green]
>>Thanks guys for your replies!
>>
>>I see now I phrased my post in a completely wrong way.
>>
>>First of all, what I'm trying to do here is to get some guidance and
>>friendly advice to get me started. I HAVE to do this project, I was told
>>to. For any of you who read somewhere between my lines "please could
>>somebody do this for free instead of me??", I just must stress that that
>>was NOT my idea for this post. There are easier and more reliable ways to
>>cheat at faculty then using newsgroups...
>>
>>I'm new with db's but not with PC's. What I should have written is that I
>>got the database made in Access 2000 (.MDB) which doesn't work with Access
>>2003. I know this is wrong, and that it should work, but it doesn't. I
>>spoke with the author/professor assistant who obviously did it using
>>"Databases for dummies" book and he said he's sure it works but has
>>bugs(!!!). He doesn't know what bugs though :). That's why he gave me the
>>whole thing to put it in mysql. When I tried it in 2003, sure as hell, it
>>didn't work, bug or no bug. It opened and loaded, but didn't read
>>relations nor data. It works in A2000 because the whole "office of
>>constructio n in mech. eng." at my faculty uses it. I'm not gonna tell that
>>guy he did it all wrong, because he knows it. He knows I know it too.
>>Saying it loud would mean my academical suicide. I'll rather use Access
>>2000 and fix it there.
>>
>>I mentioned it in the post because I thought someone could offer an
>>advice. My apologies that I haven't explained the situation more
>>thoroughly, I thought it was uneccessary. It would save me from you guys
>>thinking I'm complete idiot or lousy cheat.
>>
>>Thanks to all of you guys who provided insightfull info and links, I
>>appreciate it. I'll check it out, and see what can be done.
>>
>>Cheers,
>>
>>Mario
>>
>>
>>
>>rkc wrote:
>>
>>[color=darkred]
>>>"chicha" <mario@blindsig ht.org> wrote in message
>>>news:chcfuv$ n00$1@bagan.src e.hr...
>>>
>>>
>>>>Hey people,
>>>>
>>>>I have to convert MS Access 2000 database into mysql database, the whole
>>>>thing being part of this project I'm doing for one of my faculty
>>>>classes. My professor somehow presumed I knew db's and gave me long list
>>>>of things to do with that particular database, first thing being that
>>>>particula r conversion. Truth is that I don't know a first thing about
>>>>db's, let alone using mysql... I downloaded mysql form www.mysql.com and
>>>> still searching for MS Access 2000 (it doesn't work with 2003 I have,
>>>>or I don't know how to make it work).
>>>>
>>>>Any kind of help will be welcomed and highly appreciated!!!
>>>
>>>
>>>If your a quick study, Google can be your best friend.
>>>
>>>If you have approx. $100 USD and a 2 week window, go to rentacoder.com.
>>>Someone from Pakistan will do your job for you for that price with glee.
>>>
>>>If neither of those works for you, you're probably F%#*ked.
>>>
>>>
>>>[/color][/color]
>
>[/color]

[Larry Linson]

Re: converting access db to mysql

Chicha,

You have to have the MDW file with which it was secured before the userid
and password will do you any good. I'll say again, using Access 2000 isn't
going to change that. Along with the userid and password, find and join the
MDW, and you'll be able to open it.

You are _fixated_ on Access 2000 as the solution, but you still haven't
understood the problem.

Larry Linson
Microsoft Access MVP


"chicha" <mario@blindsig ht.org> wrote in message
news:chg6ns$hrj $1@bagan.srce.h r...[color=blue]
> Thanks, thanks, thanks!!!
>
> I spent this few days doing my research and thanks to your kind answers
> and ideas I finally have idea what's going on.
>
> Database I got to work on, now finally loaded up in Access 2003 but
> cannot be worked with since it has password protection. I got the
> username and password together with the db form that guy who made it,
> but program just doesn't reckognize neither of those... it doesn't even
> prompt me to use them, it just says I don't have permission to open/run
> any of components. Although he made username for me, now it's nowhere
> tzo be found, only Admin.
>
> Obviously there's something wrong with db itself. Now I applied to get
> faculty's copy of Access 2000 with student license (that's gonna take
> some time...), then I'll see what's going on. When I make it work in
> both 2000 & 2003 Access I'll start thinking about conversion.
>
> I'll send posts about my progress.
>
> Thanks again for your replies!!
>
> mario
>
>
>
> Bolt Upright wrote:[color=green]
> > Check this link
> >
> > http://www.convert-in.com/acc2sql.htm
> >
> > Nerver used it but it looks interesting.
> >
> > Cheers
> >
> >
> >
> > "chicha" <mario@blindsig ht.org> wrote in message
> > news:chd16b$jso $1@bagan.srce.h r...
> >[color=darkred]
> >>Thanks guys for your replies!
> >>
> >>I see now I phrased my post in a completely wrong way.
> >>
> >>First of all, what I'm trying to do here is to get some guidance and
> >>friendly advice to get me started. I HAVE to do this project, I was told
> >>to. For any of you who read somewhere between my lines "please could
> >>somebody do this for free instead of me??", I just must stress that that
> >>was NOT my idea for this post. There are easier and more reliable ways[/color][/color][/color]
to[color=blue][color=green][color=darkred]
> >>cheat at faculty then using newsgroups...
> >>
> >>I'm new with db's but not with PC's. What I should have written is that[/color][/color][/color]
I[color=blue][color=green][color=darkred]
> >>got the database made in Access 2000 (.MDB) which doesn't work with[/color][/color][/color]
Access[color=blue][color=green][color=darkred]
> >>2003. I know this is wrong, and that it should work, but it doesn't. I
> >>spoke with the author/professor assistant who obviously did it using
> >>"Databases for dummies" book and he said he's sure it works but has
> >>bugs(!!!). He doesn't know what bugs though :). That's why he gave me[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> >>whole thing to put it in mysql. When I tried it in 2003, sure as hell,[/color][/color][/color]
it[color=blue][color=green][color=darkred]
> >>didn't work, bug or no bug. It opened and loaded, but didn't read
> >>relations nor data. It works in A2000 because the whole "office of
> >>constructio n in mech. eng." at my faculty uses it. I'm not gonna tell[/color][/color][/color]
that[color=blue][color=green][color=darkred]
> >>guy he did it all wrong, because he knows it. He knows I know it too.
> >>Saying it loud would mean my academical suicide. I'll rather use Access
> >>2000 and fix it there.
> >>
> >>I mentioned it in the post because I thought someone could offer an
> >>advice. My apologies that I haven't explained the situation more
> >>thoroughly, I thought it was uneccessary. It would save me from you guys
> >>thinking I'm complete idiot or lousy cheat.
> >>
> >>Thanks to all of you guys who provided insightfull info and links, I
> >>appreciate it. I'll check it out, and see what can be done.
> >>
> >>Cheers,
> >>
> >>Mario
> >>
> >>
> >>
> >>rkc wrote:
> >>
> >>
> >>>"chicha" <mario@blindsig ht.org> wrote in message
> >>>news:chcfuv$ n00$1@bagan.src e.hr...
> >>>
> >>>
> >>>>Hey people,
> >>>>
> >>>>I have to convert MS Access 2000 database into mysql database, the[/color][/color][/color]
whole[color=blue][color=green][color=darkred]
> >>>>thing being part of this project I'm doing for one of my faculty
> >>>>classes. My professor somehow presumed I knew db's and gave me long[/color][/color][/color]
list[color=blue][color=green][color=darkred]
> >>>>of things to do with that particular database, first thing being that
> >>>>particula r conversion. Truth is that I don't know a first thing about
> >>>>db's, let alone using mysql... I downloaded mysql form www.mysql.com[/color][/color][/color]
and[color=blue][color=green][color=darkred]
> >>>> still searching for MS Access 2000 (it doesn't work with 2003 I have,
> >>>>or I don't know how to make it work).
> >>>>
> >>>>Any kind of help will be welcomed and highly appreciated!!!
> >>>
> >>>
> >>>If your a quick study, Google can be your best friend.
> >>>
> >>>If you have approx. $100 USD and a 2 week window, go to rentacoder.com.
> >>>Someone from Pakistan will do your job for you for that price with[/color][/color][/color]
glee.[color=blue][color=green][color=darkred]
> >>>
> >>>If neither of those works for you, you're probably F%#*ked.
> >>>
> >>>
> >>>[/color]
> >
> >[/color][/color]