473,320 Members | 1,817 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,320 software developers and data experts.

Database opens as READ ONLY

Tom
Just upgraded my old Access 97 DB to Access 2003. It is on a shiny new XP
Pro box. ON the new computer there is my domain administrator account and a
regular user account. If I open the DB in the Admin account, everything
works fine. If I open in the User account, I get a message telling me the
DB is in a read only mode and several of the update forms in the DB do not
work.

I prefer to have the users log in to their own account rather that have
everyone have domain admin permissions. How do I get this db to open
correctly. I have tried the "Runas" command and it didn't work.

Please help
Thanx
Tom
Nov 13 '05 #1
1 1829
"Tom" <ha********@hotmail.com> wrote in message
news:Hu***************@newsread1.dllstx09.us.to.ve rio.net...
Just upgraded my old Access 97 DB to Access 2003. It is on a shiny new XP Pro box. ON the new computer there is my domain administrator account and a regular user account. If I open the DB in the Admin account, everything
works fine. If I open in the User account, I get a message telling me the DB is in a read only mode and several of the update forms in the DB do not work.

I prefer to have the users log in to their own account rather that have
everyone have domain admin permissions. How do I get this db to open
correctly. I have tried the "Runas" command and it didn't work.


The database needs to reside in a folder that the user has full permissions
on. They need file create, edit, and delete authority on that folder.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

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

Similar topics

13
by: Larry L | last post by:
Access is noted for bloating a database when you add and delete records frequently. I have always had mine set to compact on close, and that works great. Now after everyone's advice I split my...
5
by: Brian | last post by:
I need to import data from 720 csv files into an Access database so I can do some editing prior to loading into a SQL Server. These files came from data output from a mainframe on a monthly basis....
6
by: ronwer | last post by:
Hello, The title doesn't completely cover the question I have, but it's a bit more complicated problem we have. We are using a database, based on Acces, but developed by a third party...
4
by: visionstate | last post by:
Hi all, I have built my 1st database and it is ready to go on a shared network drive. I have read a few articles about the security in access but am having some trouble getting my head around it...
1
by: Friends | last post by:
Hi I need to set security for row level but not based on Database user's login. It should be based on the user table login. For the particular user I need to allow only the particular records to...
35
by: Terry Jolly | last post by:
Web Solution Goal: Have a global database connection Why: (There will be 30+ tables, represented by 30+ classes) I only want to reference the database connection once. I put the connection...
0
by: Wayne | last post by:
Original Post: The following problem started on my PC about a week ago and I can't link it to any specific change. I'm using Access XP. If I have any database open and try to open any other...
6
by: mfinan | last post by:
I have an Access 2003 database backend that is located on our share drive. It is set to share but is opening as 'read only' when more than one user accesses it through their front end. This...
5
by: rgsw | last post by:
Hi - I would like user to open Access database and have a choice to either enter a password or click on a button that opens the database in 'read only'. I know this is possible with Excel, but I...
1
by: Bongard | last post by:
I have a MS Access database that is 2002-2003 file format. I have been using it for about a year now and it has worked just fine. Recently, I have been trying to get into the database to make a few...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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...
1
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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...
0
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...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
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...

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.