Hello, what would be a good module for accessing data contained in
a MS Access database file? Are there any examples of doing this
that you know of?
In article <nn1Ah.2617$2%1.2205@trndny02>, <QoS@domain.invalid.com> wrote:
>Hello, what would be a good module for accessing data contained in
>a MS Access database file? Are there any examples of doing this
>that you know of?
Depends what kind of platform you can use.
If you are under Windows, DBD::ODBC will work wonders.
If you `bridge' Windows <-> Unix, you can set up a DBI::ProxyServer on
a windows...Accessing access
Can anyone help me please? This has been driving me nuts for ages.
I want to use vb 6.0 to control data in a database (an access
database). I've looked at tutorial all over the net but I don't want
to use a data grid or anything like that because I want to control the
database, not see it.
So far, from one tutorial I've managed to get something on the lines
dim db as Database
Set db = OpenDatabase("E:\BT.mdb")
dim rspeople as recordset
set rspeople = db.openrecordset("people")
**************...Access to Excel to Access
I have a form with two text boxes, text1 and text2. What I need is a
button that exports each text box to a specific cell in an excel file,
the excel file needs to be refreshed/updated so a calculation will run
and the cell containing the calculation result is passed back to a
third text box on the form in access. Ideas?
> I have a form with two text boxes, text1 and text2. What I need is a
> button that exports each text box to a specific cell in an excel file,
> the excel file needs to be refreshed/updated so a calculation will run
> and the cell containing th...Accessing... accessing... fascinating
The AIX has fallen...
Reply to firstname.lastname@example.org
...Accessing Notes from Access
We have been charged with extracting some information from a notes
database, into access or excel. We don't own any lotus products at all.
We've tried installing NotesSQL odbc driver, which appears to install just
fine, but it doesn't add any odbc driver to the listing, and when I run the
admin tool it tells me that we don't have any appropriate version of notes
on the machine. The system prereq stated we needed one of the lotus apps.
So, I assume that we won't have access to the notessql driver unless we get
a copy of notes or domino.
The...Access Controls in Access
How on access can you set access controls to your users?
If they log in with one username and password they can just read
information and if they log in with another username and password they
can read and write?
I have no idea how to do this, is it even possible??
Try playing with the access security tool, you can add users, groups,
passwords, read/write allowances etc. to your database using that.
Its under the 'Tools' menu of Access.
> Try playing with the access security tool, you can add users, groups,
> passwords, read/write allowances etc. to you...access to Access #2
I've been reading some old posts that talk of an inability to connect
to an Access database with RB. Is that (still) true? If so, that
would be a show stipper for us.
Thanks for any insight,
...Access parameters and accessibility
I'm reading the book "Programming in Ada 2005" of John Barnes and I have
difficulties to understand the chapter about access parameters.
In chapter 10.7 on pages 197/198 he writes:
An access parameter can be passed on to another access parameter;
typically the accessibility indication is passed on unchanged but in the
unusual circumstance where the called subprogram is internal to the
calling subprogram, the accessibility level is replaced by that of the
(statically known) formal calling parameter if less than the original
Could some...Spawning Access from Access
Is it possible to spawn an Access program from another Access
program with out going to a batch file or something? I would like to
have an Access main menu and bring up a different front end Access
program depending on the menu selection. I'm using Access 2000.
On 27 Dec 2004 05:26:34 -0800, "Hank" <email@example.com> wrote:
Sure. You can use Automation like this:
dim o as new Access.Application
o.OpenCurrentDatabase "c:\two.mdb", False
>Is it possible to spawn an Access program from another Acc...ACCESS accessibility from a C++ process launched from an ACCESS form
Here is my problem. From an ACCESS form, I run a C++ process reaching
the same database in read/write mode via the ODBC driver. An error
occurs: " The database has been placed by an unknown user in a state
preventing it from being opened either locked. SQLSetConnectAttr
failure of the pilot " (Nota : translated approximatively from the
french error message). However, if I have used an another form before
(eg. to modify a table), or if I have modified myself a record of any
table, there is no problem. It seems that the database is in a state "
read-only " by default until th...Accessing webservice from access
Is it possible to call a web service that returns a dataset, from access?
Could I please have an example of how to call such a service from access?
"John" <firstname.lastname@example.org> wrote in message
> Is it possible to call a web service that returns a dataset, from access?
> Could I please have an example of how to call such a service from access?
I don't know if there's an easier way but you can use the MSXML object. I
suggest you do...Calling up OutLook Express from Access Basic in Access 2.0?
Is the following remotely correct?
=DDE("C:\Program Files\Program Files\Outlook
I'm not sure that OEmig50.exe is the executable
for OE. Anybody know?
I find no list of TOPICS to use with the DDE
related commands in Access Basic or VBA
in OutLook Express or MS Outlook. Where
does one go for that sort of info?
"MLH" <CRCI@NorthState.net> wrote in message
> I found that the correct name of the OE executable is msimn...
> =DDE("C:\Program ...accessing ms access via ODBC without Microsoft Access
If I have a computer without Microsoft Access installed but with an
ODBC connection to a .mdb file - can I still access the 'database' via
<email@example.com> wrote in message
> If I have a computer without Microsoft Access installed but with an
> ODBC connection to a .mdb file - can I still access the 'database' via
Yes, provided you are running a program prepared in a language that supports
ODBC and have installed an ODBC driver on that user'...