Home
Products
News
Help Center
Download
About BadBlue





 
Access Sharing Frequently Asked Questions
BadBlue Help Center     BadBlue Discussion     Email support
 

How do I share Microsoft Access databases over the web?

Easy. From the Manage tab, use the Setup search tab option to specify one or more Access databases for which users can search. Or use the Setup folders tab tab to set up a folder (under the Folders tab) that contains an Access database (MDB file). Now when users search for databases or explore the Folders tab, they will see results like this:

invoices.mdb   (View)
sales-funnel.mdb   (View)
mlb2000.mdb   (View)


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.

 
Get BadBlue Enterprise Edition via electronic distribution today from our partner SWreg: View the full feature list: EE supports uploads, NT user/group security and much more!
 
BadBlue Help Center     BadBlue Discussion     Email support