AnsweredAssumed Answered

vrf Access data storage. (Local & on Server)

Question asked by VRFuser on Sep 1, 2002
Hello Svante,

     Thanks for your input. We have already used Visual Basic witin the
company to do
the task described (So I have the code) , but I have had no experience
inputting VB code into VEE, so how do you
go about it. Is it easy?.

Best Regards

Gavin.

Email: gavin.candy@bhc.co.uk




                                                                                                                   
                    Svante                                                                                         
                    Sundelin              To:     "VEE vrf" <vrf@it.lists.it.agilent.com>                          
                    <svante.sundel        cc:     VEE vrf <vrf@it.lists.it.agilent.com>                            
                    in@rtm.se>            Subject:     [vrf] Re: Access data storage. (Local & on Server).         
                                                                                                                   
                    02/09/02 11:06                                                                                 
                    Please respond                                                                                 
                    to Svante                                                                                      
                    Sundelin                                                                                       
                                                                                                                   
                                                                                                                   




Hello Gavin,
We have made for our test executive rtmTE a solution similar what you are
asking for. The design is a server-based database in Access (or MS-SQL) and
a locally database in Access on each test station. The server-based
database is updated after each device/item/product/ tested. If for some
reason the server based database is not connectable the locally database is
updated. So next time a device/item/product/ is tested we check if there
are any data in the local database and if so the locally stored date is
moved to the server-based database.
The code to handle the database is written i Visual Basic and it is called
from within the Vee environment

Best regards

Svante Sundelin

Rationell Teknik och Management AB
Nytorpsvgen 24, Box 1723 183 17 Tby, Sweden
www.rtm.se.



gavin.candy@bhc.co.uk wrote: Hi VRF,

I am currently storing test data to a Access database on a server.
The problem is that the server, from time to time will be disconnected from
the network.
A option I have been looking at is too store a local copy of the database
on the
machine running Vee Pro & then every so often copy the database to the
server.
Obviously I will need to check that the server is active.

Has anybody had experience in this area?

Any code or help will be appreciated.

Thanks for your help in advance.

Thanks

Gavin Candy.
Quality Engineer.
BHC Components Ltd
20-21 Cumberland Drive
Granby Industrial Estate
Weymouth
DT4 9TE
England

Tel: ++44 1305 830734
Fax: ++44 1305 760670
Email: gavin.candy@bhc.co.uk
website: http://www.bhc.co.uk

---
You are currently subscribed to vrf as: svante.sundelin@rtm.se
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email
"vrf@it.lists.it.agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".---
You are currently subscribed to vrf as: gavin.candy@bhc.co.uk
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email
"vrf@it.lists.it.agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".




---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@it.lists.it.agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

Outcomes