Access 97 and VB.NET

[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

 

[[MVP] S.Clark]

Why can't you upsize or the data be upsized? What's preventing this
operation from occuring.

 

[Guest]

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