I am about to start a program (my first) for agribusiness management 

information system, to include budgeting, stock control, payroll and 

field information.

I would like to use Access and VB6 to build the program. As a guide I am 

following Beginning VB6 Database Programming by John Connell and Access 

2002 Desktop Development.

I would appreciate any advice on what I should or should not do.



Regards

Don

Don,



I've an application written in VB6 and I use the Access MDB for tables,

indexes and stored procedures (SQL). I rely on VB code for all other tasks.

I do, however, use Crystal Reports to create output. I do not use, nor does

my application require Access.



Hope this helps.



Walt

Walt

Thanks for the email. I have seen quite a few emails regarding Crystal. 

What is the advantage of crystal and what is it? Is there any problem 

with using Access for my reports etc?



Regards

Don

Don,



Crystal Reports is a Seagate product that can read a wide variety of file

formats and incorporates SQL to select data for your reports. Active Reports

is another report writer that I look at before settling on Crystal. I chose

Crystal because of it integration with Wise InstallBuilder.



I cannot offer any help regarding Access reporting capability. I would think

that one would have to have access in order to create reports.



Crystal is rather pricey for just simple reports. You may also consider

using Office (Word/Excel) to create output in some instances also. I've also

created basic reports using the file system object to write out reports to

plain text files.



Walt

It's not clear from your post whether you're going to do your front-end in

Access (in which case you may not need VB at all) or VB (in which case you

may get better advice from the VB list).  But here's one bit of advice that

should apply in either case: don't rush your database design.  A well

designed database will save you tons of coding & obviate lots of performance

problems.  In case it's useful, you'll find some Access-centric design

reference at

http://support.microsoft.com/support/access/content/reldesign.asp.



HTH,



-Roy



Roy Pardee

Programmer/Analyst

SWFPAC Lockheed Martin IT

(xxx) xxx-xxxx



-----Original Message-----

From: DON LOWE [mailto:donlowe@s...]

Sent: Friday, October 19, 2001 10:22 PM

To: Access

Subject: [access] Starting a program







I am about to start a program (my first) for agribusiness management 

information system, to include budgeting, stock control, payroll and 

field information.

I would like to use Access and VB6 to build the program. As a guide I am 

following Beginning VB6 Database Programming by John Connell and Access 

2002 Desktop Development.

I would appreciate any advice on what I should or should not do.



Regards

Don

Roy

Thank you for the advice. I will use VB as the front end.



Regards

Don