473,320 Members | 2,083 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Accessing a MS Access database across two servers

Hi

The technical support guys at my company have set up my system so that
the server containing the MS Access database is on one server, while
the pages that should access the database are on another server.

When the pages and database are on the same server, I usually just
connect through ODBC.

The problem is that I don't know how to set up an ODBC connection to
link from one server to a database in another.

Anyone know what I am getting at and know of a possible solution, or a
link to a site which may help.

thanks in advance

Brendan

Nov 13 '05 #1
4 2049
"Singularity" <Br*************@Singularity.co.uk> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
Hi

The technical support guys at my company have set up my system so that
the server containing the MS Access database is on one server, while
the pages that should access the database are on another server.

When the pages and database are on the same server, I usually just
connect through ODBC.

The problem is that I don't know how to set up an ODBC connection to
link from one server to a database in another.

Anyone know what I am getting at and know of a possible solution, or a
link to a site which may help.

I think this may be more of a network issue than an Access one. Can you see
both servers from your PC? Is there any particular reason why they've been
put on different servers? Seems a little odd to me.

Regards,
Keith.
www.keithwilby.com
Nov 13 '05 #2
Yeah, I can see both of the servers from my pc. I think the reason for
the configuration is to do with the firewall. They want to keep the
database behind the firewall and for the pages to access the database
to be kept outside the firewall.

Nov 13 '05 #3
This is the way things are set up for most applications I've done. The
database server is separated from the application server or servers for
a variety of reasons.

See the connection string references

http://www.connectionstrings.com
http://www.codemaker.co.uk/it/tips/ado_conn.htm

If your MS Access database is on a different server from the
application then you can reference the database file using the full UNC
path to the file which includes server name
(\\server\share\database.mdb)

Bill E.
Hollywood, FL

Nov 13 '05 #4
"Singularity" <Br*************@Singularity.co.uk> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
Yeah, I can see both of the servers from my pc. I think the reason for
the configuration is to do with the firewall. They want to keep the
database behind the firewall and for the pages to access the database
to be kept outside the firewall.

By 'pages' do you mean built-in MS Access pages or HTML or ... ?
Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: ndsoumah | last post by:
hello guys I'm trying to get access to variables I put in a session variable from another page and it fails... here's the exact situation main file page1.php
1
by: Mark McKay | last post by:
I've been reading 'Java RMI' from O'Reilly, and it provides a nice example of scaling a server application by creating multiple instances of server objects on several distinct machines (each...
68
by: rkusenet | last post by:
http://www.eweek.com/article2/0,1759,1820667,00.asp The database market grew by 10.3 percent in 2004, fueled largely by hunger for business intelligence and analytics, according to numbers...
5
by: premmehrotra | last post by:
I currently have a multi-user access database which is put on a shared drive L: on a Windows Servers. Entire database is one file premdb.mdb. Users access this database from their laptops....
6
by: Jeff | last post by:
Has anyone had any luck accessing an Oracle database from a web service? I have a C# DLL with various code to query an Oracle database. If I call the methods in this DLL from a Windows Forms...
0
by: John Fleming | last post by:
Hello, I am building a web application with the following components: 2 Web Servers - Windows Server 2003 - IIS 6 - .Net Framework version 2.0 - Reside in Domain A 2 Clustered Database...
3
by: RayPower | last post by:
I'm having a system using Access 2000 as both front-end (queries, forms, reports & temp tables for reports) & back-end (data) with back-end running on the server. The application runs on the...
2
by: vikas.bhatia | last post by:
Is this still true? http://groups.google.com/group/comp.databases.ibm-db2/browse_thread/thread/58c6c36ce9006d50/778f98749d8e2983?lnk=st&q=DB2+Connect+product+license&rnum=6#778f98749d8e2983 would...
4
by: Noy B | last post by:
Hi, I have developed a small application that is using a MSAccess DB. the problem is that it was developed on a machine where the application and the DB are both located. now it needs to be...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.