Solved

Encode magnetic stripe using Microsoft Access 2003

Posted on 2008-09-30
4
544 Views
Last Modified: 2013-11-28
I have a DATACARD SP75+ (Card Printer) and i created my own Access 2003 Database to print my cards. Now i need to encode the magnetic stripe of the card through my database.
Please help.

Thanks
0
Comment
Question by:viroz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 84
ID: 22603827
Sounds to me like you need to contact the vendor in this regard. While I'm sure you are supplied a printer driver, and Access can use that driver, I'm sure you'll need to send the "report" to that printer in a particular format, and your best source of information would be the manufacturer:

http://www.datacard.com/products/products.jhtml?category=Summary&contentId=15542778ZYRs6Y0Smm1

Here's the SDK for that printer:
http://www.datacard.com/downloads/technical_support.jhtml?modelName=SP75+Plus
0
 
LVL 1

Author Comment

by:viroz
ID: 22603852
I know i just contacted the vendor to tell me which escape characters to use for sending data on magnetic stripe tracks. I just want the way to send these characters through microsoft access 2003.

Thanks
0
 
LVL 84
ID: 22603871
This would depend on what your printer expects, which is what the SDK would tell you. In many cases with items like your printer, you cannot directly "print" to the printer but must instead use the SDK to send that information. Your vendor should be able to give you sample code to use, although they may not provide this to you for Access .... just use the code for VB6 and you should be able to port that directly.
0
 
LVL 1

Accepted Solution

by:
viroz earned 0 total points
ID: 22604739
Finally found the solution. I just put a textbox and choose as font the Track 1 Magnetic Stripe font.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question