General :: How To Make Database Accessible (read Only) On Other Pc

Sep 15, 2014

how to make my database accessible (read only) on other pcs?

View Replies


ADVERTISEMENT

Best Way To Make Database Web-accessible?

Dec 28, 2005

It's an Access 2003 database which I want authenticated web users to be able to write new records to.

I don't think a Data Access Page is the right way to do this, is it? If something else, e.g. ASP could someone possibly point me in the right direction with steps 1, 2 and 3 :D

View 1 Replies View Related

General :: Making Access Database Accessible Via Net?

Dec 6, 2012

there is a need to make access database (access 2007) accessible over net. I know Access Database is not web based application. So I want to know if there is any way of making it accessible via net.

View 1 Replies View Related

General :: Db Locked And Not Accessible Afterwards

Sep 4, 2013

I have a problem with a cleint-Server accessdb that I created and works fine. But rarely (may be once in a week), I get a record lock file (normaly 1kb size) which is not the normal record lock taht appears when the system runs. This file does not get closed even if the db is closed. Also, I can delete it and I can access the db again. when this lock file exists, I cannot access the db.

View 5 Replies View Related

General :: Database Is Read Only

Jun 8, 2015

The database I am working with suddenly says that is ready only, and I cannot make changes! How can I make it not read only?

View 2 Replies View Related

General :: Database Becoming Read Only At Random?

Jun 24, 2014

I'm sure it's not random, but it doesn't seem to follow any sort of rules. My database has become "Read Only" 3 times now causing all workers using the database to stop work until IT can fix the issue. All IT does is kick everyone out of the folder that my db is in and suddenly it is no longer read only.

View 2 Replies View Related

General :: Database Or Object Is Read Only?

Aug 25, 2012

Been using XP all this time, just got a new computer with Windows 7. Still using old Access 2000, not my call to update as this is the decision of the guy who owns the database.

Anyways, I opened Access for the first time, just a blank database so I can set up the user account. When I go to Tools > Security > User and Group Accounts and try to assign a password to Admin, I get the error message that it cannot update because the database is read only.

Where did this come from? I have never seen this message before, and the person who owns the database has a couple computers with Windows 7 that I have set this up on and did not run into this issue.

I realize that there can be some compatibility issues with Windows 7 and Access 2000 but it has worked on other Windows 7 computers, and not using the virtual XP mode.

View 13 Replies View Related

General :: Need To Add Data To Read Only Database

May 7, 2015

I have read only access to a database maintained by a vendor. I am using an append query to search for new records in that database every time my database opens through a macro. This adds any new records to my table. I then add additional information to each record in my table. This is newly acquired information, not calculated, and it is different for each record.

My question is can I keep my table up to date with the vendor table without running the append query macro at open every time as my database may remain open for extended periods of time during updating of records.

View 2 Replies View Related

General :: Database Has Been Opened Read-only

Apr 23, 2014

I have a simple database that is on a desktop that I have a shared folder and have not had issues till now. What would cause it so say, "This database has been opened read-only." Nothing has changed. Only thing my co-worker did was reboot the machine a few days ago.

View 2 Replies View Related

General :: Cannot Update - Database Or Object Is Read-only

Aug 24, 2013

I have 2 tables and from them I do a query called "Query_Dates". There, I created 4 calculated fields which compares fields of the two tables previously mentioned.

What I am trying to do is everytime the calculated fields are equal to "Diff", gets the value from the second table (ADHOC) and and puts it in the 1st table (Master_Table). In total there are 4 fields I would change depending on other 4 fields called (CheckRR, CheckQual, CheckProd, CheckCap).

The problem is that it gives me an error 3027, object is read-only.

Below, you can find the code.

Private Sub Comando27_Click()
Dim rst As DAO.Recordset
Dim rsd As DAO.Recordset
Dim supplierName As String
Set rsd = Application.CurrentDb.OpenRecordset("Query_Dates", dbOpenDynaset)
Set rst = Application.CurrentDb.OpenRecordset("Master_Table" , dbOpenDynaset)

[Code] .....

View 6 Replies View Related

General :: Database Opening In Read Only Mode

Sep 8, 2013

I am having problems opening my databases. Access automatically opens them in 'Read Only' mode, and I cannot find a way to avoid this - so I can never add data to the original tables ....

View 2 Replies View Related

General :: Opening Access Database In Code As Read Only

Jul 30, 2013

I am trying to open up an Access database as read-only from another running Access database. The code I have to open the database currently reads:

"""C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXE"" ""f:commonpattyTraining Database.mdb", 1)

How do I change to read only?

View 3 Replies View Related

General :: Database Opens As Read Only When Opened From Shared Location

Jul 15, 2012

We have a database on a PC located on our network. The database is located in this computer's shared folder. Another database grabs data from this database occasionally. We're running into a problem where we cannot open the DB located in the shared folder (permissions granted) without it being a read only instance even with no users accessing the DB.

View 6 Replies View Related

General :: Database In Read Only Mode On Server In Access 2010

Jul 18, 2012

I'm working in Access 2010. I created a database that I want to post in a server on the read-only mode, so that users can not change forms or querys. How can I do this in Access 2010?

View 11 Replies View Related

General :: Exporting Queries - Database Is Read Only Error Message?

Apr 16, 2013

I routinely export queries etc from my development database to the 'live' master database used by users. Every so often I get the error message 'The database Mydatabase.accdb is read only'. Then I can't export anything to it. I don't know why it should suddenly become read only. How do I make the database changeable, and not read only?

View 3 Replies View Related

General :: Split Database With Multiple Users - Read Only Kiosk Mode

Dec 17, 2012

I have two separate database files, a front end with all my forms and a back end with all my tables. The backend is stored on a network drive, is there any way of being able to store the frontend on the drive with the backend? Users do not use the actual computer to store information or access files, everything is usually saved on the network drive. I have created a shortcut that launches the front end database in the read only kiosk mode.

View 5 Replies View Related

General :: Make Changes To A Form While Other Users Are In Database?

Jan 3, 2013

I was wondering if it was possible to be able to make changes to a form whilst others are accessing different forms.

At the moment, if i am editing the database any user trying to access the database gets a error warning them, they the database is in admin.

But if another user is in the database while i am trying to change a form / report, i am unable to save.

I no the simple way to do this would be to do changes whilst no-one is in. Its just some minor tweeks need doing during the day.

View 7 Replies View Related

General :: Make Warning Pop Up When User Tries To Access Database?

Feb 5, 2013

How can I make a warning pop up when a user tries to access a database that another user is already in??

View 13 Replies View Related

General :: Inventory FIFO Database - How To Make Transaction

Apr 17, 2013

I want to make inventory fifo(first in first out) db. Example:

February
1- beginning balance : 800 unit @ 6$ per unit
4- received 200 unit @ 7$ per unit
10- received 200 unit @ 8$ per unit
11- issued 800 unit
12- received 400 unit @ 8$ per unit
20- issued 500 unit
25- returned 100 unit to storeroom to be recorded as latest issued prices
28- received 600 unit @ 9$ per unit

The report must be like pic attached

I dont know how to make transaction to do this....

My database in attachment

View 3 Replies View Related

How To Make Read Right To Left

Mar 18, 2005

I have a field within the table in hebrew and want to make it read from right to left. How can I?

Will that be working if I display it using ASP online?

View 1 Replies View Related

Make Tables Read Only

Jun 17, 2005

can anyone plz tell me how to make a table read only to prevent users from changing the records in the table?

View 2 Replies View Related

Forms :: Make Record Read Only

Jul 11, 2013

I have a Workorder form that I want to not allow edits, deletions, and additions when the Workorder is closed. Is there a way to program a button for this that could be password protected in case it needs to be reopened?

View 3 Replies View Related

General :: Split Database - Modify Backend File And Make A New Front End

Jun 12, 2012

So a while back I created a database which I use to keep track of my companies large list of products. It is very simple only 3 tables, 1 query and 1 form. After running into a problem with copying and pasting updates on each computer in the office I decided to split the database on a network drive. This worked for a bit, however I had to add new fields and modify the form, which corrupted the file. Luckily I had a backup before the split.

As far as I could tell all I had to do was modify the backend file and make a new front end. However it seems like it is not as easy as I thought it would be. How do you modify a split database without corrupting the files or using a non-split copy?

View 1 Replies View Related

General :: Cannot Open Database Error When Make Table Option Selected

Sep 28, 2012

I linked table rawdata from a database called competitor from a ODBC Database. I run a query with to make a table with a criteria where it retrieves roughly 10 columns with 719,000 rows. And it gives me this error.

(Cannot open database". It may not be a database that your application recognizes, or the file may be corrupt.

I asked the creator of the database and they said the database grows automatically and it was created with the same Access version as i am using to run the query.

Also when I do a RUN without creating a table and just selecting and displaying the data it does not give me any issues.

View 4 Replies View Related

Ms Access Read Only Html Format - How Do I Make One

May 14, 2007

Hi im kinda a newbie here so, any helpful comments or links of creating a ms access database where it can be viewed in html is welcome. thanks

View 1 Replies View Related

Tables :: Password Protect A Linked Table Or Make It Read Only

Nov 14, 2012

I have a table that I imported from another database. I used import Access - Link to the table source by creating a linked table. - then downloaded in my database.

I want to use the linked table to create relationships and forms but do not want to even accidently edit it. The table gets updated in the database on a weekly bases and I am hoping it gets updated automatically in my database as well. does it automatically get updated or do i have to set up something?

Also, I want to protect the data in that particular table and either password protect it or make it read only. Can I do that? If so, how?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved