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")
So what I'm basically trying to do open a database and then set a
recordset to it so i can start manipulating data.
The actual code is a bit more indepth than this, but this is basically
the first few lines run. The program stops on the bit where I set the
recordset. I've stepped through the code and the db has definately
been opened and there is definately a table in the actual database,
but I'm told there is a type mismatch when it gets to the recordset
any ideas? it really is driving me nuts,
any help is appreciated,
> Can anyone help me please? This has been driving me nuts for ages.
> dim db as Database
> Set db = OpenDatabase("E:\BT.mdb")
> dim rspeople as recordset
> set rspeople = db.openrecordse...access to Access
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,
In article <firstname.lastname@example.org>,
Dave <email@example.com> wrote:
> 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.
I've never tried it, but I think you should be able to access Access via
...access to Access
We use MS access 2000 at work and few people know how to work it including
We are using it on a network and more than one person is trying to access it
at once. Needless to say this isn't working as one has to log out first
before another can enter data. Is there an easy way around this? Or a
complicated way, actually I'll take anyway.
We have just started this database so any changes would be better done
Mike Kelliher wrote:
> We use MS access 2000 at work and few people know how to work it
> including me.
> We are using it on a network and mo...Function to Prevent Open MDB via Access File Menu (Access 2000 AND Access 2002
Does anyone know where I can obtain a function to test whetber my front-end
is open via the provided icon vs. the Access 2000/2002 file menu?
I want to test the open.mdb and if opened via the Access file menu prevent
opening the mdb.
I know I saw something way back on such a function or test on startup in
What are you trying to accomplish? There's probably some other way to
go about this...
D Kanagh wrote:
> Does anyone know where I can obtain a function to test whetber my front-end
> is open via the provided icon vs. the Acce...Converting from Access 2000 to Access 2007
I have continued to work with MS Office 2000, and am looking into an
upgrade to 2007.
Are there any major changes in Access that require retraining of
Access 2000 users?
I use Access largely for ad hoc queries and reporting on an old AS400
Redwood City, CA
Access 2007 can open your A2000 MDB and use and modify it just as you did in
However, the interface will be unfamiliar, e.g. the menus, toolbar, and
database window are gone (replaced by ribbons and a navigation pane.)
For more detail, about the changes involved, see:
Converting to Access 20...Date picker from MS-Access 2000 to MS-Access 2003
How do I get a date picker (References: Microsoft Calendar Control 8.0
Location C:\Windows\System 32\mscal.ocx) inset in MS-Access 2000, to work in
Why not scrap it and use the all-API approach Stephen Lebans has at
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"JHB" <joern_bea@removeThis_tdcadsl.dk> wrote in message
> How do I get a date picker (References: Microsoft Cal...conversion of ms access 97 application to ms access 2000
hi access gurus
would appreciate if u can give me pointers regarding conversion of ms
access 97 application to ms access 2000, like what are the problems to
be expected and how to handle it.
also would appreciate if anyone can give pointers on using VSS with ms
access 2000, how to handle multiuser issues when it comes to insert,
update and delete.
thanx in advance,
firstname.lastname@example.org (bala) wrote in message news:<email@example.com>...
> hi access gurus
> would appreciate if u can give me pointers regarding conversion of ms
>...Access 2007 Question: Are form command buttons the new XP format with Hot/Cold mouse over functionality?
For those of you that are using the Access 2007 Beta, can I ask, comparing
Are form command buttons the new XP format with Hot/Cold mouse over
...what is equivalent of format(date) function of MS Access in MS Sql Server 2000
I am facing a problem with a sql what i used in MS Access but its not
returning the same result in MS Sql Server 2000. Here i am giving the
SELECT TOP 3 format( MY_DATE, "dddd mm, yyyy" ) FROM MY_TAB WHERE
The above sql in ACCESS return me the date in below format in one
Friday 09, 2003
But in Sql server 2000 i am not getting the same format eventhough i
am using convert function, date part function etc.
Please if you find the solution would be helpful for me..
If you field is a datetime, you can use the CONVERT function to conver...Any MS Access that is NOT MS Access in WinXP?
I have a small application for bookkeeping, actually working in
Access with small routines in VBA. I want to rewrite it in Java, but I
don't want to use Access anymore.
I started looking for another database, but I found none. I already
know (and used) MySQL and PostgreSQL (waiting 7.4), but as far as I
know they are only daemon, and under windows they use a lot of memory
and CPU time. It's like installing a Ferrari only to cross the road.
Maybe an approach with loading the daemon at the start of the program,
and quitting it at the end, but I don't know how ...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
<firstname.lastname@example.org> 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'...Read-Only ODBC Access to MS Access 2000
I have created an ODBC File DSN data source in Windows XP. I have
successfully used this DSN to link tables from a Sybase SQL Anywhere
database to Access 2000.
How can you make this ODBC connection read-only?
P.S. I would like to make the ODBC connection itself read-only (if
possible) rather than adding security to the MS Access DB.
...Access 2000 opening in Access 2007 Issue
I have an Access 2000 database that we have many Groups created in it
which we are now trying to use in Access 2007.
Each year we add a new group. For example,
So, in Access 2000 I have just added a new group called "Sales 2010".
However, when we open up this MDB in Access 2007, the newly created
"Sales 2010" is not showing up. While still appearing when opening
with Access 2000.
This new group does not appear in "Navigation Pane or Navigation Pane
Options" like all the others in Ac...Data pastes into Access 2000 and not Access 2007
The same database, developed in Access 2000 and opened in 2000 and
Basically I copy some data from a xls into a table and have no
problems doing this in access 2000 but get an error message with the
access 2007 version.
Does anyone have any info on this?
On Thu, 1 Oct 2009 17:14:12 -0700 (PDT), Mat
YOU actually holds most of the info: what is the error message you are
getting, and what is in the Paste Errors table?
Microsoft Access MVP
>The same database, developed in Access 2000 and opened in 2000 and
&...Access 2000 mde on Access 2007 runtime?
Is it possible to run Access 2000 .mde file on a PC that has only Access
2007 runtime installed?
On Mon, 7 Apr 2008 17:39:02 +0200, "Skeptik"
I believe yes, but you may not want to if you use toolbars, because
they are handled differently in A2007.
>Is it possible to run Access 2000 .mde file on a PC that has only Access
>2007 runtime installed?
...Access 97 vs Access 2000 formats
I wrote a VB5 program on my win98 system. The program creates a blank
database composed of 3 tables - nothing fancy. When I open that blank file
with Access 2002, it says "Database (Access 95 file format)".
The customer (my neighbour) has been using that program for about a year,
and has been adding to the database. Each table now contains between 500 and
1000 records. This mdb database is now approximately 350 Kbytes in size.
My neighbour works for a small company and they have about 6 computer, all
different operating systems, win98, Me, XP. The computers are all connec...ms-access 2007 online? How can users log on to access 2007 from the internet?
10 years ago, the below was written (see very end, after my signature
What, if anything, has changed?
I have Access 2003 and soon Access 2007 on a Windows XP Professional
or Windows Vista Ultimate machine, with SQL Server Express running on
it, and I want somebody, with a password (which I will provide) to be
able to log onto a A03 or A07 dB from the internet. Now that I type
this I realize that unless I put the database onto a web server
somewhere, probably that will be impossible without some third-party
software (which I vaguely recall exists somewhere, just released this
year, allo...Use ASP to read MS Access query that calls MS Access function
I have an MS Access query for a table called MyTable. One of my
fields in the query is a custom field that looks like "MyField: =
MyFunction(ID)" where ID is a field in MyTable.
I have ASP code and I can use it to read the query OK when "MyField"
is not part of the query. If I add in MyField and then run my ASP
code to try to read all the query fields, I get an error message on my
web browser which says something to the effect of "cannot find
MyFunction." On the Access side, I have MyFunction set up in a module
and use the keyword "Public" in fr...Access 2007 db.accdb modified using Access 2010 can no longer be opened with Access 2007
A client sent me an Access 2007 db.accdb which I modified using 2010.
The client could not open using Access 2007 "Unrecognized database
I tried to open using Access 2007 and got the same message.
Does anyone have an explanation??
"Barry Edmund Wright" <email@example.com> wrote
> Does anyone have an explanation??
Explanation: It's easy to look back and make a version backward compatible
because you can see and test with the older version (Access 2010
successfully opens the Access 2007 dat...Rows disappear when converting from Access 2007 to Access 2000
I had a database with 3 tables (no queries) in an Access 2007 file.
I converted the file to Access 2000 format, as that is the only Access
format recognized by the SQL server we have here.
Some sql queries gave weird results, so I went back to the original
To my surprise, I noticed that the Access 2000 version of the file was
trimmed: one table had been "shrunk" from half a million records to
128,000 ! More than a third of the rows had simply vanished, yet no
error message was ever given!
Has this happened to you? Do you have any idea how to prevent it?
PS...How to access MS Access from Perl?
Good day! I am writing some Perl script on the server side for HTML forms
that can create/update an MS Access database. Does anyone know of examples
how this can be done?
Your help is greatly appreciated.
Email to firstname.lastname@example.org bounces.
Anyway, try DBI and DBD::ODBC. Or maybe DBD::ADO, but I've never tried it.
Connect without DSN The ability to connect without a full DSN is introduced
in version 0.21.
Example (using MS Access): my $DSN = 'driver=Mi...Access 2007 and Access 2010
Hi to All !
I installed MS Access 2010 and my previous Access 2007 was covered, so suddenly disappeared its' functions I had been worked out a lot !
Access 2010 is good for web-database but it is not good for local applications.
Is it possible to have in my pc both MS Access 2007 and MS Access 2010 ?
wrote in message
>Is it possible to have in my pc both MS Access 2007 and MS Access 2010 ?
As a general rule all your VBA code etc. should run just fine in 2010. There
i...Access 2003/Access 2007
I have a mde database file developed for a client. This was
originally set up and run in Access 2003. Everything worked fine.
Recently this client purchased several new computers. These computers
came with Access 2007. Now whenever an Access 2007 user opens the
database, it locks the database for all other users. I have checked
all the Access settings I know to check. These new machines are also
running Windows 7. I am not sure if this is enough information or if
anyone has seen this behavior and may have some suggestions.
Any help is appreciated.
open the options ...Accessing MS Access from Paradox
I'm trying to access MS Access tables from Pdx9.
I read the FAQ: Subject: FAQ:PdoxWin:Accessing MS Access from
aradox:2002.03.11 and went through the steps of " 2. Solution "
The error message I got was " Unrecongnized database format
C:\FpsAgra\TaggingPro\List.mdb, Alias: TaggingProData " then the dailog
pops-up asking for the user name and password which are
"TaggingProData" is the name of the DataBase Alais with this path:
Currently using Pdx9 9.00.738
and the MS Access ta...