S.Dickson DeleteThis @shos.co.uk wrote:
> I am very new to programing and serves ect and just learning.
>
> have just set up a business with a freind but we both work fro home.
>
> I have built an access database that we enter in ourcustomer details
> and any orders they place with us.
>
> As we both work from home we would like a way of sharing this database.
> I have a computer in the loft that can be ran as server and also have a
> static IP address..
>
> Plase could you explain in basics what i need to do to turn the access
> database into a database to be shared over the server.
>
> We will not wnat any thing too comlicated or advance at the moment
This is not going to work out. You need a server database, Access is
client side only (unless you talk about MSDE which is Access on the
front but the backend is really MS SQL Server).
You can probably transfer all your data easily with DTS - but then you
still do not have the UI. You can either link Access to the SQL Server
or create a completely different front end (web based for example).
Regards
robert
>> Stay informed about: sharing a databse