By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,806 Members | 1,490 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,806 IT Pros & Developers. It's quick & easy.

Accessing a MS Access database across two servers

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
"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

P: n/a
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

P: n/a
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

P: n/a
"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 discussion thread is closed

Replies have been disabled for this discussion.