CENTRAL ÚNICA DE VENDAS 
 
10 Marcas de ratreadores, Compare e Compre. 
 
Rastreador de Veículo 
 
Rastreadores de Veículos 
 
Rastreador GPS 
 
Rastreadores GPS 
 
Rastreador Ituran 
 
Rastreadores Ituran 
 
Rastreador Portátil 
 
Rastreadores Portáteis. 
 
Assistência 24 Horas 
 
Visite agora mesmo nosso site. 
 
http://tel011-50523122.vila.bol.com.br/ 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Rastreadores gps , Localizadores, Bloqueadores 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Ra ...

Hi All, 
 
I recently moved a database to a SQL server backend to allow for 
 
multiple user access. I was successful in all account except speed. It 
 
is extremely fast on my end(east coast), however, west coast users 
 
experience extremely slow data access, so forms take five seconds to 
 
load as opposed to instant. Now, I don't know much about networks, but 
 
could this be due to that? I know that the sql server is being access 
 
directly through the adp.. so there shouldn't be any probl ...

Hi Heros, 
 
I have had my db operating for 3 years and never ran accross this problem.  I 
 
am not longer able to write to the database.  I verified with IT that the 
 
permissions on the folder have not been changed.  The db error says "Read 
 
Only: Database in use by another person" however, there is no .ldb file. 
 
Whether or not the following as anything to do with it, I dont know.  I was 
 
querying the data from Excel.  I noticed that I could not make changes to the 
 
database with th ...

Hello, 
 
I have an Access data base that has the frontend and the data portion 
 
split.  The data is on the network and each user has a local copy of 
 
the front end. 
 
Everyone is able to access it except for one machine.  I've tried to 
 
log in using the Administrator ID/Password but I get an error message 
 
that the backend data is locked exclusively by some one.  I've kicked 
 
everyone one, rebooted the local machine and also rebooted the network 
 
server where the backend data is be ...

I'm having a memory problem with Access 2003. It runs slow especially in 
 
design and I get out of memory problems. I should have amble memory at 384mb 
 
of ram. But twice my virtural memory had to be updated. Can someone point me 
 
in the right direction to get this fixed. It just started last month when we 
 
had all those MS updates. Thanks.

alright, i have a batch file, and i thought i was doing everything 
 
correct but it does not seem to do its job.  Here is the text in the 
 
..bat file. 
 
-------- 
 
cls 
 
c: 
 
cd \docume~1\%username%.domainname\desktop 
 
copy j:\Prge\Component\AOV\AOV Database\MNGP Valve Database.mde . 
 
-------- 
 
i want it to copy this mde file to the desktop of any user who clicks 
 
the command button on my access form.  TO do this i used the code: 
 
Call Shell(Environ$("COMSPEC") & " /c  J:\PRGE\C ...

I am almost at the finishing line with a great deal of help from here. 
 
I have now normalised the tables, built complicated queries, forms, reports, 
 
all from scratch as I knew absolutely nothing before I started with Access 
 
three months ago. 
 
I have compacted and repaired the database using the wizard, and also 
 
complied the code and analyzed all tables, forms, queries, and reports and 
 
relationships. 
 
The final step is to make it an MDE file so that it can go on the local 
 
net ...

Hi All, 
 
I'm a newbie at access but have been doing hardware IT for computers 
 
for about 15 years. 
 
I've got a client that is using MS Access for a database that is 
 
multiuser in the office, but in the field (6 supervisors) is is a 
 
single user database. 
 
The supervisors enter the new information or updated information and 
 
twice a month they perform an 'export' to the main office to update 
 
the main database.  This export is in the form of two txt files. 
 
The txt files are int ...

Ok in a nutshell here is my problem and I havn't worked with access since 97 
 
so I need some help. I need to create a database that I can share amongst 
 
users with all having full access to modify, edit, and delete records. I need 
 
to be able to share this with all the users on our small office nework and we 
 
don't have the funds to aford sql server. Is there anyway to do this?

Access 2003/Windows XP, split individual PC FE/Server BE database.  Need to 
 
have some users who can read and write, others who can only read.  Have set 
 
server folder- and file-level permissions accordingly.  Both FE and BE are 
 
set for sharing, no record locking. 
 
Unfortunately, we're encountering intermittent, maddeningly inconsistent 
 
problems where users in BOTH categories get lockout messages saying someone 
 
else has the database open.  Specifically, the FE opens for them, but  ...

hi all, 
 
I use MS Access 2003 and VBA 
 
I have a form with search feature, the result of searching is shown in a 
 
subform, when the user click the record on the subform or they choose the 
 
record with keyboard another form is opened with that record so user can edit 
 
information and update data after user close that form. 
 
I tried bookmark properties to get the current record but it not accept 
 
Anybody has source code about this problem, please help me ASAP, thanks :) 
 
-- 
 
khanh ...

I have a database, Trakker.mdb, that is on a server. 
 
Each user has Microsoft Access on their individual computers. Trakker.mdb is 
 
not split. 
 
If person A opens Trakker.mdb first, then person B gets an error message 
 
about Trakker.mdb being open exclusively. Person B has to hit the OK button 
 
30 times to get the message to go away. [Yes, she counted 30.] 
 
On the other hand, if person B opens the database first, person A does NOT 
 
get the same error message. 
 
Both persons use a i ...

Highest rate for all type / brand 
 
24-Hrs +91 9810577227 Puri

Hi All, 
 
Can anyone point me to information as to how record locking is handled in 
 
Jet 4.0?  I've downloaded JetUtils from Microsoft's web site but the 
 
contained documentation does not specifically address 4.0, only up to 3.5. 
 
Any help is appreciated. 
 
Ciao, 
 
Tony

Hello groups ! 
 
In a vbs script, I connect to an Access 2000 database and open a 
 
recordset for in readonly mode : 
 
Dim oConn 
 
Dim oRS 
 
Set oConn = CreateObject("ADODB.Connection") 
 
Set oRS= CreateObject("ADODB.RecordSet") 
 
oConn.Provider = "Microsoft.Jet.OLEDB.4.0" 
 
oConn.Open "Data Source=M:\mydb.mdb;User 
 
ID=myuser;Password=mypassword;Persist Security Info=True;Jet 
 
OLEDB:System database=M:\systemdb.mdw" 
 
oRS.Open "Select Count(*) FROM mytable WHERE 
 
somefield='someval ...

I'm having continuing problems with Access 2003 databases and totally 
 
bogus error messages about exclusive access and what-not.  I am the 
 
only user, all the other machines on my network are turned off, and I 
 
have only a single instance of a single database open.  Previously, 
 
whenever my VBA code would hit an error, I could not save any changes 
 
until exiting both the database and the VBA editor.  Now I've run into 
 
a situation where when I run the code shown below, it runs withou ...

We have FE copies on users desktop which links to tables on the server 
 
database. The form is pointing to a table and multiple users are 
 
running that same form at same time. The access database is 2003 
 
format. When one person is adding a record in that table, and another 
 
person tries to add new record, it says table is currently locked by 
 
first user. There are three users most of time is same table all day 
 
long. How can i fix it. I already checked the NO Lock under options, 
 
a ...

What would be the best method of syncing a database, that is stored locally 
 
on three computers, that are not connected by a network, but by the Internet 
 
only. 
 
-- 
 
Message posted via AccessMonster.com 
 
http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200607/1

I have a split database that runs offs my server, and 5 computers that access 
 
the database off the server through a shortcut I placed on each computer. And 
 
it's been working for years (with little errors here and there; but overall 
 
running nicely). This morning when we try to access the database all of us 
 
get the following error: 
 
The database 'F:\Repomaster\RepoDB.mdb' needs to be repaired or isn't a 
 
database file. You or another user may have unexpectedly quit Microsoft 
 
Off ...

hi all, thanks everyone for the help in the past, i really appreciate that. 
 
Now i have a new problem and help would be really appreciated. 
 
I have a small network based on 4 computers. I have the main Database on the 
 
server. I have all 4 computers connected to the database and they all can 
 
update the data at the same time. I do NOT want to split the database. 
 
Problem started when i upgrade done of my computer to XP. Now from that 
 
computer : 
 
1) I can not open the database when ...

My mdb fe links to multiple back end mdb files - the recommended code from 
 
The Access Web works but only lets me select one location and then tells me 
 
a particular table (from a different back end) doesnt exist.  How can I 
 
select multiple back ends one after the other (if that makes sense). 
 
I used the code from http://www.mvps.org/access/tables/tbl0009.htm to open 
 
the SaveOpen Dialogue to relink table at db start up (calling function with 
 
Macro). 
 
Cheers, 
 
nB

on machine 'XXXX' that prevents it from being opened or locked." in a VBA 
 
application.  I have had multiple users (everyone runs Windows XP) in MN 
 
connecting to an access database on the MN file server (running Windows 
 
Server 2003) for several years without and database locking issues.  This 
 
week we brought on our TX facility (they are on a different domain than MN). 
 
TX users connect over the WAN to the same MN file server and the same access 
 
database as the MN users.  The user ...

I need user security without installing then internal user_level security. In 
 
the book: Access Cookbook by K Getz et al. they suggest to creat your own pub 
 
function. Can anybody write a simple code for changing the CurrentUser with 
 
the NetworkUserName so I can use it in all forms. TIA 
 
-- 
 
Best regards 
 
CA Brandt

Hi All, 
 
I'm seeking a little advice about how this should be handled in a multiuser 
 
access application. We have a split access 2003 database with each client 
 
having their own front end. In our current scheme of things it's likely that 
 
multiple clients would be editing the same record simultaneously thus we 
 
constantly receive the "Error 3167 This record has been deleted" or the 
 
"Write Conflict (this record has been changed by another user.. (I don't 
 
know the error code for th ...

I have a multi user database that goes exponetially when it is use. It is a 
 
split database. Each user has their own deont end. However you can literally 
 
'watch' it grow when I have twelve users in it at the same time