Opening .ldb and .accdb file types

[davidhall]

I need to open a couple access files, really the one with the .ldb extention. I've seen that you should be able to with "workbench.exe" but I believe that article is outdated.

I'm running Windows 7, any help would be appreciated.

 

[james_lankford]

.ldb is for Access only.
It shows the database is in use.
Its created when the .mdb is opened, and it is deleted when the .mdb is closed.
Why do you need to open it?

 

[SydneyGeek]

As James said you don't normally open the .ldb file as such. It keeps track of who is in the database, so it can provide useful documentation.

If you're interested in the Workbench go to Garry Robinson's site. It gives you a whole bunch of useful functions for working with your databases, including being able to choose which version of Access to use with a database (when you install multiple Office versions).

Denis

 

[davidhall]

Well, I guess I need to explain what I am trying to accomplish.

I use a quoting program that houses information about different variables for a product. When I need to generate a new quote, I manually input about 10 variables about my customer along with the variables about the product and then generate a quote for them. When I save this quote, I'm pretty sure it is saved in an access file somewhere but I'm not 100% on that.

Since there isn't an option within this quoting software to download to excel the information on the quote (customer information/ product information/ pricing etc.), my thoughts were to somehow get into the access file or wherever this data is saved after I generate a quote and export it to excel. I might be going about this in the wrong way but access is fairly new to me.

The software itself doesn't allow any copy and paste features from the software to excel; otherwise, I would simply do that. It is somewhat limited and I'm trying to find a useful way I can extract this data so I can feed it into other excel documents that have the same information.

I'm not sure if the software was intentionally designed to prevent users from doing this or perhaps it just wasn't a feature that was integrated with the software. Within the software interface, it simply looks like a userform created in excel.

Do you guys have any suggestions?

 

[SydneyGeek]

The quote is a report. It won't be saved as such, because the report is basically a template that takes data from a query or table and presents it for printing. Many reports also group and sort that data, to give subtotals and other summaries.
You will need to export the data, using the form as your basis, because by the sound of it most of the calculations are done there before the report is created. Do you have the option of designing forms and reports, or has that been locked down? If it has your other option would be to print a PDF and use software to extract that into Excel.

Denis

 

[davidhall]

Unfortunately I don't have the option to create forms and reports within the software. Do you know of any programs that specialize in extracting data from pdfs to excel?

 

[SydneyGeek]

Nitro has a good name. They have a free online service (http://www.pdftoexcelonline.com/) and there are links there to a more powerful desktop version.

Denis