Access 2002-2003 question (To mde or not? To install Access or not?)



I have a client on which I need to run Access. At a minimum I need to run a .mde. (This client is
only being used to allow an app on this client to gain access to data on our AS/400, via DB2 Connect
- PE (ODBC). This app will talk to the .mdX file on this client, which will look at only one linked
table on the AS/400. (This...(gulp)...*should* work.)

Access is not installed on this client. When I tried to run a .mdb, Windows wanted to install
Access. Hmmm... So I figured that what I needed was a .mde file. So I created one. After I moved
my .mde file to this client, when I tried to run this .mde, Windows wanted to...once again...install
MS Access. So...

Can anyone enlighten me as to just what the heck I need to make this work? This .mdb/.mde file only
needs to contain a link to just ONE TABLE (as far as I know). This link will be via ODBC (IBM DB2
Connect - Personal Edition) to our DB2 database on our AS/400.

-----

This is how I gain access to my data from my PC (my daily client). But unlike this new client PC,
my daily client PC *does* have MS Access installed. I don't *want* to install Access on this new
client PC...IF I DON'T HAVE TO. But will if I must.

Any help anyone can provide would be most appreciated. I thank you in advance...

Tom
.



Relevant Pages

  • Re: DBD::DB2 where to get a client library
    ... I have managed to install ... not application development client) not a problem since we have them on the ... doesnot have rpm. ... you might want to check out the DB2 HOWTO ...
    (perl.dbi.users)
  • Re: How to stop library mde being reused
    ... > I found out that another developer discovered it while doing some ... > copied it to use with her databases. ... > database and is working out how to use the library mde from that. ... Your contract with the client has to control it. ...
    (comp.databases.ms-access)
  • Re: 5 access 2000 users and 1 AccessXP user
    ... I do have both the MDB (on a file server running Win2K server) and the ... MDE. ... I have fixed the problem for an XP Client that is ... Would it help if I zipped up both the mdb and the mde and shipped to you via ...
    (microsoft.public.access.conversion)
  • Re: Database Options - Any other settings I should adjust?
    ... If you've got the MDB on the other end already, ... What kind of security do you think an MDE gets you? ... client is using there own IT group to maintain and support the ...
    (comp.databases.ms-access)
  • Re: Moving ADO routine back to DAO
    ... The recompile of the MDE on Client PC's is a good suggestion. ... > non-trivial app, though. ... >> 110: Dim errloop As Error ...
    (microsoft.public.access.modulesdaovba)