Shortcut from XP does not work with Access2000???

[bddewell408]

I recently built a database in Access 2002/XP, in Access 2000 format.

All machines on the server but one have Access 2002 which has Access 2000, none of the shortcuts will work with the Access 2000 program. The database will open when the file is clicked on in the Windows Explorer, but when the shortcut is used, an "OpenForm is not available" error message appears. Is this a bug of the program, I thought the two were supposed to be totally compatible.

I must admit, I have not tried this on another Access 2000 machine just as a control test, but I feel Access XP is the problem, am I right??

 

[psemianonymous]

Post the shortcut target line, so I see what the shortcut is. Describe your startup procedures.

Once I know all this, I'll be able to say for sure whether or not this is a timing issue, i.e. that the startup code is being run too soon. If it is, try moving all your startup stuff from the "Tools->Startup" to something called from the "autoexec" macro. Don't believe me? It fixed my problem with Access97.

But it may be an issue with your Access 2000 folder vs Access 2002 folder, thus posting the shortcut target line will tell me that.

So let me (or someone else, anyone who is reading this) know.

 

[PHV]

Seems like a reference problem.
When in access 2000 go to VBE (Alt-F11), menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[bddewell408]

Shortcut Target Line - "V:\Share\UOB\Overtime Tracking Database\Overtime Management System 2.0\Overtime Management System.mdb"

Start In Line - "V:\Share\UOB\Overtime Tracking Database\Overtime Management System 2.0"

I have created this form, with DB window hidden, and this form only allows data entry, the users do not know F11. Since I posted, I have tried 10 computers with Access 2002, it works, 2 computers with Access 2000, it doesn't work.

BTW, the shortcut is not to the database, it is to a particular form, I could not set the form to automatically open when the database is opened because I have several user groups, with different access levels to the database, so I have made shortcuts to the particular forms each group needs.

Thanks

 

[psemianonymous]

I'll repeat my above advice:

--
Once I know all this, I'll be able to say for sure whether or not this is a timing issue, i.e. that the startup code is being run too soon. If it is, try moving all your startup stuff from the "Tools->Startup" to something called from the "autoexec" macro. Don't believe me? It fixed my problem with Access97.
--

I think this is your problem. Also, I think you're using the wrong word for 'form'. Your shortcut doesn't open 'a specific form' at all, it just opens the .MDB file which ... I guess automatically opens a form inside the database?

If this is what I think it is, it's something like a bug, but I'm telling you how to (probably) fix it. But I could be wrong.

Have a nice day.


Pete