Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connect to database using ip address or drive letter

Status
Not open for further replies.

JohnBoy2005

Programmer
Jul 12, 2005
117
GB
I'm trying to connect to a database on another server using the following code:

conn.Open ("Provider= Microsoft.ACE.OLEDB.12.0;Data Source="\\10.48.224.5\c$\database\test.accdb")

I'm getting errors. Permissions are fine. Is it possible to do.

Cheers
 
I've also mapped a drive onto the server and replaced the ip address with the driver letter, still doesnt work.
 
It looks like there's a spare quotation mark in there! (Source=")
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top