Locating back end databases

[paulreed]

I have tried the example db in the 'sample databases' for browsing to back end databases (by AccessKurzo), as it is exactly what I need, but can’t get it to work!

If I load the test file (2K), the connection form automatically loads, and I click on browse.

That is followed by a box asking me to browse to the directory where the file is located, but by acknowledging that message, I get the message box ‘There is no object in this control’.

Any ideas?

 

[spacepro]

Works for me.

Try re-downloading the file.

The references that were set in my db are:

Visual Basic for Applications
Microsoft Access 10.0 Object Library
Microsoft Common Dialog Control 6.0
Microsoft DAO 3.6 Object Library
Ole Automation
Microsoft Visual Basic for Applications Extensibility 5.3

Andy

 

[paulreed]

Works for me.

Try re-downloading the file.

The references that were set in my db are:

Visual Basic for Applications
Microsoft Access 10.0 Object Library
Microsoft Common Dialog Control 6.0
Microsoft DAO 3.6 Object Library
Ole Automation
Microsoft Visual Basic for Applications Extensibility 5.3

Andy

Andy, I have re-downloaded the files to both computers, both running XP, one on Access 97 the other Access 2002 - still no joy on either.
I notice that you mention 'references set on your db', I have no idea what these are, except when I eventually found mine, I see that I have the entry 'MISSING - Microsoft Common Dialogue Control 6.0 (SP3)' and a reference to Comdlg32.ocx in my list on both computers.
Could this be the trouble, and why are they missing on my computer and not yours? I really would like to get this working.

Thanks

Paul Reed

 

[spacepro]

Hi Paul,

Yes it is the references. It sounds like the sample db is using a common dialog control that you don't have on your system. This could be due to an earlier version of access that the db was created.

Ok, check the version of comdlg32.dll on your system. Try downloading an update from microsoft.


If not select the common dialog control that you do have in the list, then open frmNewDataFile and select the dialog control in design view (xDialog) and delete it then using the toolbox select Microsoft Dialog control from the more controls button on the toolbox, then change it's name to XDialog and then try re-running the db.

Hope this helps

Andy

 

[paulreed]

Hi Paul,

Yes it is the references. It sounds like the sample db is using a common dialog control that you don't have on your system. This could be due to an earlier version of access that the db was created.

Ok, check the version of comdlg32.dll on your system. Try downloading an update from microsoft.


If not select the common dialog control that you do have in the list, then open frmNewDataFile and select the dialog control in design view (xDialog) and delete it then using the toolbox select Microsoft Dialog control from the more controls button on the toolbox, then change it's name to XDialog and then try re-running the db.

Hope this helps

Andy

I have even tried the NT computers at work, I can't beleive that I'm the only one who can't run this db!!!

I have downloaded Comdlg.dll and that does not recify the problem.

When I deleted the xdialogue from frmNewDataFile, I tried to add 'Microsoft Common Dialog Control 6.0' from the toolbox, I got the message 'you don't have the licence required to use this active X control' and it would not let me add it to the form.

Is it me, or is anyone else unable to run this database?

 

[paulreed]

I have now managed to get the 2K version running (after Taking spacepro's advice, and a email from AccessKurzo - thanks guys).
I deselected and relocated comdlg32.ocx, adding it to the references, now it works fine.
Going to do the same with Access 97 tomorrow.

Thanks Again