Jet database and Vista

  • Thread starter Thread starter jeffc
  • Start date Start date
J

jeffc

It's my understanding that MSoft will no longer support Jet on Vista. This
is kind of hard to understand since there is such a large install base of
Access users. Anyone know the scoop?
 
It's my understanding that MSoft will no longer support Jet on Vista.
This is kind of hard to understand since there is such a large install
base of Access users. Anyone know the scoop?
Click to expand...

I'm running Office 97 Pro here with Access 97 and I can read and write
databases, I can also read and write from VS2005 using:

string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=";
if (UseStartUpPath)
strConnection += Path.Combine(Application.StartupPath, strDBName);
else
strConnection += Path.Combine(@"E:\_Data\Database", strDBName);
strConnection += ";";

so I think your fears are groundless.
 
Jeff Gaines said:
I'm running Office 97 Pro here with Access 97 and I can read and write
databases
Click to expand...

First, I assume you're running Vista right now. I misunderstood this
comment from a Microsoft page: "In an effort to provide customers with more
secure products, Microsoft Windows Server "Longhorn" and Microsoft Windows
Vista will only support SQL Server 2005 Service Pack 2 (SP2) or later when
it becomes available"

In addition to that, I heard a "rumor" that Jet was no longer supported
which led to my confusion. The comment above actually refers to SQL
products (for example, use SQL Express rather than MSDE - not related to
Jet.) The "rumor" was actually, probably, simply the fact that Jet is
deprecated technology, which is not to say it won't work on Vista.
 
First, I assume you're running Vista right now. I misunderstood this
comment from a Microsoft page: "In an effort to provide customers with
more secure products, Microsoft Windows Server "Longhorn" and Microsoft
Windows Vista will only support SQL Server 2005 Service Pack 2 (SP2) or
later when it becomes available"

In addition to that, I heard a "rumor" that Jet was no longer supported
which led to my confusion. The comment above actually refers to SQL
products (for example, use SQL Express rather than MSDE - not related to
Jet.) The "rumor" was actually, probably, simply the fact that Jet is
deprecated technology, which is not to say it won't work on Vista.
Click to expand...

Yes, I'm running Vista RTM (Right This Moment).

I can see the confusion - the app that streams my multimedia had some
issues because of an issue with its database, I'm not sure if it's MSDE or
some desktop version of SQL server. It's early days, it'll get fixed.
 
Back
Top