Re: Using Visual Basic Net as front end - Access as back end

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Steve/Graham

Can I have my back end database in California and have both Florida and
California users access to it.? California can access quickly, but Florida
it is slow. Also, won't I have the same problem of how slow the performance
in getting or opening a form for the user in Florida who is trying to access
the back end in California using WinConnect Server XP? Previously I had to
abort the back end access in California for the Florida users. We do use XP
professional as our operating system. I don't know too much about this
product and how it can help me. I appreciate if you can give me just a
little more information from a developers view. Thanks I appreciate the
help.

Regards,


"Steve Schapel" <schapel@xxxxxxxxxxx> wrote in message
news:e27oUDyvGHA.4612@xxxxxxxxxxxxxxxxxxxxxxx
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.


.

Relevant Pages

  • Re: Using Visual Basic Net as front end - Access as back end
    ... Currently I am using Access 2002 I developed an inventory tracking database, which this database is used in California and in Florida. ... 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. ... 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. ...
    (microsoft.public.access.formscoding)
  • Re: Using Visual Basic Net as front end - Access as back end
    ... really powerful machine to run the database front-end, ... I originally wanted to have the backend located in the California ... I could not have just one backend database it took Florida ... Report as the report writer and Access as the ...
    (microsoft.public.access.formscoding)
  • Re: Using Visual Basic Net as front end - Access as back end
    ... database is used in California and in Florida. ... I originally wanted to have the backend located in the California ... I could not have just one backend database it took Florida ... more to open up a report, which the backend was in California. ...
    (microsoft.public.access.formscoding)
  • Re: Using Visual Basic Net as front end - Access as back end
    ... database is used in California and in Florida. ... I originally wanted to have the backend located in the California ... I could not have just one backend database it took Florida ... Report as the report writer and Access as the ...
    (microsoft.public.access.formscoding)
  • Re: Using Visual Basic Net as front end - Access as back end
    ... this database is used in California and in Florida. ... I could not have just one backend database it ... Crystal Report as the report writer and Access as ...
    (microsoft.public.access.formscoding)