Custom Form Access Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Neo - 16 Jan 2004 23:58 GMT

I have designed a custom form which is filled in and then on a button
click it updates an Access database which is located on the Network.

My question is probably a silly one in that will this form work on a pc
that does not have Access installed??

Thanks in advance

N:D

------------------------------------------------

Reply to this Message

Sue Mosher [MVP] - 17 Jan 2004 14:58 GMT

If it has the Access runtime, it will work. Otherwise, no.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> I have designed a custom form which is filled in and then on a button
> click it updates an Access database which is located on the Network.
>
> My question is probably a silly one in that will this form work on a pc
> that does not have Access installed??

Reply to this Message

Hollis D. Paul - 17 Jan 2004 15:32 GMT

> My question is probably a silly one in that will this form work on a pc
> that does not have Access installed??

You need, at the least, the Access type library installed and registered.
You are invoking connection objects and other objects when you set up
the connection and do the login. On the other hand, if you are using the
ODBC mechanism to make the connection, perhaps that is all that is
necessary.

Hollis D. Paul [MVP - Outlook]
Hollis@outhousebythesound.com
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA

Reply to this Message

Neo - 19 Jan 2004 00:01 GMT

THanks for the replies

Sue, how do i install? or check if its installed, can it be part of the
form?

Sorry if these are silly questions?

THanks again

------------------------------------------------

Reply to this Message

Sue Mosher [MVP] - 19 Jan 2004 14:10 GMT

They wouldn't be silly questions if you had included enough background for
someone to know what you're talking about. Please take the time to quote the
original message so that people reading your current response can understand
what you're talking about. Otherwise, you may not receive the answer you're
looking for.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> THanks for the replies
>
[quoted text clipped - 6 lines]
>
> ------------------------------------------------

Reply to this Message

Neo - 20 Jan 2004 23:44 GMT

Thanks Sue

Very helpful, thats sorted the problem:rolleyes:

------------------------------------------------

Reply to this Message