Hi Rob, > Who would build UI into a DB ?, > (OOPS, millions of Access developers)
Hehehehehe. I've got a client that built their entire enterprise (a weekend warrior events planning type thing) on an Access 97 database and are using it across the network. One db stores the necessary cached information (locally) and the other database is only connected to when they need to book/enqueue an event (via ADO/ODBC) - iow, the second database functions ONLY to store data. It works well, all things cosidered. They've usually got 5-10 clients connected to the server. > I'm using ADO and "Microsoft.Jet.OLEDB.4.0" > I know that that 3.51 may be a bit faster, but > there was some reason (memories ?) that I went 4.0 The 4.0 engine is supported on more systems out of the box. > ...'chirping'... I'll bet you're accessing the DB via a mapped UNC path and you don't have enough CAL's to access the server from that many connections (yes, even TWO can be too many for direct drive access). Check the log files on the server. Right click on my computer, manage, event viewer, system, look for the red errors in the left column - it'll probably say something like "client access exceeded" or "licensing mode exceeded". It's NOT the end of the world, yet. ;) To avoid this type of issue you can create a DSN **ON THE SERVER** and access the DSN from the exe's. Just set the SERVER param in the connection string to the server's name. Also, you should probably be setting the connectiontimeout property higher than it is now in order to ensure the connection doesn't disappear when it appears to be doing nothing (to ADO). Regards, Shawn K. Hall http://12PointDesign.com/ http://ReliableAnswers.com/ '// ======================================================== Help Wanted: Telepath. You know where to apply. '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [email protected] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
