Two work stations and one database?

[gargara]

Hallo to all.

I have one very fundamental question.Now i have a working database in my office , but may boss want to put the same database on the computer in the other office (which is far away from here) and the administrator there to work on it simultaneously with me.
I understand that this is done with some SQL server , but i will be very glad if someone can point me to some tutorial or something which can be usefull, because the SQL literature in internet is too much to handle.

 

[DCrake]

If bith the workstations are connected to a shared server then you can split the database up between front end and backend. Place the backend on the server. Give each use a copy of the front end on their pc and have the data linked to the back end database.

Have a look as the database splitter wizard

 

[MSAccessRookie]

Hallo to all.

I have one very fundamental question.Now i have a working database in my office , but may boss want to put the same database on the computer in the other office (which is far away from here) and the administrator there to work on it simultaneously with me.
I understand that this is done with some SQL server , but i will be very glad if someone can point me to some tutorial or something which can be usefull, because the SQL literature in internet is too much to handle.

The product SQL Server may not be needed here. Although it could be used, with only two users, it is a bit of overkill (unless there is an unusually large amount of data to share. A shared Network Server may be what is needed instead.

Have you Split your Application yet? If not, you should make this a priority. When two users share a Database it is always best for each of them to have their own copy of the Front end of the application (Forms, Queries, Macros, etc) that shares the common data (located on the shared Network Server).

This approach is usually good for up to 20-30 users or a database that is up to 1.5-2.0 GB in size. Beyond these parameteres, alternatives should be considered.

I hope this is the kind of information you were looking for.

 

[missinglinq]

I have one very fundamental question.Now i have a working database in my office , but may boss want to put the same database on the computer in the other office (which is far away from here) and the administrator there to work on it simultaneously with me.

Exactly how far is far away? Access works well on hard-wired, local networks. As I understand it, it performs badly on wide area networks as well as on wireless networks, secondary to loss of connection.

 

[MSAccessRookie]

Exactly how far is far away? Access works well on hard-wired, local networks. As I understand it, it performs badly on wide area networks as well as on wireless networks, secondary to loss of connection.

I agree, although the European and Asian Sales groups of the company that I am currently working for have had significant success with using a VPN Connection.

 

[gargara]

I am so sorry for my stupidity , the far away office is to the other end of the town , so the connection must be through internet. I haven't split anything till now, i just wanted to ask first , and i am sorry that i used the forms forum to ask this question , but i realized too late that there is another section for that kind of questions.

 

[MSAccessRookie]

I am so sorry for my stupidity , the far away office is to the other end of the town , so the connection must be through internet. I haven't split anything till now, i just wanted to ask first , and i am sorry that i used the forms forum to ask this question , but i realized too late that there is another section for that kind of questions.

I would be very careful of INTERNET connections. VPN works fine here, but is a little bit of work (and expense) to maintain. Perhaps others here will have suggestions.