 | |
Slightly OT: Client / Server design with Access
comp.databases.ms-access comp.databases.ms-access
 |
| | Thread Tools | Display Modes |
#21
 
| |||
| |||
|
Re: Slightly OT: Client / Server design with Access -
03-01-2011
, 08:05 PM
|
This is one I use for Oracle (sometimes works): "Provider=OraOLEDB.Oracle;User ID=xxx;Password=xxx;Data Source=NameOfTNSEntry" (for use with the Oracle driver not the MS one) |
it? I think that's very odd, as it doesn't look like an ODBC connect
string to me at all.
--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/
#22
| |||
| |||
|
|
I actually use a mix of DAO and ADO when creating Server BE based apps. I should probably just stick to one I suppose but habits are hard to break..... |
things DAO can't do.
--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/
#23
| |||
| |||
|
|
I follow Larry Linson in calling this a "semi-bound" form, in that it's bound, but designed to never load the entire table -- it only ever loads a set of records with a limiting WHERE clause. |
when I know those contain a limited number of records.
In the early days of Access, Microsoft had some examples that opened an
entire table / query in a continuous forms format, then you selected a
record (e.g., by double-clicking) to open a form with details. That's fine
if you have a few hundred (maybe even a few thousand) records, but if you
are dealing with several thousand records, tens of thousands, or more, you
ought to re-consider that approach.
Larry Linson
Microsoft Office Access MVP
#24
| |||
| |||
|
|
I wanted to ask another question while this topic is on the table. I am currently using the SENS API IsNetworkAlive call to discover if there is an active LAN connection. This works rather well. I am aware that the SENS API also has events (Windows events) for things like change of network availability, loss of power (changing to battery for example), and a few others. I am wondering if anyone is aware of a VB class module (or any code) that shows how to hook into these events. It would be most useful in a FE / BE environment with a large group of laptop users who subscribe to the 'just dont care' philosophy of using equipment and software. The more damage I can intercept the better. I have seen some C++ code for it but no VB / VBA (the C (maybe c#) code was on MSDN here:http://msdn.microsoft.com/en-us/library/aa480679.aspx) Cheers The Frog |
have not yet seen a satisfactory means in VBA for detecting network
connectivity. Thus being able to run the SENS API is an attractive
idea.
Try:
http://groups.google.com/group/comp....005b33d2063f44
BTW, in the same thread, 'The Frog' said:
"The ability to extend what you can do with Access is what interests
me."
It interests me also.
Note: one of the more interesting links is now:
http://msdn.microsoft.com/en-us/libr...ndp.10%29.aspx
Although C++ has special, unique capabilities for bridging the managed
and unmanaged worlds, I am going to have to think long and hard about
the best way to make .NET DLL's available to Access. One person named
Steeve (one can only guess :-)) said somewhere:
"Data conversion between managed world and unmanaged world is your
job; this means you'll have to make a wrapper for each managed type
you use between the two worlds. And that's a big drawback of IJW since
this can't be automated, because obviously, it depends on your code.
However, it can be done anywhere you want. Also, I suggest you to take
a look at the System.Runtime.InteropServices.Marshal class, it can be
really useful."
So there are plenty of issues to address.
James A. Fortune
CDMAPoster (AT) FortuneJames (DOT) com
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.