Re: How to Passing Data to another Database

Tech-Archive recommends: Fix windows errors by optimizing your registry

Of course you can. You can set the connection String that you open to be the
database of your CC info. You can read those records just as if yoru were
reading "currentproject.connection". You can have multiple connections open
and read and write from them.

Public cnnProductConversion As ADODB.Connection (or private)
Private PathToInfo as String
Set cnnProductConversion = New ADODB.Connection

PathToInfo = CurrentProject.path & "\CCInfo.mdb" (if table is in same folder.
if not change that)
cnnProductConversion.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.
0;Data Source=" & PathToInfo
cnnProductConversion.Open

With rstb
.Open "SELECT * FROM tbl_CC_Info WHERE Contact_ID=" & CONTACTID,
cnnProductConversion, adOpenKeyset, adLockOptimistic


Go it????



One word of caution. DO NOT GET CAUGHT storing a customers credit card
information that is outside the Consumer Protection Act of (i think 2001..
you can google it). There are specific requirements that must be followed
and if they are not there is a fine of $500,000 per incident.


mattc66 wrote:
I am working on a database to keep customer credit card information - until
the order is processed. Obviously I want it password protect which I can do.
However I am going to keep it seperate from my Order Entry Database. So my
plan is to have a button or event that when credit card is the payment method
the system would open the credit card database and prompt for password and
then the form would open as a new record. What I'd like todo however is pass
the customer account# and the Order# along so that it populated that info in
the credit card database, so that when our AR person could process the credit
card payment and be able to look it up based on the order#.

So the question is - can I pass that type of info from one database to
another? If so, what would be the code?

Thanks for anyone's input. I am also open to another suggestion on how I may
better handle this issue.

Matt


--
DS

Message posted via http://www.accessmonster.com

.

Quantcast