Which version?

[lgvelez]

I am working as a db admin for some Access 97 databases. My company is performing layoffs like mad, and I want to invest in an Access Developer Edition before my income gets greatly diminished. How is Office XP Developer Edition? It might be difficult to find an Office 2000 Edition now, but is it worth a try? Generally, what version of Access is being used mostly. The company I work for has a problem coming into the 21st century.

I will appreciate your advice. Laura Velez, MCP
lauravelez@home.com

 

[Terpsfan]

Most businesses are usually 1-2 versions behind what is currently out on the market. I'd suggest you master Access 97 and Access 2000. Businesses are going to be using both for probably another few years.

 

[lgvelez]

Where would I be able to get an Office 2K Developer Edition anywhere? Laura Velez, MCP
lauravelez@home.com

 

[JamesMeadlock]

You can buy it lots've places online; just spend a little time searching.

Access 97 is much more stable than 2k, and is what some serious access developers still stick with.

Access2k (Which I bought the developer edition for) offers some pretty cool new features, the mose useful imo are the .adp projects which let you easily write front-ends for and create SQL Server or MSDE (The free 'baby SQL' that comes with the developer edition) databases.

I don't know which would be the better to buy...

 

[lgvelez]

I really appreciate everyone's opinion. Thank you very much! What is the general concensus regarding Office XP? Laura Velez, MCP
lauravelez@home.com

 

[jgoodman00]

We are in the process of switching to it (for simplicity of connecting to a SQL Server db). I am really impressed with it, & it enables you to create both views & stored procedures in an almost identical way to creating queries in access. It is therefore very useful, & eliminates the need for writing your own SQL for simple queries....

James Goodman
j.goodman00@btinternet.com

 

[jgoodman00]

Something I forgot to mention is that you can get Office XP Professional on a 30day trial....You could always get a copy of this & then decide if XP is worth the extra money over 2000.... James Goodman
j.goodman00@btinternet.com

 

[lgvelez]

jgoodman00, are you referring to Office XP when you say you are switching? How is its general stability? MS sent me a 30-day trial of the Office XP Developer, and I plan on trying it, but it will be in a closed environment. I was curious about the XP overall performance. What you are saying about its relation with SQL Server is exciting. By the way, on eBay, new packages of Office 2000 DK are the same price as the XP DK. Laura Velez, MCP
lauravelez@home.com