Custom Form Access Query

[Neo]

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

 

[Sue Mosher [MVP]]

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

 

[Hollis D. Paul]

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]
(e-mail address removed)
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

 

[Neo]

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

 

[Sue Mosher [MVP]]

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.

 

[Neo]

Thanks Sue

Very helpful, thats sorted the problem