how do i connect to a table in ms access via form from notes?

[rajeevturlapati]

how do i connect to a table in ms access via form from notes?
Here i have a form whose fields are copied from the entries of a table from MS access ? Please let me know how can i do it??

bhelhyd

 

[lespaul]

Take a look at Thread245-404298 it has some code posted for connecting to an outside Database.

You need to be careful though. If you have a form that is populated by data from a database and then you save the form, you now have a DOCUMENT in the Notes Database that matches the record in the Access Database. Be sure you realize that the document you see in Notes is NOT THE ACCESS RECORD!

If you would like some more information about this, feel free to contact me.

HTH


Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!

 

[rajeevturlapati]

OK,
I want to how can i connect via DECS to a table in MS Access,i.e i want to read the entries in the Access table to the fields in the form? and how?

 

[lespaul]

My best guess would be when the user intiates the process (press a button?), create a new document, set the form to use, run your query and populate the document fields with the information, set the document to the NotesUIDocument in the workspace for display and then close the document with out saving.

There may be a different way, but I'm unaware of it. You might check the forum at

http://www.notes.net

Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!