T
trucker2go
I have some .MDB files I need to be able to read... What viewer ( like PP
Viewer ) can i use just to be able to read these files ?
Viewer ) can i use just to be able to read these files ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J. Steele
There isn't an Access viewer per se.
If all you're interested in is the data in the MDB file, you can attach to
it using any ODBC-compliant client (Excel, Word, etc.)
To use application components like forms or reports, or to use the VBA code
(or macros) in the MDB file, there does exist a run-time version of Access,
but you can just download it and use it to run the MDB file.
If all you're interested in is the data in the MDB file, you can attach to
it using any ODBC-compliant client (Excel, Word, etc.)
To use application components like forms or reports, or to use the VBA code
(or macros) in the MDB file, there does exist a run-time version of Access,
but you can just download it and use it to run the MDB file.
T
trucker2go
How or where do I get this Viewer or Reader at ?
Douglas J. Steele said:There isn't an Access viewer per se.
If all you're interested in is the data in the MDB file, you can attach to
it using any ODBC-compliant client (Excel, Word, etc.)
To use application components like forms or reports, or to use the VBA code
(or macros) in the MDB file, there does exist a run-time version of Access,
but you can just download it and use it to run the MDB file.
D
Douglas J. Steele
Sorry, that was a typo. It should have said "but you cannot just download it
and use it to run the MDB file."
and use it to run the MDB file."
S
Steve
I might be able to build a viewer for you. Contact me at my email address
below if you are interested.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
below if you are interested.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
A
Albert D. Kallal
Just use excel.....
you can also use a windows script, as the ability to read a mdb file is
built into every copy of windows.
Set dbeng = CreateObject("DAO.DBEngine.36")
strMdbFile = "C:\Documents and Settings\Albert\My
Documents\Access\ScriptExample\MultiSelect.mdb"
Set db = dbeng.OpenDatabase(strMdbFile)
strQuery = "select * from contacts"
Set rs = db.OpenRecordset(strQuery)
rs.movefirst
If rs.EOF = true Then
quit
End If
strTextOut = "C:\t5.txt"
set fs = Wscript.CreateObject("Scripting.FileSystemObject")
Set ts = fs.OpenTextFile(strTextOut, 2, True)
' 2 = write, 1 = read
do while rs.EOF = false
strOutText = rs("LastName")
ts.Writeline strOutText
rs.movenext
loop
ts.close
rs.close
The above is a windows script, and will run without installing any software.
However, I would use excel, as then you don't need to write any code to read
the mdb file.
You can also have the person sending you the file export the data as a text
file, or even html...or even a pdf.
So, use Excel, or have the person send you the data in a format that you can
read. If you nothing at all, then you have to resort to a script like the
above.
you can also use a windows script, as the ability to read a mdb file is
built into every copy of windows.
Set dbeng = CreateObject("DAO.DBEngine.36")
strMdbFile = "C:\Documents and Settings\Albert\My
Documents\Access\ScriptExample\MultiSelect.mdb"
Set db = dbeng.OpenDatabase(strMdbFile)
strQuery = "select * from contacts"
Set rs = db.OpenRecordset(strQuery)
rs.movefirst
If rs.EOF = true Then
quit
End If
strTextOut = "C:\t5.txt"
set fs = Wscript.CreateObject("Scripting.FileSystemObject")
Set ts = fs.OpenTextFile(strTextOut, 2, True)
' 2 = write, 1 = read
do while rs.EOF = false
strOutText = rs("LastName")
ts.Writeline strOutText
rs.movenext
loop
ts.close
rs.close
The above is a windows script, and will run without installing any software.
However, I would use excel, as then you don't need to write any code to read
the mdb file.
You can also have the person sending you the file export the data as a text
file, or even html...or even a pdf.
So, use Excel, or have the person send you the data in a format that you can
read. If you nothing at all, then you have to resort to a script like the
above.
J
John W. Vinson
I have some .MDB files I need to be able to read... What viewer ( like PP
Viewer ) can i use just to be able to read these files ?
Just note that a .MDB file is *NOT* like a document or a spreadsheet. It's a
container for multiple Tables, Queries (which organize the data in tables),
Forms (which display data onscreen), and Reports (which let you print data to
paper). You can use Excel or other ODBC-compatible programs to view the data
stored in Tables - but that isn't really "the database".
A lot depends on what you are trying to accomplish with what's in the
database.
John W. Vinson [MVP]
T
Tony Toews [MVP]
Steve said:I might be able to build a viewer for you. Contact me at my email address
below if you are interested.
Note that Steve is well known for soliciting billable work on these
forums. I'd use caution in dealing with his paid services.
His technical answers in these forums are good.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
S
Steve
Thanks, Tony! I appreciate the compliment!
J
John Marshall, MVP
Do you go through life with blinders on?
Tony was warning about your abuse of the newsgroups and you only latched on
to his one compliment. Are you planning on only accepting his compliment and
ignore his warning and continue to solicit?
John... Visio MVP
Tony was warning about your abuse of the newsgroups and you only latched on
to his one compliment. Are you planning on only accepting his compliment and
ignore his warning and continue to solicit?
John... Visio MVP
J
John Marshall, MVP
Tony, I would qualify that to be SOME of his technical answers are good. He
has posted just as many wrong answers, answers with no substance and
outright solicitations.
Ok steve, now turn this around so that it appears that I am supporting your
abusive behaviour.
John... Visio MVP
has posted just as many wrong answers, answers with no substance and
outright solicitations.
Ok steve, now turn this around so that it appears that I am supporting your
abusive behaviour.
John... Visio MVP
K
Keith Wilby
Steve said:Thanks, Tony! I appreciate the compliment!
Hey Steve! Appreciate this!
http://home.tiscali.nl/arracom/whoissteve.html
!
!!!
!!
S
Spurious Response
You may not want to say it, but I will.
If he was so able to "write" such a useable "viewer", he would have
done so, and would have been soliciting that, and if it were a good
product, folks would buy it.
Supplying a partial technical opinion, and including a solicitation is
NOT a "technical answer". It is not an "answer" at all, unless the OP
actually gets a solution to his problem provided.
This Steve turkey is not into that. Even though such solicitations are
against the group's policy, he still insists on doing so, and for that I
would shun his every move here. He never shows any remorse or acts as if
his actions are in any way incorrect for the forum.
In other words... he is a total piece of shit.
If he was so able to "write" such a useable "viewer", he would have
done so, and would have been soliciting that, and if it were a good
product, folks would buy it.
Supplying a partial technical opinion, and including a solicitation is
NOT a "technical answer". It is not an "answer" at all, unless the OP
actually gets a solution to his problem provided.
This Steve turkey is not into that. Even though such solicitations are
against the group's policy, he still insists on doing so, and for that I
would shun his every move here. He never shows any remorse or acts as if
his actions are in any way incorrect for the forum.
In other words... he is a total piece of shit.
M
missinglinq via AccessMonster.com
I agree with John Marshall; some of Steve's answers are so off the wall that
I've thought he could only be giving them in hopes of frustrating the OP to
the point where they'd think they could never solve their problems, and thus
would be more amenable to using his services!
Of course, my favorites Stevie posts are those between "Steve" of PC
Datasheet and the poster "PC Datasheet" who signs his posts Steve! Amazingly,
he always solves the problems posted!
I've thought he could only be giving them in hopes of frustrating the OP to
the point where they'd think they could never solve their problems, and thus
would be more amenable to using his services!
Of course, my favorites Stevie posts are those between "Steve" of PC
Datasheet and the poster "PC Datasheet" who signs his posts Steve! Amazingly,
he always solves the problems posted!
T
trucker2go
I have been sent some Files from Church , with Church address and telephone
numbers and such , which as part of my job , i need to send out occasional
E-mails to these other Churches , with information , almost like a news
letter... But not exactly... LOL
I just need to be able to read the Info , to be able to contact these other
Churches...
I don't have Office , or any other program that will open these files...
Any suggestions ? , I cannot afford to buy Office Or MS access , At this
time...
numbers and such , which as part of my job , i need to send out occasional
E-mails to these other Churches , with information , almost like a news
letter... But not exactly... LOL
I just need to be able to read the Info , to be able to contact these other
Churches...
I don't have Office , or any other program that will open these files...
Any suggestions ? , I cannot afford to buy Office Or MS access , At this
time...
J
John W. Vinson
I have been sent some Files from Church , with Church address and telephone
numbers and such , which as part of my job , i need to send out occasional
E-mails to these other Churches , with information , almost like a news
letter... But not exactly... LOL
I just need to be able to read the Info , to be able to contact these other
Churches...
I don't have Office , or any other program that will open these files...
Any suggestions ? , I cannot afford to buy Office Or MS access , At this
time...
You'll need to either persuade the church to export the files from Excel into
comma-separated text files (which any computer can read), or get someone who
has Access, or VB, or Excel, or some other JET-compatible program to do so for
you.
If you can't get anyone local to do it, I'd be willing (with the permission of
the church) to convert the data. What software do you use to send out
emails???
John W. Vinson [MVP]
W
Wintech via AccessMonster.com
I have a script written in AutoIt (http://www.autoitscript.com) that will do
what you want.
It uses odbc to connect to the .mdb file so you can view tables & data within.
I can forward it on to you if you like.
what you want.
It uses odbc to connect to the .mdb file so you can view tables & data within.
I can forward it on to you if you like.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.