Access program

  • Thread starter Thread starter KDS
  • Start date Start date
K

KDS

Hi
I have an access database I would like to put on the terminal server for
multiple users to access. Is this feasible and do I need to split the
database into a front end backend environment.
 
This will most likely work better if you break things up a
bit. Also, you might want to check out the archives of
this newsgroup, since many people have reported problems
with multiple users accessing Access databases at the same
time.

-M
 
KDS,

You should definitely split the database for use on Terminal Services. I
first deployed Access apps on TS using Access 97. This version of Access
was not designed with Terminal Services in mind, so certain transforms had
to be done to the installation. From my experience, I would strongly
suggest using only Access 2002 on TS. The following article explains how
Office XP was designed with TS as a consideration.

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechn
ol/office/officexp/deploy/xptersrv.asp

If you are on earlier versions of Access and don't want to upgrade, then
here is an article that describes some of the considerations to make Access
compatible with TS.

http://www.microsoft.com/windows2000/techinfo/administration/terminal/tsapco
mpat.asp

I have found it best to split the app into Front and Back ends, and have TS
users open their own version of the Front End exclusively. This was
necessary in earlier versions of Access...Not sure if Access 2002 is okay
with users sharing front ends on TS.(?) You can use login Scripts to copy
the most recent version of the front end to the user's profile directory if
you wan to simplify the distribution of design changes.

It helps to make an MDE file of the front end as it disables the users from
doing design changes, and may even use less memory on the server(?)

The Bottom line is that Office XP runs GREAT on TS...for earlier
versions...good luck.

HTH,

Josh
 
Back
Top