Re: Computer build ok for my server?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Yikes! This is the main reason I wanted a server. I need to be able to access my Access Database on the road. I was planning on doing the VPN thing. But, as you and others have said, it isn't recommended. What should I be doing instead? Surely other people have some sort of remote access to their databases, right?



"Bill Sanderson" <bill_sanderson@xxxxxxxxxxxxxxxxx> wrote in message news:8043A5A9-F85D-4AFD-B069-837A3437C68D@xxxxxxxxxxxxxxxx
The thing I'll flag which nobody else has so far is the remote access bit:

You can do this via RWW if you can spare two desktops when this remote access is needed. Or, you can, perhaps, as I do, dedicate an old machine to providing a desktop for such remote access,

You don't want to use the administrative sessions on the server for this purpose--that's both risky and not within licensing bounds. And, you don't want to add a true terminal server for two sessions, probably.

You won't want to run an Access database via a VPN connection unless you are in a locale such as Korea or some Scandinavian countries where broadband may mean 10 or 100 megabits per second. You need Terminal Services,

"Todd" <Todd@xxxxxxxxxxxxxxx> wrote in message news:%23YmplUNvIHA.5096@xxxxxxxxxxxxxxxxxxxxxxx
Hi all! I'm new to servers and wanted some quick advice on my new system. I plan on using the server for 5 computers and want to accomplish these tasks:

1. share files locally
2. allow remote access to files
3. sync Outlook
4. allow remote access to an Access database (probably 2 connections at a time max)

This is the server I was considering at Dell. Adequate? Thanks!

-----------------------------------------------------------------------------------------------
PowerEdge SC440 Dual Core Intel® Pentium®E2180, 2.0GHz, 1MB Cache, 800MHz FSB
Operating System Microsoft® Small Business Server 2003 R2 with SP2, Standard Edition
Memory 2GB DDR2, 667MHz, 2X1GB Dual Ranked DIMMs
Primary Hard Drive 250GB 7.2K RPM Serial ATA 3Gbps 3.5-in Cabled Hard Drive, Primary
Hard Drive Controller Onboard SATA Controller - No RAID
Floppy Drive No Floppy Drive
Network Adapter On-Board Single Gigabit Network Adapter
CD/DVD Drive 48X CD-ROM Drive
2nd Hard Drive 250GB 7.2K RPM Serial ATA 3Gbps 3.5-in Cabled Hard Drive, Additional
Hard Drive Configuration Onboard SATA, 2 Drives connected to Onboard SATA Controller No RAID


RD1000 RD1000, Ext USB Drive with bundled SW
RD1000 Removable Disk Media QTY 1, Removable Hard Disk Cartridge for RD1000, 80GB Native/ 160GB Comp
Hardware Support Services 1Yr BASIC SUPPORT: 5x10 HW-Only, 5x10 NBD Onsite

.

Relevant Pages

  • Re: How to do this?
    ... move the backend tables to the SQL Server and link the sql server tables in ... > typically one things of an Access database as either a relational database ... when you speak of splitting a frontend to an IIS ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Access database stability issues
    ... We have a front-end Access database file and the back-end Access database file with all the content. ... The back-end file is located on the server while the front-end is installed on 3 different computers in our office. ... Once we upgraded to SBS 2008, each client computer began experiencing occassional crashes due to the front-end losing its connection to the back-end file. ...
    (microsoft.public.windows.server.sbs)
  • Re: How to do this?
    ... would return to questioning if a basic IIS server facing the public really ... to backaway from the technology a little bit to look at the business plan ... conditions on trying to front a website on an Access database that you have ... You would have IIS load of the SBS, ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: To Web or to synchronize? That is the question.
    ... putting together an Access database and ASP, ... Jet replication is a really great tool if you have laptop users ... Server, and just host the app on a Windows Terminal Server in the ... the ASP solution and Lyle's SQL ...
    (comp.databases.ms-access)
  • Re: Slow response from Windows 2003 web server
    ... I am not sure which of these entries in the HTTPERR Logfile concerns my ... This is my simple test ASP script, ... What excatly do you mean by "Access Database - change in Windows Server ...
    (microsoft.public.inetserver.iis)