Prevent To Open The Database
Jun 5, 2007
Hi,
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?
View Replies
ADVERTISEMENT
Feb 18, 2008
I 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.:(
View 2 Replies
View Related
Mar 19, 2013
I'm using "Application.FollowHyperlink" to send parameters to a remote application.
Each time i hit the enter button an 'After Update' event opens a web page.But i don't want the web page to be opened.
is there another method to send parameters over the web without opening a web page?
View 2 Replies
View Related
May 28, 2007
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
View 7 Replies
View Related
May 23, 2013
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...
View 11 Replies
View Related
Aug 6, 2013
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 Related
Dec 1, 2013
I 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.
View 1 Replies
View Related
Jun 25, 2015
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?
View 6 Replies
View Related
May 23, 2014
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?
View 3 Replies
View Related
Jul 10, 2012
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 Related
Nov 12, 2013
I 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)?
View 9 Replies
View Related
Feb 13, 2015
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.
View 7 Replies
View Related
Aug 22, 2014
i have a database that runs updates from within itself.what i need is, this database to then open a another database run a update query, then close it.
View 4 Replies
View Related
Jun 1, 2005
What is the best place to have opendatabase statement ? Currently I have opendatabase in all of my forms. I dont have any modules in my application. I am new to access programming. Is module really necessary in an application?
If I can put the opendatabase statement in one place, it will be easier for me to change the database name and path, if I have to..I dont know how to do it.
Can anyone help..I hope this one should easy for many of you people.
Thanks very much.
View 10 Replies
View Related
Feb 21, 2006
Hi,
I've run across a couple issues with our database. The most immediate issue is that I have been unable to open the database on any networked (or non-networked) computer. Me and a assistant typically enter data into this database from two seperate computers. She works on a wireless networked computer with the file on my computers hard drive. I work directly with the file. My computer is wired to the router. (in case that information helps)
We keep getting errors about "cannot access remote computer" and such, they seem to occur when she's entering data and I have the database open, then close Access. It will often give her the error and not allow her to save the record.
But just today she entered something, I closed my database window, then reopened it and I could not get in. All network computers rebooted, and still cannot get into the file. I can enter the password and then it goes to just a blank area (like when your first open access with no database). Older backup versions of the database still work, so it doesn't seem like an Access error. I also noticed that the little "LockFile"s are not being created (I ever faked one just to try it out and it deleted it after i entered the database password)
I can't repair, or convert or anything, it just asks for the password, I give it...and then nothing.
I'm very lost. Thanks for any help.
View 5 Replies
View Related
Mar 29, 2006
I have one database and I want the ability to click on a button and open up another database. Can I do that?
View 1 Replies
View Related
Apr 8, 2006
I can't open my database...
It was open yesterday and after a power failure computer turned off...
2day I can't open it...
Messege box says something like ---database was open--- not properly closed--- etc. etc. and can't perform auto repair...
I tried to import the objects in other database but can't do that as well...
Is there any way to repair the database???
Thanx and regards,,
MPB
View 4 Replies
View Related
Apr 11, 2013
I have problem once each day when I open Access for the first time. I get an error message "Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.". It asks for a file name and insists on compacting (I think) and saving the database. I go through this several times saving it under a diferent name each time until I get the warning "Security warning Some active content has been disabled. Click for details." with a button to disable it.
View 13 Replies
View Related
Nov 3, 2005
Hello. I haven't seen this before with Access; I've searched the forum and haven't found anything yet...
I have an Access database that was being used by about 9 different people. Everything was going along okay, but one day it became read-only for no reason. Once everyone got out of the DB it said it needed repairing. So with only one person in I ran the repair, but the horror-inducing message "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." appears and when I click "OK" on the message nothing happens whatsoever.
Luckily backups existed, but some data was lost. Is there anyway to run a repair on the database that won't open? Or is it a lost cause?
Thank you! :D
View 3 Replies
View Related
Jan 3, 2006
We've got a client that runs two access 97 based databases on their network. up until recently both databases worked
fine on all workstations (all XP Pro).
About 3 weeks ago they called me to report that one of the databases would not load on 3 workstations. It opened
fine on all the others. I checked out the permissions on the database (which is stored centrally on the server) and
everyone had full control.
Within the last week they have added two new xp pro workstations to the domain - neither of which can access the
database in question. they can access the other database no problem - as can all the other workstations.
The occurs as follows:
1. Double click on the icon for the database
2. access 97 loads but does not load the database's interface - instead it opens an empty version of access (with
file menu etc at the top)
3. no specific error messages at all.
4. close access and the standard xp program crash message appears (see screenshots below)
As mentioned above, other workstations can open the database fine.
the only thing that has changed on the network is the installation of some server and workstation based production
software - we have not yet consulted with the company that installed this - we felt that if it was this software
causing the problem then all workstations would be suffering. we wil have to consult with them once we've exhausted
all the possibilities.
Thanks in advance for any advice
http://www.techresource.co.uk/error1.jpg
http://www.techresource.co.uk/error2.jpg
View 5 Replies
View Related
Feb 13, 2006
Hello all,
Please help with this:
On opening my database, I have a switchboard that opens up.
How do also run a report automatically just after the switchboard screen opens. To make the switchboard open when I click on my database, I went to tools..> startup. But I don't know how to run a report automatically after that.
Thanks for your help!
View 3 Replies
View Related
Jun 7, 2006
I am getting the following Error:
"This database is in an unexpected state; Microsoft access cannot open it.
"This database has been converted from a prior version of Microsoft access by using the DAO CompactDatabase method instead of the Convert Database command on the tools menu. This has left the database in a partially converted state.
"If you have a copy of the database in its original format, use the convert database command on the tools menu to convert it. If the original database is no longer available, create a new database and import your tables and queries to preserve your data. Your other database objects can't be recovered."
The database is on the server. Nothing was changed. Someone in our IT department says they simply opened it and then closed it. I think that they had their access program set to compact and repair on close.
I have tried to import the tables but am gettting the same errors.
I have the original database but it is an old backup that is missing data.
Can someone HELP
View 1 Replies
View Related
Oct 19, 2006
I have copied a work database onto my flash drive and then onto my laptop to do some work in it.
Now I can not open the database because it has the error message.
You do not have the necessary permissions to use the database etc...
I have copied the Application file, the Data file and the Workgroup information file and the only one I can open is Workgroup information file. I have tried holding the shift key down as well.
Any suggestions as I have heaps of work to do and I have tomorrow away from work to do it.
View 1 Replies
View Related
Jul 13, 2007
I have a user who is having trouble opening a database he created. Here is his description.
I am having an issue with Access that has occurred today and once several weeks ago.
First, I build a complex database for Safeway report. It functions correctly, I can access it from excel.
Problem, I go to update or modify the databases, Access gives me the macro message which I override.
The access database window will not open, no error appears, just a blank access screen with tool bars above.
I have tempted to do a compact and repair of the database which did not help.
Microsoft Online help says the issue can be cause by old Anti Virus Software.
The database will permit excel to pull data from it.
Does anybody have an answer.
View 1 Replies
View Related
Jan 7, 2008
Is it possible to open a database from a form in a different database? Not necessary to do so; it would just be handy to do from the form I already have up and looking at rather than having to go open another instance of access and go to that database.
View 8 Replies
View Related
Jan 17, 2008
I have two databases, one is much larger than the other, but both have the same start up code. The larger database opens quickly, but the smaller database takes forever. I tried compacting and repairing the front end and the back end of the database, but that did not help. Any ideas on how I can speed this up?
View 4 Replies
View Related
