|
|
| Тема |
 Re: Access база през SQL Server [re: wqw] |
|
| Автор |
gmedics (непознат
) |
|
| Публикувано | 24.11.08 12:05 |
|
|
|
това отговаря на въпроса. тоест не може. идеята да ползвам access baza през sql server я взех от тука:
Може и да не съм разбрал правилно идеята. Това казва автора:
Use a true client to server setup.
You can move the data store from ms-access to sql server, and then optimize your access
application. MS access is a great front end to sql server. In fact, ms-access is NOT a database, but only a client to your database engine of choice. In fact, ms-access is really just a nice development tool to build applications with. The office cd does come with two database engines that you can use with ms-access. One is JET. JET is the default engine for ms-access, and it is not a client to sever based system. It is what we call a file share. It is this file share that you need to eliminate over the WAN (you must ELIMINATE the pieces of the file being transferred). The other data engine on the CD is a free 100% compatible sql server based engine. This server engine is called the desktop server, or MSDE (Microsoft Data Engine). This engine is the same as sql server, and it is free if you have the office CD. It means that ms-access will be running in a true client to server mode. You can even use the Enterprise manger tools from sql server to run and mange this little engine. It really is the same as sql server, but is throttled for 5 or less users. Some people even have claimed to run 25 or more with this engine by using programming tricks. Regardless, if you outgrow the small engine, then it is a transparent process to switch the data and code to sql server.
So, for low bandwidth applications, you might consider using the sql server engine (either sql server, or the desktop engine that ships on the office CD. This engine has been on that CD for the last two versions, and we already beta testing office 2003. I am mentioning this fact since often people don't realize that ms-access is now a true client to server product. This just simply means that you can use ms-access to create secure, robust and scalable applications for the corporate world. There are companies now running ms-access applications with 1000 user seat counts. Really, the only limitation of ms-access is going to be how much the server database can handle. This means that ms-access has come a long way and has grown up from being just a pc based database. I would even bet that ms-access is the most popular client to Oracle next to Oracles own products!
With good ms-access designs, then using sql server can work in a high speed net connection with ease. That means ms-access will work well with just a speed rating of 1. Some even have had success with using dialup lines to sql server.
| |
| |
| 
|
|
