Re: Using Visual Basic Net as front end - Access as back end
- From: "CAM" <alex_martinez@xxxxxxxxxxx>
- Date: Sun, 13 Aug 2006 20:04:51 -0700
Hello,
I want to thank all of you professional for your input it helped alot.
Anybody else who wants to give further input, please do. Thank you I
appreciated all input.
.. "CAM" <alex_martinez@xxxxxxxxxxx> wrote in message
news:eDa7$%23vvGHA.2436@xxxxxxxxxxxxxxxxxxxxxxx
Hello,
I am wondering if someone has come across this before. Currently I am
using Access 2002 I developed an inventory tracking database, which this
database is used in California and in Florida. Both Inventory centers
(California/Florida) have their own database spited (Front-end - queries,
forms, macros, etc. and back end - tables only) in their respective state.
I originally wanted to have the backend located in the California
inventory center, which both California and Florida have access to.
Unfortunately, I could not have just one backend database it took Florida
about 40 to 50 seconds or longer to open up a form and about 2 minutes or
more to open up a report, which the backend was in California. Now I have
the California inventory center front end and the backend and Florida has
their own front-end and backend all this is due to slow performance over
our WAN across the country. About 5 years ago I developed a database
using Visual Basic 6 as the front end and Crystal Report as the report
writer and Access (tables and queries) as the backend. It worked great
and fast, but this database was used only in one location in our WAN not
over the other side of the United States. My thoughts are using Visual
Basic Net as the front end, Crystal Reports as the Report Writer and
Access as the backend (tables, queries). I would like to use this
combination by having the backend in California (Access), which both
California and Florida have access to. I want to try to retain saving all
of my tables and queries in Access if possible. Will this work? Can
Florida access the database without any major delays or corruptation
problems. Of course each users PC's will retain their own Visual Basic
net Front end to speed up the database. Their will be about 25 users per
inventory center. Or should I get Microsoft Sql server and use Visual
Basic Net. We are on a budget like most IT shops and I thought using the
combination of Visual Basic net, Crystal Reports, Access will be the least
expensive way to go. Can someone give me their input. I like to have
much input as I can get before I can do any major undertaking. Thank you
in advance.
.
- Follow-Ups:
- Re: Using Visual Basic Net as front end - Access as back end
- From: Graham Mandeno
- Re: Using Visual Basic Net as front end - Access as back end
- References:
- Prev by Date: Re: Help Sub Form Question
- Next by Date: Re: Option Group Question.
- Previous by thread: Re: Using Visual Basic Net as front end - Access as back end
- Next by thread: Re: Using Visual Basic Net as front end - Access as back end
- Index(es):
Relevant Pages
|
