473,581 Members | 2,481 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

My ritual question for each new version of Access since 2000

Hello

I downloaded Office 2007 for this reason :

It seems, once again, that it is impossible to save any modification
done in a VBA library, from the main project in Access.

The save button remains desperatly grayed.

It also seems impossible to open the library in another Access instance
and modify it.

This makes impossible to maintain a pure VBA Access database when this
library can only be tested in the context of the main project.

In fact this makes impossible to make some meta-programmation whith
access. This is -and has always be- my only way to work.

So my question is, ritual since six or seven years : is there a
possibility to explain Access that only one person in a single instance
of Access is about to modify this file ? or something very simple like
that ?

Mathieu, lonesome, desperate.
May 30 '06 #1
34 2565
You have a main project (MDB) and a library project (MDB), and you're making
reference to the library from the main, and you want to make a change in the
library, while opening from the main. Is that it?

I don't know of any way to do that.

Anyone?
May 31 '06 #2
>
It also seems impossible to open the library in another Access instance
and modify it.


Have you tried using source code control?
access 2003 has a source code control add in, and when you use it, you can
check in,/ check out code, queries, forms etc. In fact, what is really nice
is that you can actually check out queries....and check them back in!! (I
can't think of any ide that allows this).

I not tried the above, but for most serious development, people do use
source code control. Perhaps it would be a solution in your case....
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
http://www.members.shaw.ca/AlbertKallal
May 31 '06 #3
>Perhaps it would be a solution in your case....

In thinking about this, likey it would NOT solve your problem. My next best
suggestion would be to ALWAYS set a reference to a mde, and that way, you
can open/browse/modify the mdb that the mde libary is based on. That should
work. If you *do* make changes to the libary code, the you would have to
wait untill you exit the appcaton that is "holding" the mde.

I am rather surprixed that you can catuly set a refernece to a mdb file
anway (a mde at elast forces the code to be compiled).


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
http://www.members.shaw.ca/AlbertKallal

May 31 '06 #4
opps...bumped the sned key...
Perhaps it would be a solution in your case....


In thinking about this, likely it would NOT solve your problem.

My next best
suggestion would be to ALWAYS set a reference to a mde, and that way, you
can open/browse/modify the mdb that the mde library is based on. That
should
work. If you *do* make changes to the library code, the you would have to
wait until you exit the applications that is "holding" the mde.

I am rather surprised that you can actually set a reference to a mdb file
anyway (a mde at least forces the code to be compiled).

Would not the above approach sole this problem? You can't for most part edit
the executable part in any other development platform anyway. So, I am not
sure why you need to do somthing that no other develpuemt patform allows?

This is not a "new" problem.

We *could* do this in a97, but it was not recommended anyway. It seems if
you use a mde for your library code, this should then work...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
http://www.members.shaw.ca/AlbertKallal
May 31 '06 #5
And all they had to do was provide a switch to load
libraries in exclusive mode.

They even could have used the same switch used by
Application: if CurrentDB is loaded exclusive, load
libraries exclusive.

It's bad enough that they couldn't build a multi-user
database system to store the VBA project in. (Apparently
they had problems with referential integrity)

But you sometimes think that being assigned to
the MS Access project must have been some kind of
punishment for people whose hearts really aren't
in it.

(david)
"Mathieu Trentesaux" <ma************ ***@free.fr> wrote in message
news:44******** **************@ news.free.fr...
Hello

I downloaded Office 2007 for this reason :

It seems, once again, that it is impossible to save any modification done
in a VBA library, from the main project in Access.

The save button remains desperatly grayed.

It also seems impossible to open the library in another Access instance
and modify it.

This makes impossible to maintain a pure VBA Access database when this
library can only be tested in the context of the main project.

In fact this makes impossible to make some meta-programmation whith
access. This is -and has always be- my only way to work.

So my question is, ritual since six or seven years : is there a
possibility to explain Access that only one person in a single instance of
Access is about to modify this file ? or something very simple like that ?

Mathieu, lonesome, desperate.

May 31 '06 #6
> In thinking about this, likey it would NOT solve your problem. My next
suggestion would be to ALWAYS set a reference to a mde, and that way,
can open/browse/modify the mdb that the mde libary is based on. That


If only it were true.

If you have ever had the reference library mde loaded, you need to
close Access before you can work on the library source code.

Otherwise, Access suspects you are 'sharing' the source file.

Access doesn't unload libraries, and it won't differentiate between
the mde file (loaded once with no editing done or possible) and the
mdb file (never loaded or edited by anyone).

Since the developers of Access 2000 where unable to get their heads
around the idea of multiple users sharing text in a database, they
handed the problem off to the SourceSafe people.

The SourceSafe people were able to provide a file based multi-user
database to store text in. Perhaps some of the Access 2.0 developers
had moved to that project.

(david)

"Albert D.Kallal" <Pl************ *******@msn.com > wrote in message
news:5z9fg.2156 81$WI1.178977@p d7tw2no...
Perhaps it would be a solution in your case....


In thinking about this, likey it would NOT solve your problem. My next
best suggestion would be to ALWAYS set a reference to a mde, and that way,
you can open/browse/modify the mdb that the mde libary is based on. That
should work. If you *do* make changes to the libary code, the you would
have to wait untill you exit the appcaton that is "holding" the mde.

I am rather surprixed that you can catuly set a refernece to a mdb file
anway (a mde at elast forces the code to be compiled).


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
http://www.members.shaw.ca/AlbertKallal


May 31 '06 #7
Sounds like the only option that will work is to set a reference to the MDE
in your live project, and then wait until last user is out to replace that
MDE.

I haven't seen the problem you describe of not being able to modify the MDB
just because someone is in the MDE. I can imagine the possibility that if
you put the MDB and the MDE of the library in the same directory, presumably
having the same name other than MDB and MDE, since you can only have one LDB
you could have a problem. But the real problem there is putting both MDB
and MDE in the same production directory. One or the other, but not both,
ever.

And in development, since you have to be out of the main project to release
the MDE anyway, there shouldn't be a problem with modifying the MDB and then
creating the MDE.
May 31 '06 #8
w_a_n_n_a_l_l_ -@-_s_b_c_g_l_o_b_ a_l._n_e_t wrote in
news:FA******** *********@newss vr14.news.prodi gy.com:
Sounds like the only option that will work is to set a reference
to the MDE in your live project, and then wait until last user is
out to replace that MDE.


I don't know if that is what is meant or not. That would only be a
problem if you're sharing the library, and, well, why in the world
would anyone in his right mind do that?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
May 31 '06 #9
I'm not sure what you're after with the "sharing the library" observation.

If the user has an application MDB Or MDE in the same directory as a
reference library file (MDA, whatever), then that library is shared the
moment two people use the app. Am I misunderstandin g your question?
May 31 '06 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
2798
by: Squirrel | last post by:
I've developed an Access 2002 database which will be deployed with the backend on a server and frontend on the users' PCs. I've now been advised that new employees will be given laptops with Access 2003 installed and that the server software will not be updated. Also some of the users are using Access 2000 and some Access 2002. My...
0
2002
by: Neil Sargent | last post by:
This is a general posting of how I fixed a problem created by using the Access 97 ODE Setup Wizard on a Windows XP machine. I hope it helps anyone who comes across the problem saves them the 3 days its taken me to sort out. The application generates the following error: "Incompatible version of the RPC stub" This occurs when trying to...
7
4219
by: Danny | last post by:
I want to buy the latest version of ms access. Will this version let me create an mdb that will work with a lesser version such as 2000, I am having a problem going from 2002 to 2000. The mde will not work. Is there a place you recommend that has it for a decent price? Thanks
1
24039
by: Me | last post by:
Hi all, I have an Access application that has to import hundreds of other MDB's, some access 97 and some 2000, and merge them into several large mdb's. so far so good, but my command: Set appAccess = GetObject(TargetDBPathNAme, "Access.Application.9") sometimes fails, of course, when the MDB to be imported is Access 97
4
7157
by: Br | last post by:
We're using an Access2000 ADP with an SQL2000 back-end. Because SQL2000 was released after Access2000 you need to be running Access2000 SP1 (2 or 3) for it to work properly. Is there an easy way for the ADP to determine programatically wether the correct service pack is installed (or if they are using a newer version such as 2002/2003)? ...
7
2725
by: Ian Davies | last post by:
Is the runtime version of Access for distribution, that is available with the developer extensions a fully functional version of Access apart from the ability to create, edit and code a database? I am particularly interested to know if the Linked Table Manager will function, as I make use of this in one of my applications as a way the user can...
5
7673
by: Bob | last post by:
Application.Version provides the version of Access being used eg 10 for Access 2000. I use some code like: Set appAccess = CreateObject("Access.Application.8") in Access 97 to open a new instance of Access so that I can create an archive of the current database. (That took a bit of searching to work it out but it is working fine in...
2
3966
by: Dedalus | last post by:
If I want to retrieve a full version information for an ms access databases, I use (from vb6 code) the "Access.Application" object and SysCmd method. Whit the number returned by the method I can identify the service pack applied to database (e.g. ... SysCmd(acSysCmdAccessVer) = 9 -Access 2000 SysCmd(715) = 2719 ' Access 2000 No Service Pack...
9
2760
by: Don | last post by:
I've continued to use Access 97 all these years because (1) it does everything I need quickly and (2) most of what I've read online indicates that it's still the most bug-free version of Access. But now that Vista is gradually becoming the only Windows choice and Vista doesn't exactly "cooperate" with Access 97, I'm afraid it may be time to...
0
7800
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8309
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
8178
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5679
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5365
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3806
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3830
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2304
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1405
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.