connecting to the database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've just started using Access. I have some experience with ASP and pulling
information from databases, but I'm having a difficult time figuring out how
to connect to my database that's on my local server. Any suggestions would be
great.

Thanks
 
You can link SQL databases directly into access via the File/Get external
data/link this will then show you your SQL tables within access.

Hope that answers your question.
 
Hi Donald,

I could be wrong here, but when linking into MDB external sources other than
other mdb's, is going to be ODBC, I could be wrong so any other input would
be good. I have noticed that you can wrap the SQL native client (2005)
within an ODBC connection I would be interested in reviewing the performance
of this style of connection. The ease to which an ODBC connection can be
linked into access has to be a strong point, to squeeze as much speed as
posible, process server side rather than client side.
 
Back
Top