473,324 Members | 2,473 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Access database works for some users

Hi all,

I have database which the front end is installed on
c:\database\sample.mdb
and the backend on a server.

The problem i am havin is wen i set the database for user such as joe
blogs the database will work for them. But if another user logs on
such as jenny blogs the database doesn't work. It says microsoft can't
find the database file c:\database\sample.mdb. however if i replace
this database with jenny blogs logged on it will then work. but if joe
blogs logs in it won't work for him.
On some computers this works if multiple users logon. But on some it
doesn't. i have tried loggin as an administrator and tryin it that way
and setting the permissions to the database folder to be shared by all
users but still doesn't work.
Is there any solution to this?

thanks

farouq
Nov 12 '05 #1
1 1738
fa*******@hotmail.com (Farouq) wrote in message news:<c6**************************@posting.google. com>...
Hi all,

I have database which the front end is installed on
c:\database\sample.mdb
and the backend on a server.

The problem i am havin is wen i set the database for user such as joe
blogs the database will work for them. But if another user logs on
such as jenny blogs the database doesn't work. It says microsoft can't
find the database file c:\database\sample.mdb. however if i replace
this database with jenny blogs logged on it will then work. but if joe
blogs logs in it won't work for him.


Do you have a desktop shortcut that you are using to open the database
or are you first starting Access and then opening the database from
there? If you have set up a desktop shortcut to the database and you
want the database to be accessible to all users of that machine, put
the shortcut in the 'C:\Documents and Settings\All Users\Desktop'
folder and delete it from everywhere else. It should not be in
'C:\Documents and Settings\jenny blogs\Desktop' or 'C:\Documents and
Settings\joe blogs\Desktop'.

Also be sure that the database file itself really is installed in
'c:\database\' and not in an individual user's 'database' folder (i.e.
not 'C:\Documents and Settings\jenny blogs\database' or 'C:\Documents
and Settings\All Users\Desktop\joe blogs\database'). And be sure that
the 'target' field of the shortcut points to 'c:\database\sample.mdb'
as well. Hope this helps.

Bruce
Nov 12 '05 #2

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

Similar topics

8
by: Frnak McKenney | last post by:
Back when computer dinosaurs roamed the earth and the precursors to today's Internet were tiny flocks of TDMs living symbiotically with the silicon giants, tracking access to data processing...
63
by: Jerome | last post by:
Hi, I'm a bit confused ... when would I rather write an database application using MS Access and Visual Basic and when (and why) would I rather write it using Visual Studio .Net? Is it as easy...
13
by: Simon Bailey | last post by:
I am a newcomer to databases and am not sure which DBMS to use. I have a very simplified knowledge of databases overall. I would very much appreciate a (simplifed) message explaining the advantages...
13
by: BigDaDDY | last post by:
Um yeah....In case you haven't figured it out, Microsoft sucks. I'm going to be kicked back in my chair eating popcorn and watching football 10 years from now, while all you clowns are scrambling...
18
by: Andre Laplume via AccessMonster.com | last post by:
I have inherited a bunch of dbs which are are shared among a small group in my dept. We typically use the dbs to write queries to extract data, usually dumping it into Excel. Most dbs originated...
4
by: James | last post by:
I have a VB windows forms application that accesses a Microsoft Access database that has been secured using user-level security. The application is being deployed using No-Touch deployment. The...
1
by: James | last post by:
I have a VB windows forms application that accesses a Microsoft Access database that has been secured using user-level security. The application is being deployed using No-Touch deployment. The...
49
by: Mell via AccessMonster.com | last post by:
I created databases on Access 2003 and I want to deploy them to users. My code was also done using 2003. If they have Ms Access 2000 or higher, will they be able to use these dbs with all code,...
3
by: FelixSmith | last post by:
I have recently posted a new access database and its oracle tables onto a shared folder for various users. It is a search database and me and a few other users are able to pull from the file and use...
10
by: Les Desser | last post by:
In article <fcebdacd-2bd8-4d07-93a8-8b69d3452f3e@s50g2000hsb.googlegroups.com>, The Frog <Mr.Frog.to.you@googlemail.comMon, 14 Apr 2008 00:45:10 writes Not sure if I quite follow that. 1....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.