Re: Using Visual Basic Net as front end - Access as back end
- From: "Arvin Meyer [MVP]" <a@xxxxx>
- Date: Tue, 15 Aug 2006 15:41:57 -0400
I have been using Terminal Service and Citrix which is similar, but far more
expensive than the peoduct mentioned by Steve and Graham. You will be
pleasantly surprised at the performance increase. In fact, if you use a
really powerful machine to run the database front-end, the performance can
easily beat many workstations.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
"CAM" <alex_martinez@xxxxxxxxxxx> wrote in message
news:eptKq$AwGHA.4460@xxxxxxxxxxxxxxxxxxxxxxx
Steve, Graham,
I now have a better picture and I thank you for your time in giving tips
and explaining it to me. I belive this well be the fix I need. Thanks
again.
Regards,
"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: CAM
- 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: Passing Parameters to a Query from a Form to Filter a Report
- Next by Date: Re: Passing Parameters to a Query from a Form to Filter a Report
- 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
|
