J
Jennifer
History - we had a server in Kansas with network workstations that the
telecommuter staff would virtually connect to to run our access databases.
Data was moved to a server in Minneapolis, but instead of individual
workstations they created Virtual Machines on the data server. The small
independant Access databases run very well and the SQL queries we run through
SQL Query analyzer run weill. The databases that use an odbc connection to
compare local data to data in the SQL database are dying on the vine-
non-responsive, or giving us various space issue errors or invalid operation
errors.
Can anyone explain the difference between the use of independant
workstations and the use of the virtual machines on the server. I assume it
has something to do with sharing the system resources.
telecommuter staff would virtually connect to to run our access databases.
Data was moved to a server in Minneapolis, but instead of individual
workstations they created Virtual Machines on the data server. The small
independant Access databases run very well and the SQL queries we run through
SQL Query analyzer run weill. The databases that use an odbc connection to
compare local data to data in the SQL database are dying on the vine-
non-responsive, or giving us various space issue errors or invalid operation
errors.
Can anyone explain the difference between the use of independant
workstations and the use of the virtual machines on the server. I assume it
has something to do with sharing the system resources.