Getting Into An Access System
Someone, who is no longer working at out organisation, created a system in Access which we are trying to get into, however the creater put on some security which will not let us open the system to alter. Is there a way of getting into this?
View Complete Forum Thread with Replies
Related Forum Messages:
Access Quiz System
hi i am trying to make a quiz system using ms access i want to select 30 questions randomly from a questionbak of 100 or more also i need to select 3 answers randomly including the corect answer from answer bank that has 5 possible answers for each question tblquestionbank QID Question 1 Question1 2 Question2 3 Question3 tblanswerbank AID QID ANSWER CORRECT 1 1 Q1 answer a true 2 1 Q1 answer b false 3 1 Q1 answer c false 4 1 Q1 answer d false 5 1 Q1 answer e false the field correct is for identifying the correct answer yes/no filed so far i have been able to get the questions randomly that is generating a random number in the query and selecting top 30 records ideas and help would be appreciated
View Replies !
Implement Barcode System With Access
Sorry for the flashy post. 1.st Job: I have an access 2003 db. I want to implement barcode system to the DB in which I can print barcodes in any kind of barcode printer and also when imputing an order read data from barcode scanner etc. 2nd Job: I want to put access db to a server so I can view reports, forms, imput data and retrive data from internet explorer window (with a password). I will give my DB to you so you can work on it. Please do the pricing seperate for each job. Please PM or Reply if you have more than 500 posts. PLEASE RESPOND IF YOU REALLY KNOW HOW TO DO IT. Thanks in advance.
View Replies !
Multiple User Access To System Db
I have developed a database in MSA 2003. It uses a System.mdw that was originally created somewhere in the dark ages (MSA 97 or 2000). Multiple users cannot seem to access it at the same time. This has never been a problem in past projects. I have created a new System.mdw in Access 2003 and multiple users can access a database using the System.mdw. So I supposed my mdw is corrupt or simply mdw files created in earlier versions cannot be used by multiple users in MSA 2003. Has anyone experienced this problem and have any advice? Thanks in advance for your thoughts.
View Replies !
Access 2003 Using System DSN Problem
I have a system DSN, pervasive ODBC engine interface. In Access 2003 I can link to the DSN but can only link to some of the files. This started when I changed to a new computer. Before, I had a link to the same database using Access 2002 with no problems. Any help will be greatly appreciated. Brad
View Replies !
Access System Size Recommendations
Hi, I have been given an Access database to maintain and it has some performance issues. I have been looking through this forums for recommendatons regardng size etc but didn't really find anything. It is all in one file (might consider splitting it..) and it has about 350 forms, 300 database queries, 130 database tables and 200 Macros!! Filesize something around 200 MB. In one of the forms there is a drop down that when changed refreshes two other dropdowns. I have chyecked the queris used and they are really fast but it still takes at least 6-7 seconds for the 2 dropdowns to reload! I don't know if it is due to the way it is done, the VB code calls a macro that calls a query. Personally I wouldn't have done it like that but there has been about 2 years since I did anything complicated with access.. Or is it the size/complexity of it that makes it slow? Does anyone have experince of a similar system? Thanks /H
View Replies !
Legacy System Access 2.0 Migration Queries
First post, so I hope I'm following the post-etiquette! Anyway, I've just been employed by a company who still uses access 2.0 and lotus smartsuite. Basically I'm gonna have to migrate a few of their backbone databases to access 2000+ I've managed to find the old Microsoft access 2.0 book in the company amazingly, which is a help. I was just wondering if anyone knows any good sites for migration, or any particular problems that may be encountered. I'm just doing some background work at the moment, this won't be happening for a few weeks (hopefully!) Any help would be greatly appreciated. I'll just take this opportunity to say that I've found the site very useful in the last few weeks and hope I can contribute in the future when I break out of newbie status! -Spud.
View Replies !
Access Forms For Coder Entry System
I was recently asked to use access to create an entry system for our coders when they are coding videos. I was asked to create forms that only encompassed values from one table of a set of linked tables. I need the tables linked with referential integrity so that I can combine all this information in a useful way later, however whenever I try run my forms, except for the first form that connects to my "master table", all of the rest that need to link to it give me an error message about an inability to maintain referential integrity. Is there any way that I can have access treat my forms to all be a sequence. What I mean is that if I had a single form with all of my fields that were in linked tables, there wouldn't be a problem with integrity since all the changes are simultaneous. Is there a way I can have access treat all of my individual forms as one whole so it deals with the data in a similar way? Thank you in advance to anyone who can help me!
View Replies !
Playout System With Windows Media Player In Access
Hi, I've set up a database that is acting as an interface for another database that plays mpeg2 files on scheduled times. But now that I've come this far I was thinking of doing that last step too and integrate mpeg2 playout in my own database. I'm writing now to ask about what experiences others have of scheduling and playing mpeg2 files with Windows Media Player in Access? That is, is it easy to have a certain mpeg file played at a time that is in a field in a table? How can Access compare the computer clock and the time in the table field and start playing a file that has its path in another field in the same table? I've just recently realized that it's possible to do something like this in Access, but I'm not quite sure where to start. Or are there other options that are better than embedding Windows Media Player in Access? Thanks!
View Replies !
User Authentication System For Access 2007 Questions
Alrighty - After learning that 2007 has no User Security roles, and not having Sharepoint or a SQL server, I decided to work starting with Bob's Simple Login script located here (http://www.btabdevelopment.com/main/AccessSamples/tabid/54/Default.aspx). I've got it functioning fine and incorporated some of the options also made available here (http://www.databasedev.co.uk/login.html). You'll see the code below used to store info in a hidden form that is holding the username and permissions level. I'm looking to try and store this information into a global variable instead of a hidden table. I know that I could define it as a variable right here in the code, but how do I define it as a Global variable so I can use it later in the application in the VBA? Private Sub cmdLogin_Click() Dim strUser As String Dim strPWD As String Dim intUSL As Integer strUser = Me.txtUser If DCount("[UserPWD]", "tblUsers", "[UserName]='" & Me.txtUser & "'") > 0 Then strPWD = DLookup("[UserPWD]", "tblUsers", "[UserName]='" & Me.txtUser & "'") If strPWD = Me.txtPwd Then intUSL = DLookup("[SecurityGroup]", "tblUsers", "[UserName]='" & Me.txtUser & "'") Forms!frmUSL.txtUN = strUser Forms!frmUSL.txtUSL = intUSL Select Case intUSL Case 1 DoCmd.OpenForm "frmHome", acNormal Case 2 DoCmd.OpenForm "frmHome", acNormal, , , acFormReadOnly Case 3 MsgBox "Not configured yet", vbExclamation, "Not configured" Case 4 MsgBox "Not configured yet", vbExclamation, "Not configured" End Select DoCmd.Close acForm, "frmLogin", acSaveNo Else If MsgBox("You entered an incorrect password" & vbCrLf & _ "Would you like to re-end your password?", vbQuestion + vbYesNo, "Restricted Access") = vbYes Then Me.txtPwd.Value = "" Counter = Counter + 1 If Counter = DLookup("[OptionValueNum]", "tblOptions", "[OptionsID]=1") Then MsgBox "You have entered an incorrect password too many times. This database will now close!", vbCritical, "Wrong password!" DoCmd.Quit End If Else DoCmd.Quit End If End If End If End Sub
View Replies !
Avoiding Database Login Screen Everytime MS Access DB Moves To Different System
Hi - Currently I have MS Access DB which has some Oracle database table reference using database link concept. I have entered DSN Name,user id and password which it asks when I try to run some queries which will fetch data from oralce DB linked tables.If some wants to use my MS Access DB, they need to have DSN and everytime they run queries related to Oracle database table reference, it will ask for DSN,user id and password. For this I need to share the user id and password credentials to everyone who wishes to use my MS Access DB which I don't want to. Is there a way to avoid the login window whenever some one wants to use my MS Access DB without asking for oracle user id and password credentials everytime? My ultimate aim would be encrypt password for others. Thanks, Ashok
View Replies !
Spa System
I am new to Access and Ive created adatabase to control a spa system. I have several tables: Customers Employees Types Of Haircut - Their prices Types oF massage Their Prices Now I want To create a form where i am able to choose customer, the employee performing the haircut or massage The price should be displayed and the total AMount How can I do that? Should I create a Query and based on the query I create the form? Please Help!!! Thanking you all
View Replies !
System.MDW File
I am still a bit confused about the system.mdw file. I create FE and BE on my local computer and change name of system.mdw to say Jobs.mdw, after backing up system.mdw I then join jobs.mdw with my jobs FE and jobs BE and set secutity settings, etc. I then place FE, BE and Jobs.mdw all in the same folder. I now email jobs database with jobs.mdw file to client which places FE, BE and jobs.mdw in Jobs folder on server. Shortcut for fe is placed on each local machine. My question-Does Jobs FE and Jobs BE still access Jobs.mdw even though placed on another computer and possibly another version of Access? Does the shortcut have to reference Jobs.mdw? I need to understand this. Thanks, Jim
View Replies !
Payroll System
Hi All, Need your expert advise. Is it ok to develop a simple payroll system using MS Access or do i need switch to Visual Basic? Also, is there anybody can help what tables do i need to produce a payroll system, i.e. tblEmployee. Thanks, 19Summer95
View Replies !
Reservations System
I am creating a database to room allocation in a small hotel. I want the system to check room availability between two dates. What would be the best way to construct this in Access? Kev
View Replies !
Set An Equiry System
Hi, I am trying to implement my Database with an enquiry (or quotation) table and I am not sure I am heading in the right direction: -We use assemblies made of components and the data are held together in the database with a 'Bill of Material' set up. -A typical assembly is made of 1 or 2 bodies + Fasteners (straps and screws), -The body price is calculated depending on his weight and an extra costs can be added with extra tooling and machining, The costumer ask us for a quotation for various number of assemblies and we send back the estimation of the price, I am really struggling to see if my tables are set right and this is what I came up with (attached rr.zip): A main Enquiryfile Table is linked to an enquiryDetail Table which would record each individual item information for each Enquiry. I have also added a Extracost detail table that would record all the Machining and extra pattern making cost for each assembly. And finally, and that's what I am far to be sure about, a TblChildItemCost where the price of each components would be recorded (for each enquiry detail). The body price is based on his weight but also depend of various market exchange rates, that is the reason why I have created a table for the price of component for each enquiry. I really hope someone can help me on that one...Thanks in advance.
View Replies !
System Tables
Hello, My application I develop should retrieve some meta data from Access system tables. It should find: - What tables are stored in database. - What columns have each table in database. - What relationships are between tables in database. I opened systems tables of some .mdb file and took interest in such kind of information. But I got some problems by looking for what exactly I need. Please, could someone help me at these points: 1) I found that in system table MSysObjects I can find names and ids of tables created by user (for example by me). But how to determine that these tables are created by user and they are not let’s say a system tables? 2) I didn’t find any meta data about columns of tables! How to determine what columns has each table? I created application which uses MS SQL Server to retrieve such a kind of meta information and there where no problems. But I stuck using Access. I was looking for some information in Internet but ineffectively. Please, help me...
View Replies !
Hire System Help
I have two tables, one named Loan and one named DVD Details. On my DVD details table i have a field name, on_loan with a data type yes/no. I have created a form called LoanForm where i want to select a DVD with a combo box, then select a Set loan button that will set the corresponding DVD on_loan field to yes(true), in the dvd form. on the button i have the following code Private Sub HireDVDButton_Click() Update dvd Set car.on_loan = True End Sub But it doesn't seem to set the on_loan field in the DVD table to true, which is what i want to do. Sorry if it's not clear what i want to do. I am just a beginner. Thanks in advance :)
View Replies !
Difficulties With System
Hi, I’ve been having some problems being able to do some things on my database, I was doing ok creating my system but now I’m a bit confused about what to do and I’ve been trying but getting no where. Firstly on my order form I need a total for the products which are in an subform and after the order is complete I need to be able to create an invoice and keep all the order information in the 'invoice' and 'invoice details' tables. I also need it to update the stock levels after the order is complete. Then I had created a tab in 'view customers' and I wanted to have it so that past customer orders could be viewed. Any help is appreciated; here is a link to my system: 'Gamez System' (http://www.savefile.com/files/5877934) Thanks, Bob.
View Replies !
Checking If The Same Name Is In The System?
I have a form where I enter student names, and it often happends that I enter the same student a couple times, Is there any way to let the user know that there is allready someone in the system with the same name, like a pop up message.:confused: thx
View Replies !
|
TRACKER
