|
Getting "...not a valid path..." pop up messages.
Using Access 2000 DAO. The front end is on the users PC's and the backend is
on the Q: Drive which is on a subnet that is different than the main network
drive for the users.
The following messages pop up continuously on two of the users PC’s after
the Database has been open and not used for approximately 10 minutes:
“Q:\CalTranParkBE.mdb is not a valid path. Make sure that the path is
spe...
|
3 |
6/25/2007 5:55:23 AM |
|
|
Diabetic Recipes and More...
Hi Cookers,
Welcome to our new website, cookersworld.com. We
have expanded the content links to ad Mr. Emeril
Lagasse's fine recipes along with recipes for diabetic's.
The website is full of great links from our partners. We
have links to free cookbooks and more. Please stop by
and support us. Visit all our links and choose the best
recipe for you or your family.
We look forward t...
|
1 |
6/24/2007 8:25:51 AM |
|
|
news groups
This is a multi-part message in MIME format.
------=_NextPart_000_0014_01C7B4CE.22D49BD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
------=_NextPart_000_0014_01C7B4CE.22D49BD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"&g...
|
2 |
6/22/2007 8:16:19 PM |
|
|
¼á³Ö·´¶Ô¿Ö²ÀÖ÷Òå
ÃÀ¹ú²»ÄÜÀ뿪ÒÁÀ¿Ë
ÒÁÀ¿ËÕ½ÕùÒѾËÄÄêÁË£¬ÏȲ»ÂÛÕ½ÕùµÄ¶Ô´í£¬Ó¦ÒªÃæ¶ÔÏÖʵµÄÐÎʽ£¬ÈçÒªÍ˳öÒÁÀ¿Ë£¬ÐÎÊÆÔõÑù£¿²»ÄÑ¿´³ö»¹ÊÇһƬÄÚÕ½£¬¶øÇÒ»á¸ü¼Ó²ÒÖØ£¬ÒòΪÕâÊÇÒ»¸öÏÖʵµÄÏëÏó£¬ÕâҲȷʵÊÇÓë¿Ö²ÀÖ÷ÒåµÄÕæÕý½ÏÁ¿£¬ÃÀ¹ú¾Í´ËÍ˳öÊÇÒ»ÖÖ²»¸ºÔðÈΡ£¶øÇÒ¹ú¼ÊÉç»áÒ²Ó¦²ÎÓ룬ҲÓÐÄÜÁ¦ÖÆÖ¹ÄÚÕ½£¬ÄѵÀ¾ÍÖ»ÊÇ¿´Âð£¬Èç´ËµØÆÀÂÛÂð£¿ÐļÆØϲ⣬ÊÇÏ£Íû±¾ÀµÇÊÇÓ®¼Ò°É¡£ÒªÓ®µÃÕâ´Î½ÏÁ¿£¬ÃÀ¹úÓ¦¸Ãսʤ¿Ö²ÀÖ÷Òå¡£
...
|
5 |
6/21/2007 10:57:38 AM |
|
|
compact split database
how can i compact & repair the back end database frim within the front end?...
|
7 |
6/20/2007 3:03:00 AM |
|
|
Access 97: Compact Issues
Hello all,
I have an issue that I have been researching, but would like to see if
anyone else has some other ideas I may be able to try. Here's the situation;
I have an Access 97 database backend used by multiple users, and multiple
Access application front ends. This database would normally have to be
compacted once every 2-3 months just due to the constant use and everyday
wear and...
|
4 |
6/19/2007 4:21:02 PM |
|
|
can't keep number unique
I have a multi-user ACCESS 2003 DB. When a user logs in, they may add
a new record. However, it must have a unique number. Originally I
was using dmax( field,tablename) and adding one to it. However, if
more than one person is adding records, they get the same number,
until one of them saves and closes, then the other loses thier data.
So, I create a table, in which i store the last valu...
|
5 |
6/19/2007 12:49:13 AM |
|
|
Multi-user / Multi-location DB from scratch
I am a newbie who was recently tasked with setting up a DB based reporting
system to report on approximately 20 customers' KPIs.
Here's the environment:
-20 customers all over the U.S.
-20-30 users all over the U.S.
-All have high-speed internet access
-Very few users are on the LAN/WAN
-125 reports
-Some existing customers already utilize our oracle server to feed data to
where we ...
|
2 |
6/18/2007 5:45:36 PM |
|
|
Relocating a split database
Hi,
If I wish to move a split database to a new location, how do I point
the frontend to the tables in the backend?
Thanks,
Aine.
...
|
3 |
6/12/2007 10:40:45 AM |
|
|
New version of the Auto FE Updater
- Windows Vista now supported.
- Starting an exe, such as the Sagekey runtime system, is now supported.
- Fixed the "The MDW account name and password in the INI file weren't valid for
opening the MDB to determine the version of the MDB" message when in a mixed
operating system work station environment.
- Emphasized using %appdata% as a location for the Front End MDB/MDE in the sample
in...
|
1 |
6/12/2007 12:31:29 AM |
|
|
link multiple tables/databases
I'd like to set it up a situation where one backend with only tables
is linked to forms/reports/queries in one database and updates a dBase
table in another database. The backend tables are already linked to
the front forms/reports/queries. Now I am trying to set it up so that
it is also linked to and updates the dBase tables in the second
database. The dBase tables support a full-blown ap...
|
3 |
6/11/2007 3:45:37 PM |
|
|
How to update a split database
Hi,
My company has a database which I recently split. The database is used
by about 10 people. I wish to be able to add new forms and tables to
the database now and again. The idea I have now is to have the front
and backend to the database on the server and then a shortcut to the
frontend on each user desktop. How should I then go about updating the
front end or backend? Will I need to ge...
|
2 |
6/10/2007 5:45:43 PM |
|
|
developed database-invalid to multiuser
I have developed a database for my clients and an application to access the
databse. It works well when I placed the database at the server and the
application at the client computer.
But, application's access to the databaser under the server environment
became invalid argument when I used each users' remote desktop session to
access the application. The application became invalid. ...
|
2 |
6/10/2007 5:43:55 PM |
|
|
multiuser mdb with 61 tables, 32 odbc linked to mysql, users getting ERROR 3043
Hello all,
Multiuser(40 in peak) school database system based on access97, 61
tables, 32 odbc linked tables to MySQL 4.0.12 (FreeBSD 4.8 stable)
Jet engine version is 4.0.8618.0 on all or almost all machines.
MDB file itself is stored in samba network share and users access it
by shortcut with unc path.
Users are not able to edit the file. They use via forms.
Number of errors increase s...
|
16 |
6/8/2007 5:41:38 PM |
|
|
linking database
i run an FE mde that links with multiple access databases at the back end..
number of tables are huge. while using link table manage, it is hard to
identify which table connect to which database. how can it be simpified?
thanks....
|
4 |
6/5/2007 6:37:01 AM |
|
|
Automatic requery
Using Access 2003:
My main form has three subforms, all of which are populated by different
queries of the same table. Records move from one subform to another when a
combo box selection triggers a requery. All three subforms have the same
combo box.
The problem is this: the requery is only triggered on the computer of the
user who has made the combo box selection; while the other users...
|
1 |
6/5/2007 5:07:55 AM |
|
|
Automating Compact and Repair
I have an application that has the tables on a file server and the front end
on 4 citrix boxes (the app gives each user there own copy when they logOn to
citrix.) Is there a way to automate compact and repair say, every Sunday
mornign at 2am?
How important is it to compact and repair the front end periodically?
Thanks for your help in advance. Rob
--
Message posted via AccessMonste...
|
3 |
6/3/2007 6:05:51 PM |
|
|
Error in loading dll
I have an access 2003 .mdb file that resides in a shared directory on a 2003
server. I have users on XP Pro and Win 2k that use this. As of this morning
no 2K users can run the application. They get 'Error in loading DLL.' I
also get this error on the 2003 server where the actual .mdb file resides!.
There must be some .dll somewhere that 2003 server and 2000 are dependent on
but tha...
|
9 |
6/2/2007 7:38:41 PM |
|
|
Attempted to open a database that is already open
Hi,
We have a database which is used by about 5 people. We also code small
parts of the database now and again.
Recently we have started getting the error -
"You attempted to open a database that is already opened ... "
even when the person who is locking the database does not have access
open.
Could this be a problem with the code in the the Database, for
example, what would ha...
|
14 |
6/1/2007 7:33:42 AM |
|
|
Event sequence for locked record
If you try to enter data into a record that is locked, nothing visibly
happens. However, I assume that there are keyup, beforeupdate, and perhaps
some other events ocurring behind the scenes. Does anyone know what they are?
Here's why I'm asking: I'm in search of a way to detect that a record is
locked so that I can pop-up a message to the user explaining to him or her
why the entire pr...
|
1 |
5/31/2007 10:46:24 PM |
|
|
Database gets locked without information in the ldb-file
Hi!
I’m developing and administrating a big Access system with over 40
concurrent users/Access-sessions and more than 300 tables totaling 10 GB of
data. This system has been in use for over 10 years. We are using Access 2000
on a Windows 2003 Terminal Server, service pack 2. The Access system is split
with Front ends and Back ends and some connection to a MySQL server.
Recently som...
|
3 |
5/31/2007 6:16:03 AM |
|
|
È«²¿²úÆ·¿÷±¾´¦Àí£ºµõ´øÉÀ3Ôª£»ÐÝÏпã/TÐô/¶à¿îÍâÌ×5Ôª£»ÃÞ°À8Ôª£»ÑòÈÞÍâÌ×10Ôª£»Íâóѥ8Ôª¡¡
È«²¿²úÆ·¿÷±¾´¦Àí£ºµõ´øÉÀ3Ôª£»ÐÝÏпã/TÐô/¶à¿îÍâÌ×5Ôª£»ÃÞ°À8Ôª£»ÑòÈÞÍâÌ×10Ôª£»Íâóѥ8Ôª¡¡
ÒôÀÖºÐ4.8Ôª£»ÒôÏ첨1.8Ôª£»²»µ¹ÎÌ3.8Ôª£»ÔÓÎïͲ5.8Ôª¡¡
¸ü¶àÐÅÏ¢Çë¼ûÍøÕ¾:www.jl-sm.com
...
|
1 |
5/31/2007 3:28:44 AM |
|
|
Protecting FE code
As the FE is distributed to the end users within the network, is it possible
to protect the code of the FE in some way? Basically, I don't want the users
to be able to see the code and modify it (if that is possible)
Thank you
Diego
...
|
8 |
5/29/2007 8:44:58 PM |
|
|
Creating a MultiUser environment for the first time
I have an application that has to migrate from single to multiuser (5
users).
so far I've split the application to have a FE (to be downloaded by the
users) and a BE (to reside in a Shared Drive in the network)... so far so
good...
Now, I need to set up limited users, never done this is the past.
I am not asking for a complete HOWTO, but if someone could just direct me in
the right pa...
|
4 |
5/25/2007 10:38:13 PM |
|
|
Affect of shared backend
I have an application that has a separate backend mdb for the data.
Recently we put the backend on a server. 4 different computers run the
application mdb, located on each PC. All seems fine with one exception.
One of the forms takes about a minute to open (to even reach the Open
event!) IF another PC already has that same form open. This does not happen
unless they are both using the...
|
6 |
5/26/2007 8:57:17 PM |