Copied Db Won't Allow Edits Or Additions

Jul 2, 2007

I'm an Access idiot - please be kind :o

I made a little Access app for a friend, to do his invoices. Access wouldn't allow me to copy the db to a CD, but advised me to convert it to a Master. I followed all the instructions (honest!). Afterwards, I could burn his db to a CD and, on his computer, it opened but wouldn't allow edits or new records - not terribly helpful for an invoicing program :eek:

Since then I've tried creating a new admin in his name, re-setting all permissions, blah blah ... Basically, it looks like there is loads of help on securing a database but very little on un-securing it enough to be transferred to another PC!

The dang thing persists in allowing everything except edits & additions :confused:

I can't find out how to convert it back from a Master to ... what, a slave? :p
Even so, that wouldn't be the answer coz I'd be back at square1.

I use a PC running XP and Office 2003. My invoice-less friend has a PC with Win[NT]2000 and Office 2000. I converted the database to Access 2000. I am way out my depth here, but hoping you Access swimmers will be able to advise :cool:

View Replies


ADVERTISEMENT

Stopping Edits And Additions On A Particular Record

Apr 2, 2006

hi,

can anyone tell me how to stop additions and edits on a particular record in a form, plus the subform that the main form contains,
im trying to put the event behind the change of a text box, shipped date, so when its changed you cant add or edit the record which is the order.

cant anyone point me in the right direction?

cheers

View 1 Replies View Related

Database Copied

Jun 9, 2006

hi all i have a big prob!

i opened up my database this morning and it has been working fine all day, suddenly where it is located a copy of my database has been worked, and the original when opens shows nothing, anyone knows what happened?thanks

View 3 Replies View Related

Mass Additions

Aug 11, 2005

Hello, All.

I have a table that collects training information for our company. Some training is limited to one or two employees and that is easily entered by using a form linked to the table. However, some training is mandatory, company-wide training that all employees must attend. How can I add a record for each employee reflecting this training most efficiently? Is there a way to do a mass update?

Thanks.

View 3 Replies View Related

Table Additions

Aug 22, 2007

I'm a self confessed newb and need help

Bascially trying to get 2 table entries to add together, now I get the 2 fields to view in the 1 entry I want them into but not as an addition

For instance
strPacket24 might have a value of 1726
strPacket48 might have a value of 1725
Total should equal 3451

Problem is in the total field I get the following displaying

String I have tried using is
=Nz([strPacket24])+Nz([strPacket48])
- this displays 17261725

=Sum(Nz([strPacket24])+Nz([strPacket48]))
- this displays 18592300 ??

Can anyone help me out please?

View 2 Replies View Related

How To Run Copied Database

Oct 6, 2011

Long time ago some computerdude made a database for my dad so he had a place for his customerinformation. When I open the file on his computer the file sort of "start" or "run" - there appears a little window where you can click buttons like "find customer", "remind me in two days" etc. That's how it always has worked and how it should work.

We have bought a new computer. We want a new database for me, where I can type my customers in the exact same way as in my dads access file. I have managed to import all the tables etc. without any data, BUT

I CAN'T GET THE DATABASE TO "RUN" OR "START" WHEN I OPEN THE ACESSFILE! HOW DO I GET THE LITTLE WINDOW WITH THE BUTTONS TO APPEAR IN THE SAME WAY AS ON MY DADS COMPUTER?

I only get the tables and the kind of "edit mode" when I open the program.I have tried to change the securitysettings, so access dosn't block any macros.

View 5 Replies View Related

Additions After Splitting Problem....

May 17, 2005

I'm not sure if there is an easy way to do this...... Maybe someone has run into this problem. Have a DB.....Did a split...BE is on the server "F" drive.. fe is on stations. I retained a full copy of the DB NOT split. I still wanted to expand it. So now I have problems by working this way..I have not altered the tables that are on the "F" drive.. But I have added more tables to my unplit version. I need to copy the tables and info from the BE on the server BACK to my full DB. Then split it again. IS there an easier way???????????
Thanks

View 1 Replies View Related

Stopping Database Being Copied

Nov 8, 2005

I have a customer who is concerned that their access database may be copied and used by a competitor. I have told him to set up passwrods for all users amd hide the system file which stores the password info so database won't open off site if copied. He doesn't want to do this though. Is there any other way, possibly by encrypting it?

Regards :confused:

View 3 Replies View Related

Copied MDW Doesn't Work

Jun 14, 2007

Hi! I'm relatively new to Access (2003) . I had to modify a shared network app so I copied it off and renamed it, made my mods and everything is fine. I then went to another app that connects to the original app to obtain data for display and synchronization, modified the call to open the new app including the new mdw. When it hits the new mdw, it can't open it because it says it's being used exclusively or the workgroup file is missing. It's not being used exclusively and it doesn't appear to be missing. The network path is correct. If I use the mdw from the original source app, it works fine. Please advise! :(

View 1 Replies View Related

Listbox Runtime Additions

Aug 1, 2006

I want to have a dropdown box in a form but allow additions to be made, but after they are made, instead of them not showing up in the box like usual, I want them to become a part of the list. Plz help! Thanks

View 9 Replies View Related

Report Info Copied To A Table...

Dec 25, 2005

I have a report in my DB that displays the results of several queries. How can I have the information displayed on my report entered into a table as a record when the report is generated?

Hope you can help!!

View 3 Replies View Related

Junction Table Record Additions

Dec 5, 2007

I'm trying to add records to a junction table based on additional record added to one table via form in the many to many relationship.
Junction table = ClientAssociation
Main table = ClientMain (qry_NewClientNullAssociation identifies new record added)
Many to many table = Associations

I'm trying to do this upon clicking a command button that then opens ClientAssociation based on Client_ID. Then allows user to select mutliple associations (Asoc_ID) for Client_ID.

Here's what I have - I'm new at this...

Private Sub ClickAssociations_Click()
On Error GoTo Err_ClickAssociations_Click

'Open recordset with new client records
Dim db As Database
Set db = CurrentDb
Dim recClient As DAO.Recordset
Dim strClientID As String


Set recClient = db.OpenRecordset("qry_NewClientNullAssociation", dbOpenDynaset)
'Loop through new client ids
Do While Not recClient.EOF
strClientID = ClientMain.Client_ID

Dim recAsoc As DAO.Recordset
Dim strAsocID As String

Set recAsoc = db.OpenRecordset("Association", dbOpenDynaset)
'Loop through asoc ids
Do While Not recAsoc.EOF
strAsocID = Asoc_ID

'Open junction table and update records
Dim recClientAsoc As DAO.Recordset

Set recClientAsoc = db.OpenRecordset("ClientAssociation", dbOpenDynaset)
With recClientAsoc
.AddNew
!Client_ID = strClientID
!Asoc_ID = strAsocID
!CheckBox = False
.Update
End With

recAsoc.MoveNext
Loop

recClient.MoveNext
Loop

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frm_Associations2"
stLinkCriteria = "[Client_ID]=" & Me![Client_ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_ClickAssociations_Click:
Exit Sub

Err_ClickAssociations_Click:
MsgBox Err.Description
Resume Exit_ClickAssociations_Click

End Sub

View 1 Replies View Related

Report Info Copied To A Table...

Dec 25, 2005

I have a report in my DB that displays the results of several queries. How can I have the information displayed on my report entered into a table as a record when the report is generated?

Hope you can help!!

View 1 Replies View Related

Form Inserts Due To Allow Additions Property

Nov 18, 2006

Hi All,

I have been searching and can't seem to find how to solve my problem. I have a sub form that allows adding new rows to a database. The detail contains a combobox and a few text fields. When I enter data everything works fine. However when I accidently tab into the next row (new blank row) and then try to get out of the form without adding a new row I get an error about "Index or Primary Key cannot be null" or something like that.

It is very frustrating because I can't exit the form until I add data to the new row and then leave without tabbing to much (thus creating another new row with no data).

How do I trap the new row and only allow the insert if it has data in it?

Thanks.

View 1 Replies View Related

Forms :: Disabling Additions In A Form

Mar 22, 2013

I have a form which acts as a search function for users looking to amend existing records. This is based on a query, where users enter a parameter (PolicyNumber) and this returns only the records which match the PolicyNumber in a form view. I have also added basic navigation buttons to move between all records with the same policy number. I have a problem in that I can't disable the option to add a new record in this form once people navigate to the end of the records.

The user clicks a 'search' button, manually inputs the policy number, and the records are returned in form view. The code for the button is as follows:

Code : DoCmd.OpenForm "frmAdjustmentsEdit", acNormal, "qryPolicyNumberSearchWriteOff", "", acEdit, acNormal

How I can disable the addition of records in this? Also as a sidenote if no records are found I would like it to display a MsgBox, but despite trawling the internet have been unable to find a solution I could get to work.

View 7 Replies View Related

General :: Preventing Changes And Additions Except Through Appropriate Form / Table?

Nov 9, 2012

While I was trying to test one of my forms (which was NOT working and I had to totally redesign it), I somehow created a bunch of stores in my Store Information table...some with no names, some with the first letter of an existing store, and there was even a duplicate of the store which is creating a problem now because some products exist in Store 1A and others exist in Store 1B.

I've created a query to identify the wayward products and am changing those. I'll delete that store then.

My issue is...can I set it so that the ONLY place a new store can be created is in the Store Information Input form? That if someone makes a typo when entering products, it doesn't create a new store?

Access 2010

View 2 Replies View Related

How To Copy A Report And Point It To Its Copied Query

Jul 16, 2015

So I have this killer report that took me hours to set up. I run it daily and it is great.

I now need to filter it slightly for 1 specific user. So what I did was I copied the query and renamed it. I added the filter I needed. But I don't want to have to re-create the report. Even though I know what I need it will take quite a bit of time to recreate it.

Is there a better way? Can I copy the report (using the same query) but add the filter on the report side?

View 4 Replies View Related

One Db Works, A Copied Version Doesn't. Driving Me Nuts.

Nov 13, 2006

hi,

i made an attendance db for work and got it to work. i then copied it and made two more for years 2 and 3. Years 1 and 3 work perefectly but for some reason the year 2 db won't allow me to write the data.

this is driving me nuts as i have already spent a few hours putting the students in and their course selections. i've tried making the forms again and as soon as i use a joint sub form to get the students first name the problem occurs. i've looked at the properties of the forms and they allow edits etc..

if anyone is feeling kind and has a spare moment, could you let me know why it doesn't work.

cheers

View 6 Replies View Related

Forms :: Duplicate Record Button To Allow Records To Be Copied

Feb 12, 2015

I have a form with a duplicate record button to allow records to be copied. I used this code (I think from Allen Browne), but it only copies the last record in the recordset?

If Me.Dirty Then 'Save any changes
Me.Dirty = False
End If
If Me.NewRecord Then 'Check there is a record.
MsgBox "Select a record to duplicate"

[Code] .....

View 2 Replies View Related

Reports :: Union Query - One Page Report Copied 3k Times

Sep 16, 2013

So i have a union query pulling together about 3,000 records from other queries.

I arranged all the counts and data I need to fit onto one page, but the report is copying that page (minus the header) for each record in the union query. I'd much prefer a one page report rather than a 3,000 page report.

Why does it do that? All I want is a one page report, how can I make that happen?

View 3 Replies View Related

General :: User To Review Address Register - Auto Alert When Changes / Additions Made

Sep 27, 2012

I've got a database that allows all users to review an address register. If they find errors or mostly get updated information they have another form they can fill out to make the recommended changes. Only I have access to the main DB to make the change permanent.

The question I have is there a way for Access to send me a notification that someone has requested the change?

I know that sending an email is doable - in Access. However, that's not an option for our network here. I was thinking something along the command prompt "Net Send" command. However I've not been able to get that to work by itself - let alone within Access...

I have used VB code in the past to store what PC is using the database, I could modify that to alert me whenever I open the DB up from my PC. But I was trying to get away from having to open this particular DB up every day and check for changes.

View 2 Replies View Related

Allow Edits To Combo Box

Aug 5, 2006

I want to allow users of a database to view data through a form but not to edit or delete it. I have set Allows Edits, Deletes and Additions to "No", but this causes the record-finding combo box I have to search for records to stop working. It works again if I enable Allow Edits, but then users can edit the data through the rest of the form. Is there a way I can allow edits to the combo box but not the rest of the form?

Gary

View 5 Replies View Related

Forms - Allow Edits, Only When Requested

Nov 29, 2003

Hello,

i am relatively new to databases so this is a fairly basic question.....

I have a form. Within this form all records are locked as i do not wish users to change details. However i am told there is an option allowing the editing of existing records upon request. is this true?, as it would improve my form greatly

help would be much appreciated

thanks.

View 14 Replies View Related

Is There A Way To Count Number Of Edits?

Aug 10, 2005

Hello,

I have a db where a planner inputs a commit date. The problem lately, is that the commit changes day to day before the part if filled. Management is looking for a way to count the number of times a commit field has been updated? Is there a better way to do this? I have minimal VB knowledge. Please help!

Thank you in advance.

Jymaly

View 1 Replies View Related

Tables :: Check Box Edits

Dec 26, 2013

I have a check box field in table, i want this field to be work as if once checked cannot be unchecked again... no worries if done through queries, vba etc

View 1 Replies View Related

Printing Form That Allows Only Certain Edits

Jul 11, 2014

We have 3 different sizes 1x3 2x3 4x6..I want to make 3 separate forms that have multiple sections that can be chosen.Upon Request I can Supply each separate Label with arrows to show what fields need to be changed for each Sales order.For the 1x3 Labels we Make:

1. ETL
- We change model #
- We Change if the Labels Says Dry Damp or Wet Listed.

2. MISC.
-One Plain Txt Box that can be edited in the center

For the 2x3 Labels:

1.Box Labels
-Customer
-Item
-Sales Order#
-Shipping Location
(For the Box Labels I was thinking I have a Table that holds all this data and all I would have to make is a Query then a form)

2.ETL
-Change Model
-Wet Damp or Dry
3.CSA
-Change Model
-Change the Wattage (3 Different Places)
-Wet Damp or Dry
4.MISC
-6 Text Boxes (From top to Bottom not side by side)

4x6 Labels:
1.HID Box Labels
-Item
-Watts
-Color
-Medium or Mogul Based

View 4 Replies View Related







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