I have an Access 97 database I would like to distribute, and
provide a compiled program for those who don't have Access

I do have the Access 97 developer tools CD and runtime, but
the install that creates is REALLY large (essentially, from
what I know, the entire Access 97 application with all the
development interface removed or "locked out")

I am thinking about getting VB Pro v5 to create the user
interface (fairly simple... a half dozen data entry screens
and 2 reports based on screen selections and queries) but
wonder how big an EXE I should expect? (I know the VB5
runtime is also needed, but that is only about 1 Meg)

Since I don't know Visual Basic, I would also like to know
the name(s) of good book(s) which explain designing the user
interface and working with Access files

Thanks for any and all help and suggestions

John Thomas Smith
http://www.direct2usales.com
http://www.pacifier.com/~jtsmith

I don't know the size of the VB executable, but don't forget that you will
have to include the Jet database engine, and _don't underestimate_ the time
and effort to re-write. There are some (not inexpensive) 3rd party
conversion tools, but those who use them tell us that they are "only the
start". The VB UI _appears_ similar to Access, but there are many
differences -- a big, unobvious one being that there are no data events such
as Before Update, After Update, etc., that we use all the time. VB has no
"bound forms" and its combination of "data control" and "bound controls" do
not work nearly so smoothly as Access bound forms and controls.

For an overview of frontending a database with Access or VB, look in the
downloads section of http://appdevissues.tripod.com.

Larry Linson
Microsoft Access MVP


"John Thomas Smith" <jtsmith@pacifier.com> wrote in message
news:ffqe21tv1e6eln7ir1r2dgj51f28bf31dc@4ax.com...[color=blue]
> I have an Access 97 database I would like to distribute, and
> provide a compiled program for those who don't have Access
>
> I do have the Access 97 developer tools CD and runtime, but
> the install that creates is REALLY large (essentially, from
> what I know, the entire Access 97 application with all the
> development interface removed or "locked out")
>
> I am thinking about getting VB Pro v5 to create the user
> interface (fairly simple... a half dozen data entry screens
> and 2 reports based on screen selections and queries) but
> wonder how big an EXE I should expect? (I know the VB5
> runtime is also needed, but that is only about 1 Meg)
>
> Since I don't know Visual Basic, I would also like to know
> the name(s) of good book(s) which explain designing the user
> interface and working with Access files
>
> Thanks for any and all help and suggestions
>
> John Thomas Smith
> http://www.direct2usales.com
> http://www.pacifier.com/~jtsmith[/color]

1st, I hit the wrong number on the title, I meant ver5

2nd, Ok... I will stick with the A97 developer tools CD

On Thu, 03 Mar 2005 20:12:48 GMT, "Larry Linson"
<bouncer@localhost.not> wrote:[color=blue]
>I don't know the size of the VB executable, but don't forget that you will
>have to include the Jet database engine, and _don't underestimate_ the time
>and effort to re-write. There are some (not inexpensive) 3rd party
>conversion tools, but those who use them tell us that they are "only the
>start". The VB UI _appears_ similar to Access, but there are many
>differences -- a big, unobvious one being that there are no data events such
>as Before Update, After Update, etc., that we use all the time. VB has no
>"bound forms" and its combination of "data control" and "bound controls" do
>not work nearly so smoothly as Access bound forms and controls.
>
>For an overview of frontending a database with Access or VB, look in the
>downloads section of http://appdevissues.tripod.com.
>
> Larry Linson
> Microsoft Access MVP
>
>
>"John Thomas Smith" <jtsmith@pacifier.com> wrote in message
>news:ffqe21tv1e6eln7ir1r2dgj51f28bf31dc@4ax.com.. .[color=green]
>> I have an Access 97 database I would like to distribute, and
>> provide a compiled program for those who don't have Access
>>
>> I do have the Access 97 developer tools CD and runtime, but
>> the install that creates is REALLY large (essentially, from
>> what I know, the entire Access 97 application with all the
>> development interface removed or "locked out")
>>
>> I am thinking about getting VB Pro v5 to create the user
>> interface (fairly simple... a half dozen data entry screens
>> and 2 reports based on screen selections and queries) but
>> wonder how big an EXE I should expect? (I know the VB5
>> runtime is also needed, but that is only about 1 Meg)
>>
>> Since I don't know Visual Basic, I would also like to know
>> the name(s) of good book(s) which explain designing the user
>> interface and working with Access files
>>
>> Thanks for any and all help and suggestions
>>
>> John Thomas Smith
>> http://www.direct2usales.com
>> http://www.pacifier.com/~jtsmith[/color]
>[/color]


John Thomas Smith
http://www.direct2usales.com
http://www.pacifier.com/~jtsmith