1
119121
Hi, Guys,
I have an Access Database(file) which is about 1Mb(may increase t
around 10Mb) in size. For security reason, I have to place th
file(.mdb format) in another location, linked by VPN(server side i
only Windows XP Pro) over ADSL(server side upstream is 128K) throug
the Net.
At the moment, I connect through the VPN and get into the share folde
and open the file, but the database operation is very slow. Within th
database, there are only a few tables, forms, 5 macro and a few shor
line of codes in it, also there are only around 200 records in th
largest table.
I would like to find out is there any solution that can speed up th
database operation.
Many thanks,
Be
I have an Access Database(file) which is about 1Mb(may increase t
around 10Mb) in size. For security reason, I have to place th
file(.mdb format) in another location, linked by VPN(server side i
only Windows XP Pro) over ADSL(server side upstream is 128K) throug
the Net.
At the moment, I connect through the VPN and get into the share folde
and open the file, but the database operation is very slow. Within th
database, there are only a few tables, forms, 5 macro and a few shor
line of codes in it, also there are only around 200 records in th
largest table.
I would like to find out is there any solution that can speed up th
database operation.
Many thanks,
Be