I have a FE / BE database that I want available to a number of users. Access
2010. I'm guessing, but I expect the users will have different versions of
Windows, and as far as I know, Access 2010 is only compatible with Windows 7.
Grateful for any advice how to set this up and reliable free secure server
services. Thanks
Phil

All versions of Access, at least as far back as Access v. 2 (circa 1994) are
mulituser-enabled right out of the box. Access 2010 will run under Windows
7, Vista, and XP (and, without researching, I am reasonably sure, also
Windows 2000).

Sounds to me as if you are already "good to go".

I've run Access 2010 on Windows XP. Your problem may be in running
Access/Office 2010 on the same machine as earlier versions of
Access/Office -- Office stopped "playing well with older versions" at Office
2007. If you must have Office 2010 and earlier versions on the same
machine, the simplest approach is to install and run one of the versions of
Access/Office in a virtual machine... very simple, and included with and
including Windows XP installed in the VM, Windows 7. Not impossible on
other versions of Windows, but not included.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access

"Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote

On Sun, 24 Jul 2011 21:36:34 +0100, "Phil" <phil (AT) stantonfamily (DOT) co.uk>
wrote:

Office 2010 runs on Windows XP SP3 just fine as I have personally done
that. Also see
http://technet.microsoft.com/en-us/l.../ee624351.aspx

While you've already done it see the "Splitting your app into a front
end and back end Tips" page at
http://www.granite.ab.ca/access/splitapp/ for more info. See the no
longer free Auto FE Updater utility at http://www.autofeupdater.com/
to make the distribution of new FEs relatively painless.. The
utility also supports Terminal Server/Citrix quite nicely.

There is no such thing is free server services. Unless you run Linux
at home.

If one office then, as Larry states, Access has everything built in.
If multiple offices on a slower than 100 mpbs per network you'll want
to use Terminal Services.
My random thoughts on Microsoft Access, Terminal Server and/or Citrix
http://www.granite.ab.ca/access/terminalserver.htm

Although with some extra work you can migrate the backend to SQL
Server and use that over the Internet. You'll probably want to use a
VPN to keep the data secure.

See my Random Thoughts on SQL Server Upsizing from Microsoft Access
Tips page at http://www.granite.ab.ca/access/sqlserverupsizing.htm.
Also see my blog postings on this topic at
http://msmvps.com/blogs/access/archi...r/default.aspx

There is a tool from the SQL Server group which is better than the
included SQL Server Upsizing Wizard.
SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sqlserver/e...ol.aspx#Access

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

"Access Developer" <accdevel (AT) gmail (DOT) com> wrote in
news:993fg6F5p8U1 (AT) mid (DOT) individual.net:

Why do you say this? I see no difference with the way O2007 works
with earlier versions than O2003 did with earlier versions. And I
see no difference between O2010 and O2007 in that regard, either.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

On 24/07/2011 22:01:20, "Access Developer" wrote:
Hi Larry

Had problems trying to run Access 2010 on XP. Can't remember what they were,
but will try again. Am currently only using Access 2010, Incidently tried
Office SP1 and that was disasterous. Still trying to find out the best way to
store a back end Db on some remote server so that eveyone has access to the
data. Do I need to migrate to something like MySQL or are there free secure
sites where I can hold the BE database as an .AccDb Thanks

Phil

There are hosted SQL Server sites, and hosted MySQL sites. I doubt any are
"free" -- there are some sources for "free" (ad-supported) web sites, but
not supporting remote access to SQL Server or MySQL as far as I know.

I have never used a server backend across the Internet, only on a LAN or
WAN, and I did not set that up. But it is possible to do so -- perhaps David
or others here have that experience.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access


"Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote

"Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote in
news:j0maeb$ie6$1 (AT) speranza (DOT) aioe.org:

As Larry says, you won't find any that are free that are going to
give you any security. And most of those that are inexpensive don't
actually sell the type of security you actually need (VPN).

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

On 7/26/2011 6:51 PM, David-W-Fenton wrote:
Access Services. That allows you to have an access db on any PC and it
automatically syncs to a sharepoint server when connected to the
internet. This is still very new so you will need to do lots of
research & reading to find out how to do it.

Probably easier to find a sql server hosting service for a reasonable
price and connect Access to sql server via the internet. Of course, you
will need to very carefully craft your Access front end and the data
sources to minimize the amount of data transmitted over the internet.

finally, depending on the number of users you could set up a local LAN
with a handful of PCs that your remote users could remote into via
LogonPC or similar to remotely take control of the local PC. If more
than a small handful of remote users, you would need a local, dedicated
microsoft server with terminal services installed on it.

Have fun.

bob

On Jul 24, 3:36*pm, "Phil" <p... (AT) stantonfamily (DOT) co.uk> wrote:
Are you sure?

A person, on a recent thread in LinkedIn, said she had very good
success with Azure.

Here's a link to Azure, http://blogs.office.com/b/microsoft-...sql-azure.aspx

The runtime for Access 2010 is free,

Actually, Bob, even if your front-end is not "carefully crafted",
performance can be surprisingly good... the database engine on the client
and the ODBC drivers (and I've used both Microsoft's and third-party
drivers) create very 'decent' requests and transmissions of data. Most of
the 'professional' Access developers I've worked with considered most of
that 'careful crafting' just 'good development/programming practices' -- for
example, you don't want to open a form on a large table as some might do in
a standalone environment with everything on the same machine, but you don't
want to do that with a file-server (Jet or ACE) backend on another computer
in your network, either. But, most of them did not start their experience
with Access single-user applications to get such bad habits.

You _may_ get some performance gains if you have an expert on the server
database you're using with stored procedures, views, and triggers, but those
definitely are not _necessary_ to adequate performance. My principal
clients did not want 'development done at the server level' because they
found it easier and less expensive to find competent Access developers to
contract or to hire than to find server DB developers (many of whom did not
deign to create user interfaces and client applications).

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access


"BobAlston" <bobalston9 (AT) yahoo (DOT) com> wrote