Hi, Roger.
With
access2003, you get only one process, unless you create an MDE, then
you get two (or more processes) running
If you're willing to accept the defaults, then yes, that's what you get.
Double-clicking on the name of the database file in Windows Explorer tells
the operating system, "I'm in too big of a hurry or I'm too lazy to give any
instructions, so just open this file with whatever command line assignments
someone else set up for me on this computer," unless of course you,
yourself, set up the command line parameters for the default file action.
To change this default behavior, you can change the default action for any
specific registered file types (and please note that I'm _not_ recommending
this, only pointing it out as one method to avoid the behavior you're
witnessing), or use a Windows shortcut that specifically names the complete
paths to the executable file and the file to be opened (with or without
assigning command line parameters). Double-click on the same Windows
shortcut twice, and you'll launch two separate processes that open the same
database file.
The reason the behaviors are different in Access 97 and Access 2003 is
because Microsoft wasn't as "helpful" in automating processes for the user
back when Access 97 was designed.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs:
www.DataDevilDog.BlogSpot.com,
www.DatabaseTips.BlogSpot.com http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.