ACCESS VBA TO INTERFACE WITH A DATABASE IN SEQUEL SERVER.

[Brianus]

I have two prime questions:
1) I am working with access vba, but my input files are located in a database in a sequel server environment. What codes can I use to call or access the database/files in this sequel server?

2) Also, this same Access vba project utilizes input files located in various scattered platforms. What codes can I used to call or access these files from different platforms?
Any assistance would be greatly appreciated.
I wish you all a happy thanksgiving.
Thanks,
BM.

 

[AlexCuse]

I think it is easiest to set up your external tables through the linked table manager, so that they can be referred to the same as you would refer to a standard access table.

BTW, I think you mean SQL Server ;-)

Happy Thanksgiving to you too!

Alex

A wise man once said
"The only thing normal about database guys is their tables".

 

[abaldwin]

As Alex suggested you can create linked tables using dsn or if you want a purely code solution have a look at ADO connections and if you need various connection strings for ADO there is an excellent resource at

http://www.connectionstrings.com

Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.