Re: How to access MS-Access metadata tables (eg MSysObjects)
The answer is given here:
Problem Note 7495: No read permission on System Tables when using
SAS/ACCESS Interface to ODBC with a Microsoft Access ODBC Driver
Dietrich Alte schrieb:
> Dear all,
> I have an MS-Access MDB-file with hundreds of tables and want to know
> when they were created and/or modified.
> The MS-Access metadata table MSySObjects includes this information,
> but I have not managed to read it from SAS.
> (CLI describe error tells me that I have no reading access)
> --> Does anybody have a working code example for this?
> I have tried the libname ACCESS and Libname ODBC variants.
DIETRICH ALTE, Dipl.-Statistiker, Dr. rer. med.
Wiss. Projektmanager "Study of Health in Pomerania (SHIP)"
Institut f�r Community Medicine - SHIP/KEF
EMA-Universit�t Greifswald - Medizinische Fakult�t
Walther-Rathenau-Str. 48, D-17475 Greifswald, Germany
Phone ++49(0)3834-867713, Fax ++49(0)3834-866684
...Re: How to access automatically in SAS a MS Access table name
i am not sure if SAS will support long file name if you use libname.
a workaround is to use passthrough.
On Jan 16, 2008 12:31 PM, JKamgang@Yahoo.com <JBKamgang@gmail.com> wrote:
> Dear All,
> Happy New Year ,
> Please, I need your help in figuring out how to access in SAS a MS
> table name which has more than 32 characters. As this program merges 5
> databases, I need to have almost everything automated. That's why I
> don't want to rename manually the table names.
> Please find the progra...Accessing Oracle Tables from MS Access
How difficult is this? I'm having a tough time getting a simple select to
I am using MS Access 2002 and Windows XP.
What do I have to do to make a simple select statement like this work:
select id from emp
I have stumbled upon many websites although none straight to the point.
Any help in how to get this done, or pointing me in the right direction of a
book or website, would be greatly appreciated!
Yes, I do have the table links working.
But I did want to run the select for such things as grabbing the next number
off of a sequence. As in:
select test.nextval fro...Accessing Access
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...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...Accessing 2 tables having same name but different databases ms-access
I have an application with MS-Access as backend and JSP/ tomcat as
For getting better response time(as access is very slow compared to
other RDBMS's), I have split the main DB into two DB's on different
disks on my server for better performance.I have kept the table names
same but changed the DB names. How do I access tables from both the
This is what I have done; I made different connection to the
respective DB's i.e. con and con2. When I want to access data, I am
using 2 result sets for retriving data from the tables, but getting no
result. Here is my code:
rs2_1=stmt2_1.executeQuery("select * from Requests where
Status='Released' AND LoginName='"+login+"' order by Req_No");
rs=stmt.executeQuery("select * from Requests where Status='Released'
AND LoginName='"+login+"' AND Req_No> 5500 order by Req_No");
So, rs & stmt are for latest records and rs2_1 & stmt2_1 correspond
the records from older DB.
I think, I'm forgetting some small thing but cant get it.
What do you mean "no result"? Does "next()" return false for both rs2_1 an=
If you're really trying to improve response time, you should probably be ru=
nning the two queries in separate threads ... but as you acknowledge, Acces=
s may not have as high performance as other RDBMSs. You would also see rel=
iability adv...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'...Possible to keep MS Access interface and migrate the MS Access to MS SQL Server?
Would it be possible to migrate the MS Access 2000 to MS SQL Server
My application is using MS Access 2000 as database and as user
interface such as forms. Now, I want to migrate the backend database
from MS Access 2000 to MS SQL Server 2000. However, I want to keep the
MS Access 2000 interface. Would it be possible?
If I migrate the MS Access to SQL Server, would the queries, back-end
VBA, macro, tables and forms be affected? Do I need to change the MS
Access data type to SQL server supported data type?
Which tool I can use to do the migration? Upsizing wizard or exporting...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...Is there anyone who knows how to convert MS Access tables to SAS datasets in Unix?
I've several huge mdb sitting on my red-hat linux box. I'd like to
convert them into sas or stata without taking them off the server. I
don't have a PC file server and a manual download to a PC or Mac and
then converting is not an option. My Sas is 9.1.3. Can anyone help?
...Update MS Access table from another table
This is probably very simple but I can't figure out a way to update
one table from another table.
Here is an example:
I want to update TABLEB's "grade" column from TABLEA (join by
first_name and last_name). What's wrong with following sql?
SET GRADE = (SELECT GRADE
WHERE TABLEA.LAST_NAME = TABLEB.LAST_NAME
AND TABLEA.FIRST_NAME = TABLEB.FIRST_NAME)
Also, one more question:
How do I update TABLE's &quo...Create MS/ACCESS database app for non-ms/access users
Is it possible to create an MS/ACCESS database application and package
it for users who do not have MS/ACCESS loaded in their PCs?
I was told that this is possible, but I don't know what software is
needed. Do you know? If so, please answer this post. Thanks.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Per Sue Bricker:
>Is it possible to create an MS/ACCESS database application and package
>it for users who do not have MS/ACCESS loaded in their PCs?
>I was told that this is possible, but...Accessing MS-Access from Solaris and AIX
I am using Sun JdbcOdbcDriver to access MS-Access from Java client on
Windows platform. We are in the process of migrating from Win to
Solaris and AIX platform. MS-Access will continue to reside on Win
platform. How can I access MS-Access from Java client on Solaris and
AIX? Can I still use Sun JdbcOdbcDriver?. What drivers or files do I
need on Solaris and AIX platforms? If Sun JdbcOdbcDriver for MS-Access
is not possible on these platforms, please let me know alternatives.
(I can't change database product)
on 7/12/2004 11:48 AM Vasanth Wrote:
> I am using Sun JdbcOdbcDriver to access MS-Access from Java client on
> Windows platform. We are in the process of migrating from Win to
> Solaris and AIX platform. MS-Access will continue to reside on Win
> platform. How can I access MS-Access from Java client on Solaris and
> AIX? Can I still use Sun JdbcOdbcDriver?. What drivers or files do I
> need on Solaris and AIX platforms? If Sun JdbcOdbcDriver for MS-Access
> is not possible on these platforms, please let me know alternatives.
> (I can't change database product)
You would need odbc drivers on Solaris/AIX.
Googling for odbc unix gives a good hit:
Its a good place to start your investigations from...
> I am using Sun JdbcOdbcDriver to access MS-Acce...MS Access Question for Access Gurus
I have one table called Album
another table called Song
One Album has many songs
I created an Album form that contains a Song Subform.
in the Song table I have a field id which is the primary key, and
another field called index
The song index is a number that represents the song number on the record.
For example on the Beatle's Album: Abbey Road the song indices are as
1. Come Together
3. Maxwell's Silver Hammer
4. Oh! Darling
5. Octopus's Garden
6. I Want You (She's So Heavy)
7. Here Comes the Sun
...ms access data access pages
hi my self uttam . i am working in r & d organization . friends i
need a he lp from u . if any one of u know how add two
sections(consisting of caption, header, footer ) be displayed on the
same data page in ms access 2003 or 2005.i tried to display two tables
on the data page in
tabular format but i could not do it. it is allowing to display one
table but it is not allowing to display the other table separately in
tabular format . i want more than one table in tabular format to be
dispalyed in data page separately with some text in-between tables.
plz rep...RE: How can I access data from MS Access?
Peter, I sadly admit that I was wrong. "Doesn't seem to work" is
effectivly even more useless than "doesn't work". I give up.
Years ago we used to get our FORTRAN card decks back from the DP center
with a piece of scrap paper saysing "She No Work". top that.
On 5 Feb, 19:40, "Sells, Fred" <f...@adventistcare.org> wrote:
> Years ago we used to get our FORTRAN card decks back from the DP center
> with a piece of scrap paper saysing "She No Work". top that.
I used to use a cross-compiler (targetting some obscure single-c...Access MS-ACCESS database on server from client????
I m currently developing a java based application and want to know how
can i make client access database located on the server?
"HeMan_Speaks" <Lunar20092010@gmail.com> wrote in message
>I m currently developing a java based application and want to know how
> can i make client access database located on the server?
I think you're going to have to expand a little bit more in your question
here, as is not 100% quite clear what you're trying to do.
You might want to make a little bit of a d...MATLAB command to access MS Access database
Is there a MATLAB command which gives access to a .mdb MS Access
database or do I need a special driver?
Hi Andree Ellert,
you can use activeXcontrol to interact with MS-Access database.
access = actxserver('Access.Application');
returns the handle for Access.
set(access, 'Visible', 1);
will show the opened Access window.
use get(access) and set(access) commands to find the methods
available to call.
"Andree Ellert" <email@example.com/////\\\\\> wrote in message
> Is there a MATLAB command which gives access to a .mdb MS Access
> database or do I need a special driver?
Andree Ellert wrote:
> Is there a MATLAB command which gives access to a .mdb MS Access
> database or do I need a special driver?
...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 needs to be installed for me to use MS Access
Is it required for MS Access to be installed on machines on which I
need to deploy windows app which uses MS Access as its backend. If no
then how do I access and wrie to access database?
<firstname.lastname@example.org> wrote in message
> Is it required for MS Access to be installed on machines on which I
> need to deploy windows app which uses MS Access as its backend. If no
> then how do I access and wrie to access database?
If Access, or the Access runtime (from the developer extensio...Accessing MS-Access from OpenRoad using ActiveX
I'm wanting to conect to an MS-Access MDB file from an OpenRoad program
using ActiveX. Can someone tell me the files I need to use/register for
Windows XP? Any other help or suggestions would be most appreciated.
...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" <email@example.com> 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...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...Best way to access a remote MS ACCESS database
What is the best way, via the internet, to access a remote Microsoft Access
database? I was thinking of using VPN, but I thought that I would check here
to see if there is a better way.
Do you mean remotely controlling an Access database, or linking tables over
the internet? The first is doable, the second is a recipe for disaster.
If your remote OS is Windows XP, you can use Remote Desktop (although only 1
person can access the PC at a time; this will change in the upcoming Service
Pack for XP, but that may not help you now). Otherwise, GoToMyPC offers
similar services, as does Terminal Server (a component of a Windows Server
machine), PCAnywhere, et al.
Linking to remote tables:
You will almost certainly encounter severe problems with corruption, and
your performance will almost certainly be so poor as to be unworkable. I
attempted this once, with a web server in Canada and my machine in Augusta,
GA. Even tiny data requests on a very well optimized data structure took
waaaay too long to process ... it's simply not workable, IMO.
Other alternatives would be covert the app to a web-based and place your
data on a web server. Access/Jet isn't really designed for those workloads,
but running a small site with minimal transactions and users can be done.
Otherwsie, consider switching to a more robust data platform like MySQL, SQL
CS Computer Software