Multiple Instances of Access
- Thread starter manojab
- Start date
- Local time
- Today, 12:16
- Joined
- Feb 28, 2001
- Messages
- 31,051
I've had more than one DB open at the same time from the same terminal, both DBs being local. I've had one local and one remote DB open at the same time, too.
If you had the means (and the patience; harder to find sometimes...), you would note that in your Access app, you might have more than one member of the Workspaces collection. Each such member represents one instance of Access having been opened.
Where you really run into trouble with this is MEMORY - because Access has so many data structures to build within itself to remember where everything is... and if you have limited swap space and limited physical memory (and therefore, also limited VIRTUAL memory, far more important), you might not get multiple instances up an' runnin'
If you open multiple instances of the SAME DB - you also run into a locking problem because, despite being the same user, you are running two different instances. Unless you handle the locks exactly right, you will get locking violations against yourself! (Heck, don't even need two instances of Access open to do that ... it also happens if you have a bound form with VBA code acting on the recordset of the form and forget to clone the recordset...)
If you had the means (and the patience; harder to find sometimes...), you would note that in your Access app, you might have more than one member of the Workspaces collection. Each such member represents one instance of Access having been opened.
Where you really run into trouble with this is MEMORY - because Access has so many data structures to build within itself to remember where everything is... and if you have limited swap space and limited physical memory (and therefore, also limited VIRTUAL memory, far more important), you might not get multiple instances up an' runnin'
If you open multiple instances of the SAME DB - you also run into a locking problem because, despite being the same user, you are running two different instances. Unless you handle the locks exactly right, you will get locking violations against yourself! (Heck, don't even need two instances of Access open to do that ... it also happens if you have a bound form with VBA code acting on the recordset of the form and forget to clone the recordset...)
Thanx Doc Man.. for ur reply..here's what i'm havin a problem with...
I'm able to open an mde on a machine that has access2000 runtime..when i try to execute the following piece of code i get an error
Set myApp = New Access.application
myApp.OpenCurrentDatabase("Path")
The error is as follows
"License information for this component not found. You do not have an appropriate license to use this functionality in the design environment"
When i try & run the same code on a developer machine with full blown access loaded on it.. it works like a champ...
Any suggestions??
thanx for ur help in advance
I'm able to open an mde on a machine that has access2000 runtime..when i try to execute the following piece of code i get an error
Set myApp = New Access.application
myApp.OpenCurrentDatabase("Path")
The error is as follows
"License information for this component not found. You do not have an appropriate license to use this functionality in the design environment"
When i try & run the same code on a developer machine with full blown access loaded on it.. it works like a champ...
Any suggestions??
thanx for ur help in advance
- Local time
- Today, 12:16
- Joined
- Feb 28, 2001
- Messages
- 31,051
This might be a Pat question
Sorry, never tried that one before. Maybe Pat?
Sorry, never tried that one before. Maybe Pat?
- Local time
- Today, 12:16
- Joined
- Feb 28, 2001
- Messages
- 31,051
Her. Pat Hartman.
Solution!!!
Hi Doc Man, I found the soultion to my problem in this Microsoft Knowledge Base article
http://support.microsoft.com/default.aspx?scid=kb;en-us;210111
thanx guys
Manoj
Hi Doc Man, I found the soultion to my problem in this Microsoft Knowledge Base article
http://support.microsoft.com/default.aspx?scid=kb;en-us;210111
thanx guys
Manoj
