A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Storing Back End on a Terminal Server



 
 
Thread Tools Display Modes
  #1  
Old May 11th, 2010, 03:43 PM posted to microsoft.public.access
Trini Gal
external usenet poster
 
Posts: 20
Default Storing Back End on a Terminal Server

Hello,

I'm almost done with the database I created for approximately 5 users using
Access 2007 and verified that all the users have been upgraded to 2007. I
intend to split the database, store the back end on a Terminal Server which
is running 2003 and distribute the front end to my users.

My question is, will the database run fine or does the Terminal Server need
to be upgraded to 2007?

Thanks in advance for your time.
  #2  
Old May 11th, 2010, 10:58 PM posted to microsoft.public.access
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default Storing Back End on a Terminal Server

Trini Gal wrote:

I'm almost done with the database I created for approximately 5 users using
Access 2007 and verified that all the users have been upgraded to 2007. I
intend to split the database, store the back end on a Terminal Server which
is running 2003 and distribute the front end to my users.

My question is, will the database run fine or does the Terminal Server need
to be upgraded to 2007?


Storing the backend database file on a terminal server is a bit
unusual as most foiks would put the BE on a file server.

That said neither the Terminal Server, if being used as a file server,
or a file server needs to have Access installed on it.

However if you want to run the Access FE from the Terminal Server then
the access will nee to be installed on it. The runtime will suffice
if you've purchased the A2003 runtime.

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/
Granite Fleet Manager http://www.granitefleet.com/
  #3  
Old May 12th, 2010, 08:18 AM posted to microsoft.public.access
a a r o n . k e m p f @ g m a i l . c o m
external usenet poster
 
Posts: 1,108
Default Storing Back End on a Terminal Server

correction, you cannot buy the A2003 runtime!






On May 11, 2:58*pm, "Tony Toews [MVP]" wrote:
Trini Gal wrote:
I'm almost done with the database I created for approximately 5 users using
Access 2007 and verified that all the users have been upgraded to 2007. *I
intend to split the database, store the back end on a Terminal Server which
is running 2003 and distribute the front end to my users.


My question is, will the database run fine or does the Terminal Server need
to be upgraded to 2007?


Storing the backend database file on a terminal server is a bit
unusual as most foiks would put the BE on a file server.

That said neither the Terminal Server, if being used as a file server,
or a file server needs to have Access installed on it. *

However if you want to run the Access FE from the Terminal Server then
the access will nee to be installed on it. *The runtime will suffice
if you've purchased the A2003 runtime.

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 seehttp://www.autofeupdater.com/
Granite Fleet Managerhttp://www.granitefleet.com/


  #4  
Old May 12th, 2010, 07:54 PM posted to microsoft.public.access
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default Storing Back End on a Terminal Server

"a a r o n . k e m p f @ g m a i l . c o m" wrote:

However if you want to run the Access FE from the Terminal Server then
the access will nee to be installed on it. *The runtime will suffice
if you've purchased the A2003 runtime.


correction, you cannot buy the A2003 runtime!


I used the past tense when I mentioned the A2003 runtime.

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/
Granite Fleet Manager http://www.granitefleet.com/
  #5  
Old May 12th, 2010, 07:55 PM posted to microsoft.public.access
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default Storing Back End on a Terminal Server

"Tony Toews [MVP]" wrote:

However if you want to run the Access FE from the Terminal Server then
the access will nee to be installed on it. The runtime will suffice
if you've purchased the A2003 runtime.


Although I should've added that you can also run an A2003 MDE in the free A2007
runtime. You will probably want to disable the ribbon though which can easily be
done.

I want my database created in A2003 (or before) display my own menubar only.
http://www.accessribbon.de/en/index.php?FAQ:7

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/
Granite Fleet Manager http://www.granitefleet.com/
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.