connecting to the database

[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

 

[Alex White MCDBA MCSE]

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.

 

[Guest]

Alex,
Is this connection ODBC. Wouldn't it be better to connect via OLE DB?
Don

 

[Alex White MCDBA MCSE]

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.