Connect to Microsoft Access database

5 pts.
Tags:
Microsoft Access
VB
Web development
I want to connect to an access database that is placed on an internet server. i use the following syntex when i want to connect localy. With DB .Provider= "Microsoft.Jet.OLEDB.4.0" .Properties("Data Source").Value= "C:Data.mdb" .Open .CursorLocation = adUseServer End With Can't i just change the datasource property that points to the database on the internet, and what information must i have from the sever to connect to it.

Answer Wiki

Thanks. We'll let you know when a new response is added.

This code snippet is for a Access Database on the local machine. The methods properties for provider and data source would be different for a server based database. As it stands, this code will not work with anything other than an access database on the local system– which might be good enough since the JET engine can be used regardless of whether access is installed on the system or not. (Though I don’t know that you can use any version of access to create the database, since I normally connect to a SQL DB with my little pieces of code.)

As for the information you need, you’ll need to know:

The Database software type and version (MS SQL 2000/2005/2008, MYSQL4/5, etc)
The Server Name or Full DNS name
The Port used by the SQL Server
The database name and table names
The username and password that is able to connect to the server
Finally, if the server is even available to you to connect. (I.E. if you are attempting to connect across the internet, it might be firewalled off from you)

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following