"¢Ù¢×¢Ü¢Õ¢Ò¢Ý¢Û" <s**@sda.com> wrote in message
news:eSvPZR9vFHA.1716@TK2MSFTNGP10.phx.gbl...
> I have a great problem of the database management of my project.
> the project have the following requirements:
> 1. have many database (.MDB files) with same data structure
> 2. search from all database
> 3. list the result/ data in one(preferable) table/grid
> 4. double click on the data and popup a screen for editing the selected
row
>
> which method that I can use? or Are the requirement possible to do??
> (assuming that all .mdb files in the same folder)
>
> Can anyone help me? and please exlain as easy as you can or in step by
step
> ^^
>
> thanks so much~~
>
>
> --
> http://www.letskick.net
>
>

"Veign" <NOSPAMinveign@veign.com> ¼¶¼g©ó¶l¥ó·s»D:OzGzEy9vFHA.2***@TK2MSFTNGP10.phx.gbl...
> Use ADO and sure it can be done.  Doesn't even matter if all databases
> reside in the same folder or not...
>
> --
> Chris Hanscom - Microsoft MVP (VB)
> Veign's Resource Center
> http://www.veign.com/vrc_main.asp
> Veign's Blog
> http://www.veign.com/blog
> --
>
>
> "¢Ù¢×¢Ü¢Õ¢Ò¢Ý¢Û" <s**@sda.com> wrote in message
> news:eSvPZR9vFHA.1716@TK2MSFTNGP10.phx.gbl...
>> I have a great problem of the database management of my project.
>> the project have the following requirements:
>> 1. have many database (.MDB files) with same data structure
>> 2. search from all database
>> 3. list the result/ data in one(preferable) table/grid
>> 4. double click on the data and popup a screen for editing the selected
> row
>>
>> which method that I can use? or Are the requirement possible to do??
>> (assuming that all .mdb files in the same folder)
>>
>> Can anyone help me? and please exlain as easy as you can or in step by
> step
>> ^^
>>
>> thanks so much~~
>>
>>
>> --
>> http://www.letskick.net
>>
>>
>
>

> > Use ADO and sure it can be done.  Doesn't even matter if all databases
> > reside in the same folder or not...
> >
> > --
> > Chris Hanscom - Microsoft MVP (VB)
> > Veign's Resource Center
> > http://www.veign.com/vrc_main.asp
> > Veign's Blog
> > http://www.veign.com/blog
> > --
> >
> >
> > "¢Ù¢×¢Ü¢Õ¢Ò¢Ý¢Û" <s**@sda.com> wrote in message
> > news:eSvPZR9vFHA.1716@TK2MSFTNGP10.phx.gbl...
> >> I have a great problem of the database management of my project.
> >> the project have the following requirements:
> >> 1. have many database (.MDB files) with same data structure
> >> 2. search from all database
> >> 3. list the result/ data in one(preferable) table/grid
> >> 4. double click on the data and popup a screen for editing the selected
> > row
> >>
> >> which method that I can use? or Are the requirement possible to do??
> >> (assuming that all .mdb files in the same folder)
> >>
> >> Can anyone help me? and please exlain as easy as you can or in step by
> > step
> >> ^^
> >>
> >> thanks so much~~
> >>
> >>
> >> --
> >> http://www.letskick.net
> >>
> >>
> >
> >
>
>

"Veign" <NOSPAMinveign@veign.com> ¼¶¼g©ó¶l¥ó·s»D:uHMq0Z%23vFHA.1***@TK2MSFTNGP10.phx.gbl...
> Start reading some of the information below
>
> Basic Intro:
> http://www.w3schools.com/ado/default.asp
>
> ADO Tutorial For Absolute Beginners
> http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=12050&lngWId=1
>
> ADO Tutorial:
> http://www.xtremevbtalk.com/showthread.php?t=66994
>
> ADO Reference Guide:
> http://www.devguru.com/technologies/ado/home.asp
>
> Migrating from DAO to ADO (good document for ADO code snippets):
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndao/html/daotoado.asp
>
> ADO Connection Strings (Carl Prothman):
> http://www.carlprothman.net/Default.aspx?tabid=81
>
> Connection Strings:
> http://www.connectionstrings.com
>
> --
> Chris Hanscom - Microsoft MVP (VB)
> Veign's Resource Center
> http://www.veign.com/vrc_main.asp
> Veign's Blog
> http://www.veign.com/blog
> --
>
>
> "¢Ù¢×¢Ü¢Õ¢Ò¢Ý¢Û" <ad***@letskick.net> wrote in message
> news:%23mm%23Z69vFHA.3864@TK2MSFTNGP12.phx.gbl...
>> can you explain in details? because I have no idea on that objects.
>>
>> --
>> http://www.letskick.net
>> "Veign" <NOSPAMinveign@veign.com>
> ¼¶¼g©ó¶l¥ó·s»D:OzGzEy9vFHA.2***@TK2MSFTNGP10.phx.gbl...
>> > Use ADO and sure it can be done.  Doesn't even matter if all databases
>> > reside in the same folder or not...
>> >
>> > --
>> > Chris Hanscom - Microsoft MVP (VB)
>> > Veign's Resource Center
>> > http://www.veign.com/vrc_main.asp
>> > Veign's Blog
>> > http://www.veign.com/blog
>> > --
>> >
>> >
>> > "¢Ù¢×¢Ü¢Õ¢Ò¢Ý¢Û" <s**@sda.com> wrote in message
>> > news:eSvPZR9vFHA.1716@TK2MSFTNGP10.phx.gbl...
>> >> I have a great problem of the database management of my project.
>> >> the project have the following requirements:
>> >> 1. have many database (.MDB files) with same data structure
>> >> 2. search from all database
>> >> 3. list the result/ data in one(preferable) table/grid
>> >> 4. double click on the data and popup a screen for editing the
>> >> selected
>> > row
>> >>
>> >> which method that I can use? or Are the requirement possible to do??
>> >> (assuming that all .mdb files in the same folder)
>> >>
>> >> Can anyone help me? and please exlain as easy as you can or in step by
>> > step
>> >> ^^
>> >>
>> >> thanks so much~~
>> >>
>> >>
>> >> --
>> >> http://www.letskick.net
>> >>
>> >>
>> >
>> >
>>
>>
>
>

"¢Ù¢×¢Ü¢Õ¢Ò¢Ý¢Û" <s**@sda.com> wrote in message
news:eSvPZR9vFHA.1716@TK2MSFTNGP10.phx.gbl...
> I have a great problem of the database management of my project.
> the project have the following requirements:
> 1. have many database (.MDB files) with same data structure
> 2. search from all database
> 3. list the result/ data in one(preferable) table/grid
> 4. double click on the data and popup a screen for editing the selected
row
>
> which method that I can use? or Are the requirement possible to do??
> (assuming that all .mdb files in the same folder)
>
> Can anyone help me? and please exlain as easy as you can or in step by
step
> ^^
>
> thanks so much~~
>
>
> --
> http://www.letskick.net
>
>

"Veign" <NOSPAMinveign@veign.com> ¼¶¼g©ó¶l¥ó·s»D:uzb16y9vFHA.3***@TK2MSFTNGP10.phx.gbl...
> From a post by Jeff Johnson:
>
> "You have posted this question individually to
> multiple groups. This is called Multiposting
> and it's BAD. Replies made in one group will
> not be visible in the other groups, which
> may cause multiple people to respond to your
> question with the same answer because they
> didn't know someone else had already done it.
> This is a waste of time.
>
> If you MUST post your message to multiple
> groups, post a single message and select all
> the groups (or type their names manually,
> separated by commas) in which you want it to
> be seen. This is called Crossposting and when
> used properly it is GOOD."
>
> --
> Chris Hanscom - Microsoft MVP (VB)
> Veign's Resource Center
> http://www.veign.com/vrc_main.asp
> Veign's Blog
> http://www.veign.com/blog
> --
>
>
> "¢Ù¢×¢Ü¢Õ¢Ò¢Ý¢Û" <s**@sda.com> wrote in message
> news:eSvPZR9vFHA.1716@TK2MSFTNGP10.phx.gbl...
>> I have a great problem of the database management of my project.
>> the project have the following requirements:
>> 1. have many database (.MDB files) with same data structure
>> 2. search from all database
>> 3. list the result/ data in one(preferable) table/grid
>> 4. double click on the data and popup a screen for editing the selected
> row
>>
>> which method that I can use? or Are the requirement possible to do??
>> (assuming that all .mdb files in the same folder)
>>
>> Can anyone help me? and please exlain as easy as you can or in step by
> step
>> ^^
>>
>> thanks so much~~
>>
>>
>> --
>> http://www.letskick.net
>>
>>
>
>