Multiple Users Access DB Via Terminal Server

[Guest]

I have a little different spin on the multiuser question, which I did not see
answered. I saw the various threads about splitting the front-end/back-end
for allowing multiple users access to the DB. however, my situation is a bit
different.

I have multiple users accessing an server via MS Terminal Server. Once
logged on to the server, THEN they open the db. Typically any where from 1
to 4 people "could" be on simultaneously.

Thus, not sure the whole back-end/front-end splitting of DB approach is
necessary. Assuming this is true, then, are there specific security settings
I should set on the Folder, DB, users, (any or all)? If so, what might they
be?

Thanks!

PatK

 

[Douglas J. Steele]

Yes, your application should still be split into a front-end and back-end.

Each user should have his/her own copy of the front-end.

Each user requires change access to the folders where the MDB files exist
(that's Read, Write, eXecute and Delete)

 

[Van T. Dinh]

I do have an application with Access FE on W2003 Terminal Server with SQL
Server BE (on a W2000 server) and I use Tony Toews AutoFE to create a copy
of the FE (or to update the FE) for each user when he/she starts the
database.

This arrangement should also work well with Access FE + Access BE.

See Tony Toews' article:

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

 

[Guest]

Can I create an MDE file for the users, or simply distribute the frontend
MDB? I don't seem to be actually able to create one, using the tool, and am
assuming that is bacause the DB is Access 2000 format (at least, that is the
error I seem to get).

thanks for the fast response!

Pat

 

[Douglas J Steele]

Yes, you can create an MDE and give each user a copy.

If you're using either Access 2002 or Access 2003, then yes, you won't be
able to create an MDE if the MDB is in Access 2000 format. You must convert
the database to be able to create the MDE. For other possible causes for not
being able to create an MDE, check
http://www.access.qbuilt.com/html/conversion.html#CannotMakeMDE

 

[Guest]

Thanks....so, I guess my question is this: I have Access 2003. Why is it
that when I create a new DB, it shows it as being in Access 2000 format? I
would think it would use the "latest" format by default, unless I specified
something else? Just to be sure, I just opened Access, selected File, New,
and created a blank database. In the Objects window, at the top, it says:
emptytest: Database (Access 2000 File Format). Why would it default to 2000?

thanks!

Pat

 

[Guest]

arg....!!!! I figure out how to make it 2002-2003 format...but now I am
thinking WHY were the defaults set to this! All the work I have been doing
up to now (couple years of simple stuff) turns out they are all 2000 format.
Why would MS set the default to this? I figured out how to change it, but I
guarantee you I never knew where this setting even was until just now! So,
why would it be set for that? Is there a way/benefit to easily convert the
DBs I have to 2003 (particularly the one I want to be able to create an MDB
file for? Is this a bunch of "importing to a new DB" that I have to do?

Anyway...thanks for all the help....each day, a new revelation!

Pat

 

[Brendan Reynolds]

The default is Access 2000 format because of the howls of protest that
echoed around the world circa 2000, when people realised that the databases
they had converted from Access 97 format could no longer be shared with
their colleagues who had not yet upgraded.

Yes, you can easily convert an MDB in Access 2000 format to Access 2002/2003
format. From the Tools menu, choose Database Utilities, then Convert
Database, then To Access 2002 - 2003 Format.

If you never need to share databases with people who use Access 2000, you
can change the default for new databases, but I would not worry about
converting existing databases until and unless you need to create an MDE.

 

[Guest]

Thanks Brendan! onward and upward!

Pat

The default is Access 2000 format because of the howls of protest that
echoed around the world circa 2000, when people realised that the databases
they had converted from Access 97 format could no longer be shared with
their colleagues who had not yet upgraded.

Yes, you can easily convert an MDB in Access 2000 format to Access 2002/2003
format. From the Tools menu, choose Database Utilities, then Convert
Database, then To Access 2002 - 2003 Format.

If you never need to share databases with people who use Access 2000, you
can change the default for new databases, but I would not worry about
converting existing databases until and unless you need to create an MDE.

 

[Tony Toews]

arg....!!!! I figure out how to make it 2002-2003 format...but now I am
thinking WHY were the defaults set to this! All the work I have been doing
up to now (couple years of simple stuff) turns out they are all 2000 format.
Why would MS set the default to this?

To add to Brendan's explanation "Darned if you do, darned if you
don't" There would've been howls and grumbling either way.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm