×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Access 2007 database(.accdb) by ODBC access on win2003 sbs server

Access 2007 database(.accdb) by ODBC access on win2003 sbs server

Access 2007 database(.accdb) by ODBC access on win2003 sbs server

(OP)
Dear Forum Members!

I want to share a database by ODBC on our public IP win2003 sbs server. I added ODBC DNS, etc.., but i cannot connect to the .accdb .

Can you show me a way how to make it work?

Thanks in advance,
Best Regards,
Gergely Kiss
Voip Telekom Hungary Kft.

RE: Access 2007 database(.accdb) by ODBC access on win2003 sbs server




Hi,

What have you tried?  You should see an MS Access ODBC Driver.

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Access 2007 database(.accdb) by ODBC access on win2003 sbs server

(OP)
Hi,

i tried also MDAC 2.8, but i cannot connect.

How do i need to do the setup at the server side?

We have an office 2007 accdb, with forms, etc..

This file i have to open from many locations.

Thanks,
Gergely Kiss
Voip Telekom Hungary Kft.

RE: Access 2007 database(.accdb) by ODBC access on win2003 sbs server



All my experience is from within MS applications, setting up connections to other data sources, via either MS Query to ActiveX Data Objects in VB code.

It would seem to me that each application would need a connection, thru either some DB management facitlty or explicit code written to connect and access the data.

By the was, as an aside, I am 2 generations removed from Hungary. My grandparents emmigrated in the early 20th century.  I wish I could tell you the area, but I believe it was not far from Budapest.

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Access 2007 database(.accdb) by ODBC access on win2003 sbs server

(OP)
I see, so i do not want to do any complex, i do not know the programming,  i just want to setup some ODBC system to host my file, and wait for the connection to it ( which is an access 2007 db ).

Good to hear:) I know many people left, to USA, and around Europe, maybe Australia.

Where do you live now? I am from Budapest.

Thanks,
Gergely Kiss
Voip Telekom Hungary Kft.
 

RE: Access 2007 database(.accdb) by ODBC access on win2003 sbs server




My family settled in the Philadelphia, Pensylvania area.

My mother had 4 sisters and a brother: one sister and the brother born in Hungary.  The oldest is still living at 99, and two others at 83 and 90.  My grandmother's family was Nidert. My grandfather's family name was corrupted to Geney.

I am living in the Fort Worth area of Texas.

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close