RSS Forums RSS
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums

Writing to an Access Database

Join Date: Feb 2002
Location: Long Island, NY
Posts: 1,134
Reputation: samaru is just really nice samaru is just really nice samaru is just really nice samaru is just really nice 
Rep Power: 12
Solved Threads: 4
Colleague
samaru's Avatar
samaru samaru is offline Offline
a.k.a inscissor

Re: Writing to an Access Database

  #15  
Jan 9th, 2004
Originally Posted by eschodde
Unterminated string constant

/tutorial/guestbook.asp, line 21

strProvider = "Driver={Microsoft Access Driver (*.mdb)};
Well, first of all, that error has nothing to do with the location of the database. You're getting that error because you're not closing the string with a quote. Just put a quote a the end that string, like this:

Originally Posted by eschodde
strProvider = "Driver={Microsoft Access Driver (*.mdb)};"
Then you will probably have another error now. That string defines the connection and you have not provided the location of the database, just what driver to use, in this case, a Microsoft Access Driver. Look carefully at the sixth post of this thread where I show an example of how to access a database. Look at the second example.

If you have any other questions, ask away!
_.:: my websites ::._
blog @ www.samaru.net * engi No Jutsu @ www.narutorp.net * portfolio @ shinylight.com
deviantART: inscissor
Reply With Quote  
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 12:09 pm.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC