Clicking on the file's name will simply download the file.
However, clicking on the View link will display
the database's available tables and queries in your browser.
This makes it much easier to share
live information over the web. As soon as the data is updated
in Access, the "live" data is
available over the web to users sharing the database. BadBlue's
integrated transcoding of Access data makes it perfect for
mobile, wireless, data rollup and other applications where
timely access to information is critical.
What other file formats are supported?
BadBlue can instantly transcode Excel
and Word files into HTML live.
Can I use Access transcoding even if I don't have Access?
Yes. However, if you have problems viewing Access data, you may need
to download Microsoft's free
MDAC library
(Data Access Components). This library contains the ADO
components necessary to use BadBlue's database transcoding features.
Be sure to read the
Installing MDAC Q&A
for complete information on installing MDAC.
How do I choose a table or query to view?
After clicking the View link next to a shared Access
database (MDB file), a menu of available tables and queries
is presented. Click on the lefthand link to page through
transcoded HTML result sets. Or click on the CSV link
to retrieve the entire result set in comma-separated-values (CSV)
format (Warning: large result sets may require significant
processing time to complete).
What does the result set look like in a browser?
The small buttons at right are used to navigate through the
result set. The buttons represent top of file, previous page,
next page and last page, respectively.
The Rows indicator lets you specify the number of rows to
display per page. You can also use the Go to page control
to move directly to any page.
How can other users browse directly to my PC to search it?
See the BadBlue General Use FAQ which
describes how to find your IP address or set up a domain name
so that other users can surf directly to your PC, search it and
download or display files.
Why do I get a login prompt when I try to view the database data?
First of all, make sure you have the proper version of Microsoft MDAC
installed on your PC (see above for details). If you are using Access 2000
or higher, you will need to edit your EXT.INI file (the BadBlue configuration
file which is found in the default install folder - usually
c:\program files\badblue\pe or \ee).
Open the EXT.INI file in Notepad and add the following lines to the file:
[SERVICES]
MDBPROVIDER=Microsoft.Jet.OLEDB.4.0
This will allow BadBlue to utilize the Access 2000 Jet database engine provider for ADO.
If a SERVICES section already exists in the EXT.INI
file, don't create a new SERVICES section, simply add the
MDBPROVIDER statement at the end of the existing section.
|
Does the free BadBlue Personal Edition support Access transcoding?
Yes. And BadBlue Enterprise Edition
supports unlimited viewing of Access databases.
Can I prevent Access databases from being downloaded and allow them only to be viewed?
Yes. From the BadBlue main menu, use the Setup search tab menu
and scroll to the bottom of the page. Change the
Live View Only setting to Yes and then press the
Update button. Once you exit and restart BadBlue,
authorized users searching your machine will only be allowed to
choose the Live View option; they will not be permitted
to download Office files directly.
Can I password protect my files and/or data?
Yes. See the FAQ on how to
password protect
your files and data.
Can I generate a 'permanent' link (URL) to the "live view" of my database?
Yes. To generate a permanent, static link (URL) to a live view of your database,
search for it normally and then click on the Live View option to
generate the normal, dynamic link. For example, a dynamic link that
results from a search and a live-view might read:
http://.../ext.dll?MfcISAPICommand=LoadPage&page=mdb.htx&a0=/get/153/filename.mdb&a1=...
To turn this link into a permanent URL,
you can replace the search index ("153", in the example above) with
the path number ("path9", in the example below).
The path-number can be determined by reading the EXT.INI file.
http://.../ext.dll?MfcISAPICommand=LoadPage&page=mdb.htx&a0=/get/path9/filename.mdb&a1=...
Using the path-number instead of a search index will generate a completely
static link that will never change unless you change the EXT.INI file.
|
My MDB file needs a user-name and password to open - how is this specified?
You will need to edit your EXT.INI file (the BadBlue configuration
file which is found in the default install folder - usually
c:\program files\badblue\pe or \ee).
Open the EXT.INI file in Notepad and add the following lines to the file:
[SERVICES]
MDBUSER=joec
MDBPASSWORD=secret
where joec represents the correct user-name
and secret represents the correct password for the
MDB file.
If a SERVICES section already exists in the EXT.INI
file, don't create a new SERVICES section, simply add the
MDBUSER and MDBPASSWORD statements at the end of the existing section.
