Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rating: Thread Rating: 2 votes, 5.00 average. Display Modes
Old 12-28-2005, 04:11 AM   #1
prodigy
Newly Registered User
 
Join Date: Apr 2005
Posts: 66
Thanks: 0
Thanked 0 Times in 0 Posts
prodigy is an unknown quantity at this point
client server installation

Hi,
All these days I was developing applications in Access (mdb) (file-server). Now, I want to put my hands on Access Project (adp) (client-server). I am a new born at this. So any thing I ask might be silly, u know

I want to develop my cleints (front-end) on Access and database on (SQL-Server 7). I have installed SQL-Server 7, on the Server-Computer (Win-2003 advanced server). My Client-Computers run on Win2KPro. Pls let me know on what to install on the client side so that my clients can connect to the SQL-Server. (Is it the complete SQL-Server that I have installed on the Sever side or anything else ???)
Thanks in advance.

Prodigy

__________________
|)
||^|)(,
Quote:
If you love peace, prepare for war
prodigy is offline   Reply With Quote
Old 12-28-2005, 04:49 AM   #2
Kodo
"The Shoe"
 
Kodo's Avatar
 
Join Date: Jan 2004
Location: Syracuse NY
Posts: 707
Thanks: 0
Thanked 1 Time in 1 Post
Kodo is on a distinguished road
Send a message via MSN to Kodo
you should be using sql server 2000. SQL 7 is nearing EOL and has moved to special support in MS.
In any case, Your client ony needs MS-Access installed. SQL server can communicate with your project over a network, so when you set up your MS Access Project, it will ask you for the server connection information. Once you've provided that, you're ready to rock.
__________________
Message boards: The only place where multiple personality disorders are treated with a "welcome" post.
Kodo is offline   Reply With Quote
Old 12-28-2005, 10:22 PM   #3
prodigy
Newly Registered User
 
Join Date: Apr 2005
Posts: 66
Thanks: 0
Thanked 0 Times in 0 Posts
prodigy is an unknown quantity at this point
Re: ClientServerInstallation

Thanks for your prompt reply. It seems so easy now with your answer. Will try getting it. But am sure that I have to come back as this new platform has lotta things to teach me.
Thanks again.

Prodigy.

__________________
|)
||^|)(,
Quote:
If you love peace, prepare for war
prodigy is offline   Reply With Quote
Old 12-30-2005, 01:30 AM   #4
prodigy
Newly Registered User
 
Join Date: Apr 2005
Posts: 66
Thanks: 0
Thanked 0 Times in 0 Posts
prodigy is an unknown quantity at this point
Error: client-server installation

Hi Kodo,
Tried as you had suggested but didn't work.
The network has 1 Domain Controller (Server) and multiple clients (logging into the domain). As I try to connect to the SQL-SERVER from the clients (logged in the domain) it gives error "Unable to connect".

However, as I try to connect to the SQL-SERVER from the clients (not logged into domain but logged in the local machine) am able to connect. Any suggestions.

Prodigy.
__________________
|)
||^|)(,
Quote:
If you love peace, prepare for war
prodigy is offline   Reply With Quote
Old 12-30-2005, 05:27 AM   #5
Kodo
"The Shoe"
 
Kodo's Avatar
 
Join Date: Jan 2004
Location: Syracuse NY
Posts: 707
Thanks: 0
Thanked 1 Time in 1 Post
Kodo is on a distinguished road
Send a message via MSN to Kodo
how did you set up the connection on the clients? did you use windows authentication or SQL authentication?
__________________
Message boards: The only place where multiple personality disorders are treated with a "welcome" post.
Kodo is offline   Reply With Quote
Old 12-30-2005, 08:03 AM   #6
prodigy
Newly Registered User
 
Join Date: Apr 2005
Posts: 66
Thanks: 0
Thanked 0 Times in 0 Posts
prodigy is an unknown quantity at this point
Re: client-server installation

Hi Kodo,
I have used windows authentication.
Hope this information helps you in understanding the issue.

Prodigy.
__________________
|)
||^|)(,
Quote:
If you love peace, prepare for war
prodigy is offline   Reply With Quote
Old 12-30-2005, 08:20 AM   #7
Kodo
"The Shoe"
 
Kodo's Avatar
 
Join Date: Jan 2004
Location: Syracuse NY
Posts: 707
Thanks: 0
Thanked 1 Time in 1 Post
Kodo is on a distinguished road
Send a message via MSN to Kodo
Try making another user in sql server that can login to that database. Then use those credentials for the project connection and see if that works.

__________________
Message boards: The only place where multiple personality disorders are treated with a "welcome" post.
Kodo is offline   Reply With Quote
Old 01-07-2006, 04:35 AM   #8
prodigy
Newly Registered User
 
Join Date: Apr 2005
Posts: 66
Thanks: 0
Thanked 0 Times in 0 Posts
prodigy is an unknown quantity at this point
view in client-server

Hi Kodo,
Have tried and it works. I was unable to do so as I had not created user in SQL Server (didnt know ), however as soon I created user in the SQL Server am able to get into my records. Thanks to you.

Now, when I try to create a view from any of the client-side (Access front-end) it gives me error (it does not allow me to save the view). However, as I try to do it sitting on my server its easy and am able to do so. I can also see the view from any client (edit/modify the view too). Any suggestions ?

Prodigy.
__________________
|)
||^|)(,
Quote:
If you love peace, prepare for war
prodigy is offline   Reply With Quote
Old 01-09-2006, 06:53 AM   #9
SQL_Hell
SQL Server DBA
 
SQL_Hell's Avatar
 
Join Date: Dec 2003
Location: UK
Posts: 1,325
Thanks: 15
Thanked 39 Times in 37 Posts
SQL_Hell will become famous soon enough
permissions?

SQL_Hell is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Server Side Vs Client Side Queries wricoasolutions General 7 11-26-2005 07:06 AM
Determine client PC name from terminal server DataMiner General 0 11-12-2003 09:38 AM
[SOLVED] Excel DDE Server -> Access DDE Client WonLee General 2 04-04-2003 05:04 AM
Client Server Advice Len Boorman General 1 11-21-2002 05:22 AM
Basic Client Server neil_turner General 1 09-02-2002 03:43 AM




All times are GMT -8. The time now is 05:12 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World