Re: Using Visual Basic Net as front end - Access as back end
- From: Steve Schapel <schapel@xxxxxxxxxxx>
- Date: Mon, 14 Aug 2006 09:38:32 +1200
Cam,
In addition to the information given by Brendan and Arvin, you might also consider sticking with your existing Access application, running in one of your two Centers, and allowing the other to access it remotely using http://www.thinsoftinc.com/product_thin_client_winconnect_server_xp.html
I'm pretty sure that's what I would opt for.
--
Steve Schapel, Microsoft Access MVP
CAM wrote:
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:
- References:
- Prev by Date: Get Rid of Multiple Menu Bars on a Form
- Next by Date: Re: Update multiple fields if checkbox=true
- 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
|
