-Поиск по дневнику

Поиск сообщений в rss_sql_ru_access_programming

 -Подписка по e-mail

 

 -Постоянные читатели

 -Статистика

Статистика LiveInternet.ru: показано количество хитов и посетителей
Создан: 16.03.2006
Записей:
Комментариев:
Написано: 4


Microsoft Access DB on WAN?

Суббота, 24 Февраля 2018 г. 13:32 + в цитатник
HI,
I have a question for those of you experienced with sharing databases across slow connections. Firstly, here is my network setup. I work in a branch office that is connected via a cable modem to the main office 150 miles away. We have a router/vpn box that makes us part of my company's WAN. Our cable connection is asynchronous with 3 Mbbs down and 256 Kbps up. I am very familiar with Microsoft Access and have been asked to create and share a database across our WAN. Since the connection from my office to the home office has a theoretical limit of 256 Kbps, I have a feeling having people open the Access database remotely is not going to be very swift. At any one time it is unlikely that more than 5 people will be using the DB, so we are not looking at a very high volume environment. The database itself will not be overly complicated either, but could easily become a few megabytes using Access over time. With the info above, what you recommend? Once again, I am very comfy with Access and can build my tables, queries, and forms to accomplish my goals in that program. I am concerned about performance. Should I consider using an MSDE backend with an Access front end? Would a web interface be the way to go (PHP, or ASP, or equivalent)? I've written a small application for Cold Fusion and an Access DB before, but that was a while ago. I would need to look at something free of charge this time around, plus I would need to learn the scripting language.Any advice would be appreciated. Thanks in advance.
Thanks

I did not find the right solution from the internet.
References:
https://arstechnica.com/civis/viewtopic.phpt=364308
Creative video production studio

http://www.sql.ru/forum/1286180/microsoft-access-db-on-wan


 

Добавить комментарий:
Текст комментария: смайлики

Проверка орфографии: (найти ошибки)

Прикрепить картинку:

 Переводить URL в ссылку
 Подписаться на комментарии
 Подписать картинку