Upgrade to Access 95 - Part 2

[Joe Jackson]

Ok, now I've got them convinced that we need to upgrade. Here is the next
question they have asked me to research (I'm a SQL DBA, haven't used Access
since 97).

They only use Access as a repository of data, they get the data through a VB
program. What if any problems will they have if the databases are upgraded
to 2000 or 2003? I would imagine that things would go fairly seamlessly but
again, I haven't had much experience with Access in quite a while.

They've kept their drivers up to date, but they are worried that they would
need new drivers and new connection strings (that would mean...can you
believe it....they would actually have to go into the code and make a
change....can't have that can we).

Again, thanks for you input.

 

[Arvin Meyer]

The only possible problem that I can see is strong typing. Data types which
worked in code in earlier versions need to be explicit starting with Access
2000. Also, while this probably won't matter, beginning with Access 2000,
all textual data is stored in Unicode text rather than ASCII.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access