Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

sharing a databse

 
   Database Help (Home) -> Programming RSS
Next:  From 2000 to 2005  
Author Message
S.Dickson

External


Since: Dec 20, 2007
Posts: 1



(Msg. 1) Posted: Sat Sep 30, 2006 5:48 am
Post subject: sharing a databse
Archived from groups: microsoft>public>sqlserver>programming (more info?)

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

Thanks

 >> Stay informed about: sharing a databse 
Back to top
Login to vote
oj

External


Since: Aug 24, 2003
Posts: 91



(Msg. 2) Posted: Sat Sep 30, 2006 1:15 pm
Post subject: Re: sharing a databse [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You can create a web front-end and allow data to be
inserted/updated/deleted. This is exactly what most (low end) websites do.

--
-oj



wrote in message

>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
>
> Thanks
>

 >> Stay informed about: sharing a databse 
Back to top
Login to vote
Robert Klemme

External


Since: Dec 20, 2007
Posts: 184



(Msg. 3) Posted: Sat Sep 30, 2006 7:30 pm
Post subject: Re: sharing a databse [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Databse project group vs2005 missing - Hi, I am just attempting to create my first managed stored procedure. Started VS2005. went to File | New | Project Under C# There is no "Database" project node. I have visual studio 2005 and sql server 2005 standard edition installed on my d...

Need some advice about db design (sharing data or not) - Hi all, I have a simple database of persons. Each person may have 0 or more addresses. Each person may also have 0 or more vehicles associated. My question is the following. If 2 persons share the same address (they are roommates) should I use the..

need help with query - I want to sum the records in a table (u) which have 'P.M.' in a field value and test against a fixed limit something to the effect of : case when SUM(substring(u.sTime,1,4)='P.M.') <= 64 Then .... except it should work ...

Next?? - I have a field stored as NTEXT(16). I need to replace some of the content in this field. I know the replace function doesnt work. I see there is UPDATETEXT - is this the ONLY way to do it ?? 'cos it looks quite complicated? thanks, Justin

How can I get the resultset from a stored procedure - I have a stored procedure which will output a table. How can I use a sql statement to get the result of the sp? Thanks a lot
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]