Recent content by bbarr

Are there any tools out there that I can use to install all the requisite .dll's used in an .mdb file that I created. Right now I have an app with a coupld of .dll's that I manually register on the user's computer ... It hasn't been much of a problem as the number of users has been quite small...

I found the answer ... looking at some related code. you have to use: Set dbs = OpenDatabase(pName)

Thanks. However, I'm getting a type mismatch error. I have the path/name of the file set to a string variable (pName) and therefore rewrote Set dbs = "C:\db2.mdb" to Set dbs = pName and this is giving me the error.

I'm using Access 2000. I'm trying to set a connection to another .mdb file and programmatically set links to all tables in that file. If the second .mdb file is "d2.mdb" and located in "C:\" then how do I access the TableDefs collection of this database?

Thanks again!

do you mean that if i delete something in position 5 of a collection then whatever is in position 6 moves to position 5 but the counter moves to position 6 which now has a different value?

forgot to say thanks!

It worked! but why?

I created the following code to delete all linked tables in my database (Access 200): -------------------------------------------------------- Dim tbl As TableDef Dim dbs As Database Set dbs = CurrentDb For Each tbl In dbs.TableDefs If Len(tbl.Connect) > 0 Then ' Is a linked...

I've been taking classes at Stevens Institute of Technology (webcampus.stevens.edu for the online grad level courses). I've taken both on and off line courses (math and comp sci). The online school was rated the best by Forbes. prior to this I spent 1 1/2 years part time working on a diploma...

AnanthaP, thanks for the feedback. Already been to India on holiday. In some cases business is outside the power of pols to control, but they can still do a lot to mess it up. on a somewhat related note, france has declared the 35-hour work week to be a disaster...

Hi Dimandja, I haven't heard anything specific to the effects on outsourcing, just the general effects on the stock market and the overall unease (not sure if this is the right word) of investors' reponse to the results.

If you haven't been paying attention, you may have missed the fact that there have been some major developments in India during the past few days .... 1. Indians voted the current PM out of office; while a new gov't has not yet been formed, it will most likely be headed by the leftward leaning...

Is there a way to programmatically control how an Access 2000 app starts up and is there an event for it when it shuts down?

The app is for internal use. The problem isn't really the distribution, but more a matter of there being a lot of computations going on for which data structures would make it easier to do ... I've been doing some research (I googled "Why Use Data Structures") and have the following so far: 1...