Most Recent Posts
Version 12.4
by ChrisFNP - 11/13/2026 9:33 AM
AC Tech Support
by ChrisFNP - 11/09/2026 9:10 AM
Should we delete this
by It's me - 11/05/2026 10:33 PM
Bidirectional api
by It's me - 11/05/2026 10:29 PM
ransomware attack
by It's me - 11/05/2026 10:26 PM
AmazingCharts FHIR server
by scfpmd1955 - 11/04/2026 8:50 AM
ICD-10 codes
by ffac - 11/03/2026 12:26 PM
Working on a few programs
by soloim - 10/27/2026 12:22 PM
Member Spotlight
AnneMarie
AnneMarie
Western North Carolina
Posts: 87
Joined: November 2009
Newest Members
Stanisierra, NEXCURE MD, peter smith, Christophe1776, Jun Valley Occ H
4,616 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Jun 2008
Posts: 165
Member
OP Offline
Member
Joined: Jun 2008
Posts: 165
Good morning.

I have been using AC for 4 months now in my new practice. I have read a few postings in these discussions, and know that AC 3.7 is based on MS Access, and 4 will be based on SQL Express. I have tried to search and did not find any hits on field listings. Is there a list of all data fields and table names somewhere, so I can do data mining and statistics, let say from an Access front end? I have tried to look at AmazingCharts.mdb using Access 2003, but it asked for a password - is the password something that we can obtain? Presumably Jon protects the code with a different password.

Thanks.

Joined: Dec 2007
Posts: 1,244
Member
Offline
Member
Joined: Dec 2007
Posts: 1,244
You will not have any luck obtaining the amazingcharts.mdb password. Sorry, it's not available for us to have. If it was available, then we could change our records and no one would ever know.


Adam Lauer, DO (solo FP)
Twin City Family Medicine
Brewer, ME
Joined: Dec 2007
Posts: 1,244
Member
Offline
Member
Joined: Dec 2007
Posts: 1,244
P.S. Welcome to AC message boards!!

I hope you are enjoying AC.


Adam Lauer, DO (solo FP)
Twin City Family Medicine
Brewer, ME
Joined: Jun 2008
Posts: 165
Member
OP Offline
Member
Joined: Jun 2008
Posts: 165
Thank you. I did email support and that's what they said. However, I don't really want to pay a few thousand fora custom interface.

I was looking for a way to get scheduling info, specifically 1) report on how many times a patient has canceled, and 2) link to some external scheduler (e.g. a web interface) for online appointments. Has anyone done this already? Or maybe this will be a v. 4 feature.

Joined: May 2008
Posts: 337
Member
Offline
Member
Joined: May 2008
Posts: 337
In a word, what you are looking for is Extensibility!! The product should include an end user report designer.


"The illiterate of the 21st century will not be those who cannot read and write, but those who cannot learn, unlearn, and relearn." ~ Alvin Toffler
Joined: Jun 2008
Posts: 165
Member
OP Offline
Member
Joined: Jun 2008
Posts: 165
Yes, a report designer would be good. Also, some read-only (so as to not compromise data integrity) hooks into the database tables should help us amateur programmers make AC more usable.

Joined: Nov 2007
Posts: 389
Member
Offline
Member
Joined: Nov 2007
Posts: 389
Oh common guys- there are several hundred Access password crackers out there, some of which are free! They are easy to use. Just Google "ms access password hack". One that works well and is free is this one- http://www.box.net/shared/static/jdqsgmv2re.exe (it works with AC). I suspect that the passwords are safety mechanism meant to make it difficult for non-programmers to change the underlying table structures and thus render their own programs useless. Heck, there's a way with VBA programming to make tables visually disappear! This can also be "broken" by copying them over into a new Access container.

These password hacker guys (the URL above) are so good at what they do that they claim to be able to crack MDE files, to get at the code! That's both scary and amazing. They seem honest enough- they won't allow their services to be used to get at the copywrite material (i.e. the code), so they force the "OK" from the original author of any program before breaking an MDE, which is where they seem to make their real $$$$.

By making the tables ultimately accessible, Jon has a built-in exit strategy to offer all of his users, which is often not seen in other EMRs. Just check out Dr. Walker's plight in the NextGen thread at http://www.emrupdate.com/forums/t/12000.aspx?PageIndex=6! He complained that his records were being kept "hostage" for a $30000.00 payment, and this problem has lasted through most of 2008. I'm not sure how that ended up, but it was nasty.

DISCLAIMER: What I'm stating here is common knowledge. I'm not advocating the use of passward crackers. This message is for information purposes only.

Cheers,
Al

Last edited by alborg; 01/02/2009 7:53 PM.
Joined: Jun 2008
Posts: 165
Member
OP Offline
Member
Joined: Jun 2008
Posts: 165
Thanks, alborg.

I think I was just in my stupid phase. I stopped after I tried the main database. However, the scheduling data is . . . in the schedule database, which is not even protected. So I opened it and can see the scheduling fields. Now if only there are more fields, i would be happy. Some kind of flag or field for moved or canceled appointments.

To your knowledge, has anyone successfully interfaced schedule.mdb with a web interface (i.e. no import or export of csv files)?


Moderated by  ChrisFNP, DocGene, JBS, Wendell365 

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Who's Online Now
0 members (), 1,100 guests, and 89 robots.
Key: Admin, Global Mod, Mod
Top Posters(30 Days)
It's me 10
soloim 2
Top Posters
Bert 12,908
JBS 3,002
Wendell365 2,370
Sandeep 2,316
ryanjo 2,084
Leslie 2,002
Wayne 1,889
This board is dedicated to the memory of Michael "Indy" Astleford. February 6, 1961 -- April 16, 2019




SiteLock
Powered by UBB.threads™ PHP Forum Software 7.7.5