Access to VB

  • Thread starter Thread starter Matt Smith
  • Start date Start date
M

Matt Smith

I have an Access 97 database application that I'd like to
distribute to a couple of folks who don't have Access. I
have VB 6 pro, but I'm a newbie at that program.

Is there simple way to essentially import my Access
aplication into VB and distribute it?

Thanks in advance,

Matt
 
The short answer is no. What you can do, if you can get your hands on a
copy of the 97 developers edition, is distribute a runtime-only version of
the database. The users will be able to _use_ it, but not _change_ it, so
for example, they can print reports but not design them.

I'm not sure about availability of the 97 DE. You might check the MS web
site, or post back here on a separate thread--somebody will know.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
Unfortunately, Microsoft no longer sells previous versions of Access.

One possibility is to check out sites that specialize in old software
products, such as http://www.emsps.com/oldtools/ or
http://recycledsoftware.com/

Another is to look at someplace like eBay to see whether anyone's trying to
see their old versions (Note, though, that products purchased this way
aren't always legal...)
 
Thanks for the help.

Just tinkering with VB, I see it's easy to link up with a
database, but I guess I'm trying to avoid rebuilding all
my forms, queries and reports in VB.
I know this has turned into a VB question, but is there a
simpler way to do this, perhaps by creating a VB app that
links with Access?

Thanks again.

Matt
 
Matt Smith said:
I have an Access 97 database application that I'd like to
distribute to a couple of folks who don't have Access. I
have VB 6 pro, but I'm a newbie at that program.

Is there simple way to essentially import my Access
aplication into VB and distribute it?
Click to expand...

Simple, likely not.

Convert Access to Visual Basic, Delphi, Java, ASP or ASP.NET
http://www.granite.ab.ca/access/accesstovb.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
There are some people around who sell "translation" tools that purport to
transfer your Access forms into VB, but I don't have any experience of them,
nor have I heard anything (good or bad) here. The architectures are just
too different.

I'd try one of the places Doug recommended, for an old copy of the DE.

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
Back
Top