Hi,
Does anyone have any ideas on how I might prevent a database from being copied. I have an application that I have set up with a number a tools to prevent exporting to an empty Access container, and from accessing the database design via the ShiftBypass feature, but the database can still be copied in its entirety. In some situations I would like to be able to add a feature to prevent this. Any suggestions?
FrankC
I'm new at all this so i'm sorry if it's a silly question, but i've split my db into a front and back end on a server but need to copy them and put a copy onto a laptop for my boss to take somewhere. How do i copy them so that they dont look for the other one in the server folder but on the hard drvie.
View 5 Replies View RelatedHello,
Excuse my inexperience, this is not my field. I am a network administrator and have never dealt with this problem before. I have been assigned the task of transferring a database (used by a security company to manage a gated community) to another system. I had to do this because the home owners association is changing security companies and they old security company is taking their computers with them. Now, I copied over all the files i could find and now that I am trying to set it up, I get the infamous error 3033, "you do not have the necessary permissions". I noticed that there is also a secured.mdw file. All i need to know is how to set up this database on a standalone system so that the new security company can access what they need. Thanks in advance for your help
-Nima Shariatmadari
Euclid Management
I have experienced a problem copying a database from a CDR to the C Drive of a networked machine at work. What happens is that the Database attributes are changed to "Read Only" after being copied. I can change this easily enough but i dont want other users to have the same hassle.
This problem does not occur when i copy the same CDR to my desktop or laptop at home.
Anyone know why this might be?
Can you copy the switch board (and all of its properties) from one database to another? how do you do this? i tried copying and pasting the switchboard from "Forms" But none of the properties in the switchboard manager transfered with it. How do you do this?
View 1 Replies View RelatedHi,
I created the database, which shared by multi-user. But, my user have a problem to open it. When user1 open the database, user2 cannot open it, I did not remember the error message, it is said that Admin (computer name) prevent you to open the database. But, if the user1 switch another application program (the database file is still opened), user2 can open the database, then both users can access the same database file.
Why do we have this problem? How can I fix it?
I have a database built using Microsoft Access 97-SR2. I want to copy it to another computer (my office computer). I was successful in burning the file to a CD-R disc. However, when I run the database from the disc, a message appears saying its READ ONLY-it apparently makes it Read Only automatically. I want to be able to change and edit the data and the controls, ie. forms, reports, etc. on the other computer. How can I transfer the database my other computer, without it becoming Read Only?
Any help would be appreciated
Urbaud
Hello,
I have a database that the table is located on a sharepoint website. This worked out well in the beginning but now that the database has thousands of records, it has slowed up a bit. What I want to do is at the load of the the database, it will automatically copy Sharepoint table to a local table located on the computer to speed up querys and such.
I was thinking an append query, am I right?
Mateo
How do I copy a form from one database that have reports and quaries linked to it to another so that I can change the information in the new database and keep the form style in the old database?
View 1 Replies View RelatedIs there a simple way of copying the same data down a column in Access similar to Excel with its Fill Down Column. I have tryed copying down a column and it only goes one cell at a time or if I copy 5 cells with the same data, I can copy it to 5 empty cells.
View 2 Replies View RelatedI need some code that checks if i already opened the database. I can't use the /EXCL option because 10+ people are also using it.
I had this code when working with Acc97 but i seem to have lost it.:(
If you are to sell a db. What have people done to stop one person copying it to their mates.
I have a way in which they send me their name,lastname and email. I then have a separate db that genertates a code based on a maths calculation. The users db does same calc. Then a comparison is done. if they match the code they entered goes green. if codes not right it goes red.
I also have macro that swap tables round when run. so by default its limted to 10 records. When swapped its unlimted.
I just cant link the 2 functions. Ideally some way it will see the green code and then run the macro to swap tables to a full db.
Then the customer has a full db and is also tied to their name etc...
Hi all,
I have a database stored in a folder, and this folder can be accessed through a Network.
Is there a way to protect users from copying this folder to other areas? That is I would like to restrict access from users copying the folder where the database is stored.
Thanks for any suggestions and help.
When attempting to open an Access DB that has been transferred from one network to another (via CD and aeroplane!) we are finding that the copy cannot be edited - the access is effectively read only... I believe this has something to do with Workgroup admin rights but this area is all a bit confusing for me. What do I need to do to open the copy up for editing - allowing the recipients to administrate their copy of the DB?
We're using Access 2002.
Is there away in which I can protect an access 2007 database modification with a password.I'm doing this because I would like to prevent my client from modifying or having acces to the database's back end system (db), I would just like him to use forms and nothing else.
View 3 Replies View RelatedI have a table called tblDeliveryOverview and a table called tblPurchaseOverview in the relationship there is no link between each other but i've used a query to link the one field from tblDeliveryOverview to tblPurchaseOverview.
How can i prevent a record update from happening when i update a record in tbleDeliveryOverview and the same gets updated in tblPurchaseOverview, which i don't want to happen.
I have a MS Access table containing Dependent social security numbers but some of the dependents social security numbers are blank.
I have a MS Sql Database that contains a table with most of the missing MS Access table dependents Social Security numbers.
How can I take the Dependents social security number from MS Sql Database and copy/update the MS Access table.
I tried the sql code below created from MS Access and it matches 453 records out of 460 dependent social security numbers but how do I update qryGHIAccuracyFile_MissingDepSSN.SSN with the social security number from dbo_depfile1.dep_depend_ssn
Code:
SELECT dbo_depfile1.dep_depend_ssn, qryGHIAccuracyFile_MissingDepSSN.SSN
FROM qryGHIAccuracyFile_MissingDepSSN LEFT JOIN dbo_depfile1 ON qryGHIAccuracyFile_MissingDepSSN.MemberSSN = dbo_depfile1.dep_ss_nbr
WHERE (((dbo_depfile1.dep_first)=[FirstName]) AND ((dbo_depfile1.dep_last)=[LastName]));
Updating MS Access table dependent blank SSNs with SSN in MS Sql Database.
I have a split database. I have secured the mde sufficiently but I need to secure the back end so that no one could link to tables in it. If I introduce a password to the back end is this going to require those using front end to supply the password? If not then this could be good solution.
As the database is on the network drive, is there any other way to prevent people to link to the db? Can I hide the db in the network drive? Or should I hide tables in the BE. Should these still be available to be linked?
I am supposed to make a database for a hotel system, how I could prevent double bookings.
My Reservation Table has the following fields:
Reservation No. (PK)
Room No. (FK)
Customer ID (FK)
Payment ID(FK)
Reservation In Date
Reservation Out Date
Together with preventing double bookings is there a way automatically that can mark in the Room Table, the status as "available" or "booked" automatically by looking at the date today?
I have built a database and within it my queries I use for reporting make tables in a separate database. This allows me to work in my data base and update info as needed. My problem is that my make table queries wont run if anyone has one of the report pivot tables open. I have added macros to all the Excel files that pull from the reporting DB but I still have several times when I cannot update because someone is using the pivot table, Is there a way to allow me to update the report DB's while the pivot tables are open? I have tried using manual refresh methods and disabling auto update on open but the result is the same.
View 2 Replies View RelatedI just finished a small Access-2013 database (accdb format).
Now I want to make it available to users.
How do I make an 'executable' (meaning that tables, forms, ... cannot be opened in design mode)?
Twice a year, a database of mine is accessed and put too use by various staff within a time range of 1 week. the database is on a shared drive and in a location which can be accessed by all.
The staff access the database from different workstations and in some instances at the same time.
This has only led to issues in the database being copied and then confusing staff on what database to click on thus i have 2 databases which i then have to sift through and copy/paste into the correct one.
I want to know the best way i can:
1) Prevent multiple users accessing the database at a time.
2) making a copy of the original and typing into a separate database.
I didnt know whether to post this here on in the table forum, so sorry if its in the wrong place!!
http://x402.putfile.com/4/10309543998.jpg
http://x402.putfile.com/4/10309512643.jpg
Ok, so in the frist screenshot the green box is based off of the table labelled 3. The red box is comprised of the InvoiceID from table 1, ProductID from table 2 and name/price is drawn from table 3.
The green box is used to view products, the red is an invoice. How do I add the currently viewed product (in this case, a case) to the invoice? I need to copy the product ID from table 3 to table 2. How do I go about this?
Many thanks! :D
I have an Access DB I have to put on numberous laptops. The DB is being transported via a CD. When i try to copy the DB from teh CD to a new folder on the laptop I get messages that the DB may have a virus and it cant be copied, or I need to install a microsoft service bulliten...xxxx ( I am not sure what the number is). The DB does contain VBA code and I am certain it is virus free. Is there some setting in access which enables this file to be copied on laptops which do contain virus or firewall protection or must I disable virus protection on these machines before instlaling the program or is it another issue altogether. Thanks.
View 3 Replies View Relatedim creating a fault logging databse, i have a form that shows all the "machines" details, (including its previous faults in a subform)
i have another form for inputting new faults.
what i want to be able to do is when you click on the "log new fault" the form will open up with some of the same details as the machine i was just looking at. e.g. it will auto copy over the "machine number" and "machine serial"
thanks
I have a db (sadly Access '97) for annual software renewals. Against each year there is a set of licences (can be up to sixty records), can anyone please tell me how from a form I can copy the licences from the previous year to the current year with the click of a button
View 1 Replies View Related