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

Thanks Graham

"Graham Mandeno" <Graham.Mandeno@xxxxxxxxxxxxx> wrote in message
news:eN6pWp%23vGHA.4456@xxxxxxxxxxxxxxxxxxxxxxx
Hi Cam

I can strongly recommend WinConnect Server XP from
http://www.thinsoftinc.com, as Steve mentioned.

I have clients using this for remote access to Access applications, often
two or more users sharing the same XP workstation on the office network.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

"CAM" <alex_martinez@xxxxxxxxxxx> wrote in message
news:%23Zdgm50vGHA.4384@xxxxxxxxxxxxxxxxxxxxxxx
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.







.

Relevant Pages

  • 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
    ... 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 ... 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
    ... 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: Why does splitting a mdb make it slower?
    ... In one form that opens as a continous form, the data looks like it is being repainted as it displays...you can see each row being created quickly. ... I created a table on the backend called KeepOpen. ... performance when opening the main database and opening tables and forms, by forcing the linked database to remain open." ... The folder name is 8 characters in length. ...
    (comp.databases.ms-access)
Loading