Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Encode magnetic stripe using Microsoft Access 2003

Posted on 2008-09-30
4
Medium Priority
?
565 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
  • 2
  • 2
4 Comments
 
LVL 85
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 85
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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

885 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