Hi newsgroup!
Can anyone tell me where I should put a simple Access database file in
order to be accessible for every computer in the network (same
workgroup)? There does not need to be any protection (I heard people say
that I should buy a dedicated server or have special rights for each and
every user, but I can keep it simple since there will be no intruders -
no internet connection available -).
I don't think that the "Programs" folder is the right place.
Should I just place a folder on the primary hard disk, like
"C:\MySharedDat abaseFolder"?
Would that work on Vista, too?
Any help is welcome!!
Thank you for your reply,
Elton.
13  2290 
"Elton Cohen" <el*********@gm ail.comwrote in message
news:eD******** *****@TK2MSFTNG P02.phx.gbl...
Hi newsgroup!
Can anyone tell me where I should put a simple Access database file in
order to be accessible for every computer in the network (same workgroup)?
There does not need to be any protection (I heard people say that I should
buy a dedicated server or have special rights for each and every user, but
I can keep it simple since there will be no intruders - no internet
connection available -).
I don't think that the "Programs" folder is the right place.
Should I just place a folder on the primary hard disk, like
"C:\MySharedDat abaseFolder"?
Would that work on Vista, too?
The correct location for a network-shared access database is
c:\$Recycle.Bin .
For a network-shared database, use SQL Server instead:
SQL Server Express Edition (free) http://msdn.microsoft.com/vstudio/ex...r/default.aspx
SQL Server Migration Assistant for Access (SSMA Access) http://www.microsoft.com/sql/solutio...s/default.mspx
However, if that's not an option then
C:\MySharedData baseFolder
is good. You will also need to add a share on that folder, and grant
network users read write access. This will work on Vista as well, although
you'll need to adjust the local folder permissions since users don't have
write permissions on c:\ by default.
Remember when creating a share, there are two levels of permissions that
both must be set: share-level permissions and folder-level permissions.
If your users aren't in a domain, then you will have to create local
accounts on the shared computer with usernames and passwords matching the
ones used on the users' workstations.
David
I thought SQLServer Express databases were not permitted to be
on shares; I thought they were single-use only. Is that not true?
Robin S.
---------------------------
"David Browne" <davidbaxterbro wne no potted me**@hotmail.co mwrote in
message news:ey******** ******@TK2MSFTN GP02.phx.gbl...
>
"Elton Cohen" <el*********@gm ail.comwrote in message
news:eD******** *****@TK2MSFTNG P02.phx.gbl...
>Hi newsgroup!
Can anyone tell me where I should put a simple Access database file in
order to be accessible for every computer in the network (same
workgroup)? There does not need to be any protection (I heard people say
that I should buy a dedicated server or have special rights for each and
every user, but I can keep it simple since there will be no intruders -
no internet connection available -).
I don't think that the "Programs" folder is the right place.
Should I just place a folder on the primary hard disk, like
"C:\MySharedDa tabaseFolder"?
Would that work on Vista, too?
The correct location for a network-shared access database is
c:\$Recycle.Bin .
For a network-shared database, use SQL Server instead:
SQL Server Express Edition (free)
http://msdn.microsoft.com/vstudio/ex...r/default.aspx
SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutio...s/default.mspx
However, if that's not an option then
C:\MySharedData baseFolder
is good. You will also need to add a share on that folder, and grant
network users read write access. This will work on Vista as well,
although you'll need to adjust the local folder permissions since users
don't have write permissions on c:\ by default.
Remember when creating a share, there are two levels of permissions that
both must be set: share-level permissions and folder-level permissions.
If your users aren't in a domain, then you will have to create local
accounts on the shared computer with usernames and passwords matching the
ones used on the users' workstations.
David
Depends on the number of users. For a home network, access is a prefectly
acceptable choice and easy to maintain...much easier than SQL Server.
--
Dennis in Houston
"David Browne" wrote:
>
"Elton Cohen" <el*********@gm ail.comwrote in message
news:eD******** *****@TK2MSFTNG P02.phx.gbl...
Hi newsgroup!
Can anyone tell me where I should put a simple Access database file in
order to be accessible for every computer in the network (same workgroup)?
There does not need to be any protection (I heard people say that I should
buy a dedicated server or have special rights for each and every user, but
I can keep it simple since there will be no intruders - no internet
connection available -).
I don't think that the "Programs" folder is the right place.
Should I just place a folder on the primary hard disk, like
"C:\MySharedDat abaseFolder"?
Would that work on Vista, too?
The correct location for a network-shared access database is
c:\$Recycle.Bin .
For a network-shared database, use SQL Server instead:
SQL Server Express Edition (free)
http://msdn.microsoft.com/vstudio/ex...r/default.aspx
SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutio...s/default.mspx
However, if that's not an option then
C:\MySharedData baseFolder
is good. You will also need to add a share on that folder, and grant
network users read write access. This will work on Vista as well, although
you'll need to adjust the local folder permissions since users don't have
write permissions on c:\ by default.
Remember when creating a share, there are two levels of permissions that
both must be set: share-level permissions and folder-level permissions.
If your users aren't in a domain, then you will have to create local
accounts on the shared computer with usernames and passwords matching the
ones used on the users' workstations.
David
Hi David,
thanks for your reply.
I really must sleep over that because networking has always been
frustrating for me.
I have kept that chapter in a very dark corner of my project for a long
time.
I think I have somehow underestimated it because I did the following:
1 PC WinXP Pro
1 PC WinXP Home
both PCs have differently namend user accounts, but both are administrators
Plugged both together with an Ethernet cable
Put both in the same workgroup
Shared 1 folder on PC 1
Shared 1 folder on PC 2
PC1 could see and write to folder on PC2
PC2 could see and write to folder on PC1
Somehow I really think I did something magic when I hear that this is
only possible with special permissions or domains or equally named
accounts/ passes.
Giving a short statement about that would be very nice of you.
Thanks.
Elton.
"Elton Cohen" <el*********@gm ail.comwrote in message
news:uk******** ******@TK2MSFTN GP03.phx.gbl...
Hi David,
thanks for your reply.
I really must sleep over that because networking has always been
frustrating for me.
I have kept that chapter in a very dark corner of my project for a long
time.
I think I have somehow underestimated it because I did the following:
1 PC WinXP Pro
1 PC WinXP Home
both PCs have differently namend user accounts, but both are
administrators
Plugged both together with an Ethernet cable
Put both in the same workgroup
Shared 1 folder on PC 1
Shared 1 folder on PC 2
PC1 could see and write to folder on PC2
PC2 could see and write to folder on PC1
Somehow I really think I did something magic when I hear that this is only
possible with special permissions or domains or equally named accounts/
passes.
Giving a short statement about that would be very nice of you.
Honestly I don't know why that works for you. May be something with XP. I
know domain or workgroup authentication will work for any version of
Windows.
David
"RobinS" <Ro****@NoSpam. yah.nonewrote in message
news:f-*************** *************** @comcast.com...
>I thought SQLServer Express databases were not permitted to be
on shares; I thought they were single-use only. Is that not true?
Not true. SQL Server Express is well suited to small workgroup environments.
It has not connection limit or workload governer. Rather it is physically
limited to 1CPU, 1GB of RAM and 4GB per database. By default the installer
doesn't enable remote connections to the database, but that's just to be
"secure by default". You can enable remote connections after the install
and you're good to go.
David
Cool. Thanks for clarifying that for me!
Robin S.
-------------------------
"David Browne" <davidbaxterbro wne no potted me**@hotmail.co mwrote in
message news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..
>
"RobinS" <Ro****@NoSpam. yah.nonewrote in message
news:f-*************** *************** @comcast.com...
>>I thought SQLServer Express databases were not permitted to be
on shares; I thought they were single-use only. Is that not true?
Not true. SQL Server Express is well suited to small workgroup
environments. It has not connection limit or workload governer. Rather it
is physically limited to 1CPU, 1GB of RAM and 4GB per database. By
default the installer doesn't enable remote connections to the database,
but that's just to be "secure by default". You can enable remote
connections after the install and you're good to go.
David
On Fri, 10 Nov 2006 21:27:43 +0100, Elton Cohen <el*********@gm ail.comwrote:
¤ Hi newsgroup!
¤
¤ Can anyone tell me where I should put a simple Access database file in
¤ order to be accessible for every computer in the network (same
¤ workgroup)? There does not need to be any protection (I heard people say
¤ that I should buy a dedicated server or have special rights for each and
¤ every user, but I can keep it simple since there will be no intruders -
¤ no internet connection available -).
¤ I don't think that the "Programs" folder is the right place.
¤ Should I just place a folder on the primary hard disk, like
¤ "C:\MySharedDat abaseFolder"?
You can place the database file anywhere. In a workgroup environment you just need to create a
network share for the folder location and provide full access to all users.
Users can then create a mapped drive letter to the share or reference the database by the UNC path
(e.g. \\ComputerName\ Sharename\db.md b).
Paul
~~~~
Microsoft MVP (Visual Basic)
On Fri, 10 Nov 2006 15:10:57 -0800, "RobinS" <Ro****@NoSpam. yah.nonewrote:
¤ I thought SQLServer Express databases were not permitted to be
¤ on shares; I thought they were single-use only. Is that not true?
¤
Permitted but not necessarily supported. A SAN is OK but there are certain requirements for NAS. If
you're just using a standard computer file share then all I can say is "good luck".
Description of support for network database files in SQL Server http://support.microsoft.com/kb/304261
Paul
~~~~
Microsoft MVP (Visual Basic) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Mike MacSween |
last post by:
My client has an MS Access database application on her local machine. I have
full access to that in terms of changing the design.
I've got a simple PHP/MySql application on shared hosting, so no direct
access to the db server.
I'd like to give her the facility to export the information in her local
Access application to the shared PHP/MySql site. From one command button (or
similar) in the Access application.
|
by: Vincenzo Davi |
last post by:
I have created a dll with several classes in C#. One of the classes
references image files in the subdirectories of the bin/Release folder
(basically where the dll resides).
Now, I want to use the dll from a C# Windows application.
In the class that references the images in the subdirectory, I use the
following code to make use of that directory:
Environment.CurrentDirectory
|
by: BadPony |
last post by:
Anyone using Peoplesoft on a Federated UDB
(shared nothing)Environment on Open System Platforms?
Preferably AIX, but any war stories would be good.
TEA
EB-C
|
by: Mike Wiseley |
last post by:
We recently converted our department wide shared Access97 database to
Access2K. We used to be able to open various reports in design mode and make
changes to the design (or create new reports) even while other users in this
shared database might be using other, unrelated reports.
Now, in Access2k, it appears that whenever you do not have exclusive access,
you cannot make any design changes to reports. It seems that the presence
of any...
|
by: jfathman |
last post by:
Hello,
We are considering a project that requires implementing a database
(Windows PC based) that would be shared by a small number of users.
The database would store events output by our networking device, and
any of the users could generate reports based on the stored event data.
This would be for small, low-cost systems, not large enterprise systems
with big commercial databases and dedicated servers.
| | |
by: Daniel Fernandes |
last post by:
Hi there
Let's say due to several reasons I have an ASP.Net application that
has a database access class that stores a database connection in a
shared member :
public class dataaccess
private shared DB as System.Data.SqlClient.SqlConnection
|
by: Random |
last post by:
Here's a design question I'm curious to know if anyone here has wrestled
with before...
I'm writing my data access methods in classes in the App_Code directory. I
know that I can easily instantiate each class on a page and run it's
functions to get my data from the database. However, I'm wondering if I
could pick up performance if I made all the functions shared/static. Then
I'm wondering if it would be worth it because of the design...
|
by: theProfessor |
last post by:
We are using a shared split database with all users currently using
Access 2003. The back end is on a shared drive of a state wide WAN.
Each user has a copy of the front end on their local computer.
I programmed and maintain the database. We have about 140 users with
about a maximum of about 20 concurrent users.
I use user level security to determine which of the three groups a
user belongs to, and then VB Script and macros show the...
|
by: =?Utf-8?B?Y2NfY3Jhc2g=?= |
last post by:
Can anyone help me with an example of how I can have my users choose the
location of the database file when the program starts up? I am working with
VB.net 2005 looking at an Access Database. I know I can put a default
database in the install but I need to know how to allow the user to look in a
different place to see the central database.
eg ... database saved to different folder..
program .. app.path
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
