Newbie - Server Question

  • Thread starter Thread starter Doug Thomson
  • Start date Start date
D

Doug Thomson

Okay, I'm new to Access having spent several years with
FileMaker Pro. Obviously Access is a much more powerful
database, but despite that I've found the fundamentals
rather easy to learn.

So, I've converted a database that I built for our school
records from FileMaker to Access, an interesting learning
exercise, and now want to deploy that database on our
server ... here's where I get lost. FileMaker has a server
application that manages the FileMaker database sharing on
our LAN. Very simple and works flawlessly. How do we do the
same with Access? I do hope the solution isn't SQL ... that
doesn't seem at all simple.

Cheers
Doug
 
FileMaker has a server
application that manages the FileMaker database sharing on
our LAN. Very simple and works flawlessly. How do we do the
same with Access? I do hope the solution isn't SQL ... that
doesn't seem at all simple.
Click to expand...

Actually, depending on how you built the application, sql server may be a
solution for you. (if you create what is called a ADP project, then you must
use the desktop version of sql server. It is called the MSDE, and much like
the idea of the server component you have for FileMaker).

You can also use ms-access with OUT a server side component. This is what we
call a file share, and is OFTEN how we share data files in ms-access. It is
not as reliable as using the server based engine, but it is easer to install
(in fact, nothing needs to be installed on the server side).

If you are going to run ms-access in a file share, and have it be multi-user
then you should be distribution a mde front end to EACH user, and place JUST
the data file on the server. For split info:


http://www.granite.ab.ca/access/splitapp.htm

http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba15_3.htm
 
Back
Top