Access 97 and VB.NET

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have two cases:
1) Access97 DB - FrontEnd VB6 application. (Live) - table structure is
almost same
2) SQL*Server DB - VB.NET application (Not Live) - table structure is almost
same

We cannot upsize access it to sql*server, because it in the Live env..

Is there anyway I can connect from VB.NET and VB6 to Access97 DB using same
stored proc developed for SQL*Server.. so, that after some proper testing..
we can switch off the access database...

Many thanks
Uma
 
Why can't you upsize or the data be upsized? What's preventing this
operation from occuring.
 
Reason:
1) The access 97 database got many queries self-made by users in different
branches.. and people are used to it.....
2) Got many front-end application developed using VB6 which connects access
97 database. Upsizing means modifing VB6 connection string is it? If yes, it
is not easy task... because many many front-end application needs to to
changed.

Thanks Uma
 
Back
Top