Hi,
I'm actually concepting a new site about travelling, in this web site people will be able to post the stories about there travelling (in french its called 'carnet de voyage') So lets say i will let limite texte to around 2 pages and will let upload 15 picture (but have a mini picture and a big picture, so in fact its 30) and i will limite weight for big at 100ko, but pictures is not uploaded in database.. only the link to the uploading file..
The language i want to use is asp and want to use an access database.
My question is considering that if my web site would become 'popular' and let say i have 200 hundred members who have post there stories. it would do about 3000 entries on pictures, and let say that 100 peoples looking at stories at the same time, is this gonna slow down my database or even crash it?
ps: im canadian (french) so sry if my english is a little bad, i have do my best to explain clearly.
I am creating an access database and I want to know the following limitations;
1. Maximum number of users who can log into the database at a time
2. Maximum size of the database. Here I understand that it is 2GB, but I am confused as to whether it is for .MDB file or for each table in the database.
I have a website writen in ASP and connected to Microsoft Access.. Why several people is telling me they couldn't find my website, it's not working. But they didn't tell me what is the error are they getting..
I get about 50 hits daily. Could Access handle this type of job?
How many records does MS Access 2003 hold, i.e. is there a limitation & what is it?The toolbox greys out after being selected on the Menu options even though Tools/Startup/allow built-in toolbars is selected - how to activate the toolbox in 2003 version?
I wonder if anyone can help me. I have a table in my database which currently uses 9 fields to make up the primary key. I wanted to add a further 2 fields to this to make 11, however Access will only accept 10. Does anyone know any way around this please?
I'm getting an error "The setting for this property is too big" for my combo box when trying to load 2 columns (fields) of about 2,000 records using a stored proc (SQL SERVER 2000) to access 2003 as my front end. If i only load the customer number.. one field it does it.. but as soon as i try adding the customer name next to each number I get this error, is there a limitation to the combo box that I'm not aware of?
A newbie to Access I created a table to store data of my clients. One of the fields in the table was set aside for the A/c Nos (Primary Key) for my clients. An example of the A/c no looks like this : 57051-01 After setting the A/c no as the primary key, I cant key in the "01" The field only allows me to key in 57051. Is there any way to overcome this? Pls enlighten me!
Hello, I have a database that has 63 fields. I want to do a query that will give me one aggregate number for all 63 fields. When I try to run it through the Access Query GUI, it only allows me to select 43 of the 63 fields then the buffer is full. So I tried through the SQL GUI and it's better but still will not get the entire 63 fields. So last I tried through the MODULES and wrote a quick VBA and it tells me the string exceeds the 1024 character limit. ARRRRG!! What I'm trying to do is this:
SELECT qryGrpByUL.CellName, ((([qryGrpByUL]![UL0]+([qryGrpByUL]![UL1])*1)+([qryGrpByUL]![UL2]*2)+([qryGrpByUL]![UL3]*3)+([qryGrpByUL]![UL4]*4)+([qryGrpByUL]![UL5]*5)+([qryGrpByUL]![UL6]*6)+([qryGrpByUL]![UL7]*7)+([qryGrpByUL]![UL8]*8)+([qryGrpByUL]![UL9]*9)+([qryGrpByUL]![UL10]*10)+([qryGrpByUL]![UL11]*11)+([qryGrpByUL]![UL12]*12)+([qryGrpByUL]![UL13]*13)+([qryGrpByUL]![UL14]*14)+([qryGrpByUL]![UL15]*15)+([qryGrpByUL]![UL16]*16)+([qryGrpByUL]![UL17]*17)+([qryGrpByUL]![UL18]*18)+([qryGrpByUL]![UL19]*19)+([qryGrpByUL]![UL20]*20)+([qryGrpByUL]![UL21]*21)+([qryGrpByUL]![UL22]*22)+([qryGrpByUL]![UL23]*23)+([qryGrpByUL]![UL24]*24)+([qryGrpByUL]![UL25]*25)+([qryGrpByUL]![UL26]*26)+([qryGrpByUL]![UL27]*27)+([qryGrpByUL]![UL28]*28)+([qryGrpByUL]![UL29]*28)+([qryGrpByUL]![UL30]*30)+([qryGrpByUL]![UL31]*31)+([qryGrpByUL]![UL32]*32)+([qryGrpByUL]![UL33]*33)+([qryGrpByUL]![UL34]*34)+([qryGrpByUL]![UL35]*35)+([qryGrpByUL]![UL36]*36)+([qryGrpByUL]![UL37]*37)+([qryGrpByUL]![UL38]*38)+([qryGrpByUL]![UL39]*39)+([qryGrpByUL]![UL40]*40)+([qryGrpByUL]![UL41]*41)+([qryGrpByUL]![UL42]*42)+([qryGrpByUL]![UL43]*43)+([qryGrpByUL]![UL44]*44)+([qryGrpByUL]![UL45]*45)+([qryGrpByUL]![UL46]*46)+([qryGrpByUL]![UL47]*47)+([qryGrpByUL]![UL48]*48)+([qryGrpByUL]![UL49]*49)+([qryGrpByUL]![UL50]*50)+([qryGrpByUL]![UL51]*51)+([qryGrpByUL]![UL52]*52)+([qryGrpByUL]![UL53]*53)+([qryGrpByUL]![UL54]*54)+([qryGrpByUL]![UL55]*55)+([qryGrpByUL]![UL56]*56)+([qryGrpByUL]![UL57]*57)+([qryGrpByUL]![UL58]*58)+([qryGrpByUL]![UL59]*59)+([qryGrpByUL]![UL60]*60)+([qryGrpByUL]![UL61]*61)+([qryGrpByUL]![UL62]*62)+([qryGrpByUL]![UL63]*63)/63)-110) AS TotalOfUL FROM qryGrpByUL;
The output is the mean of all the fields and should give me an output that looks like this
CellName TotalOfUL Site1 -85
Is there another route I can take? The database is not a security issue. If you would like it, I'll be happy to pass it along. I am also very flexible. I can modify almost anything for a suitable outcome.
I haven't been able to find if there is a maximum length of text within a textbox.
I have a form on a club database, and one of the textboxes has the details of their photographic experience. I have one person who is a very experienced worker and I need to add more details in the textbox. Currently there are 29 characters, including spaces in the box, but it won't allow me to add any more. I have set the width of the box on the form to a wider setting, but this makes no difference. What can I do?
Hello all I was wondering if there is limitation to the number of IIf statements that can be nested in a calculated field. Basically I need to assign a particular ‘label code’ to a record that will be derived from data with in several fields within the query. The data from the table (that the query is derived from) will be completely deleted and recreated on occasions, meaning I can not write data back to the table as it would be lost when the re-creation happens. There is a possibility of many derivations for the ‘label code’ (maybe up to 100) so the nested IIf code will be substantial. If there is a better way to do what I want I am all ears however I am not a VB programmer so would rather stick to doing within the query design grid, or SQL at a stretch. Anyway the main focus to the question is there a limitation to the number of nested IIF statements.
I have a form that supervisors use to input employee accountability for each day. Once supervisor completes the input, a command button is selected and records are appended to an archive table and then deleted from the "live" table. End of the month, reports pull from the archive table to tally absences.
The problem: when a supervisor submits the daily status report but resubmits the report do to an input error I now have two records for the one reported date.
How do I pull the end of month report without including an earlier record for a duplicate date? Is it possible to have access overwrite any records previously submitted for that day?
We have a database with one main data entry which stores records in a seperate table. There are several thousand records keyed in using this form. Therefore, alongside the entry we have a search form which allow the user to search for a specific record and display it in the main if he/she needs to edit one.
We have received a request from users for a functionality which allows users to browse all records, using the main form layout, that they have keyed in. I guess what I am asking is: Is there a way to limit the records visible in a form using field on that same form as a limitation (ie. the users name - which is a required key-in)?
I have installed Microsoft Access 2003 and Microsoft Access 2003 Developer Extensions. I can create Access application by using the Package Wizard. But after I upgrade from Microsoft Access 2003 to Microsoft Access 2007. I can't use the Package Wizard.
Hi, I have been using "fSetAccessWindow (SW_HIDDEN)" in the open event of my main switchboard to hide the grey Access screen from being visible behind forms, reports, etc in this db. But when I started using a .vbs script file to launch the db, the Access window stopped being hidden. (The reason I use the script for launching is that it temporarily sets the db's security level to 1 which stops the macro security warning from coming up.) Apparently MS knows about this happening and released a technique to rectify the situation, but I don't understand their instructions. It looks like they expect one to have more understanding than I have. Could someone help me get this impliemented? Here is the article: http://support.microsoft.com/kb/167659/en-us Thanks!
Hi! This is Kishore, working on VB Project which is using MS-Access95 as backend. Now, i want to change the Database login Password. Could anyone guide me in this context.
Using Access's User and Group Accounts or Using a Login Form to access database?
I've been researching on how to make a database secure. How to create User and Group Accounts on access, I see the step by step instructions and tried it out myself.
I also saw some sites where they give an example of a Login Form and how to create one.
My question is do you need to create both. First create the users and groups to permit or deny access to certain forms and then have a login form?
But would that mean that they'd have to login twice? Once when the database opens because it activates the db security that was created and then login again in the login form that was created?
Also when the user logins in and clicks on the cmd button on the form which opens up another from, frmWorkLog, I have an Employee field. This field I want it to have the user's name entered automatically and "locked". So that info, employee name, is extracted from the user's login. So then the user can only see his or her records only and no one elses.
How would I go about creating that. Hope I made my explanation clear.
I have two database applications and they are: - the (A) application is for administration use. - the (B) application is for normal users use.
the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...).
the (B) application I have created for normal users who will have only to use forms to insert some data and display data only.
but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data.
The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys.
I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.
I have a simple access search form , that's based on a query that fill parameters from the form textboxes, when the access form loads its keeps prompting for parameters value which looks ugly .. I want to open the form, displaying all the records in the table and filter when i click search ..
I have a data entry entry form, that i want to generate success message after successful insert in database. I have done it in the button event if no error happens, still if i left all fields blank and clicked save, it displays the message ..
I need to change that to display please fill the textboxes then click save , and display success message when the row is actually inserted ..
I've been using the following code successfully in Access 2003 & now I need to migrate to Access 2010. The purpose of the code is to use the items that the user selects in the list box to build the criteria of a query. Access 2010 keeps giving me a syntax error when I try to run the query & I don't know why:
My code is:
On Error GoTo Err_Command151_Click
' Declare variables Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim varItem As Variant Dim strCriteria As String Dim strSQL As String
[Code] .....
The syntax error I get in Access 2010 is:
Syntax Error in query expression 'SELECT * FROM qryContractListSummarybyDateContract3TYPEBREAK WHERE qryContractListSummarybyDateContract3TYPEBREAK.Rep ortableName IN('Adbri Masonry NSW');'
Attached is a screenshot of the relationships in a database I built a couple of years ago. It's worked absolutely fine in Access 2003 and currently has over 18,000 customers with associated information in it.
However, when I open the database in Access 2007 the performance is awful. All the forms are very slow to respond when tabbing between form elements. I've experimented by reducing the number of form elements calling on related data on a given page and whilst this improves performance it reduces usability - something I don't want to compromise on especially since Access 2007 should be able to cope with this.
My next question is therefore whether I've got the most efficient underlying table design and I can't see any other way of doing it than my current method so I'd be grateful for any feedback or advice anyone has.
I have a stock control database which i have nearly completed. This has Manufacturer, which is linked to products, which is linked to Sub Product(which also has field partCode). i.e. Manufacturer1 can have 3 products, and each of these products could have 5 subsystems and partcodes. Each partcode is unique to that subsystem/product/manufacturer.
I then have a pricing spreadsheet in excel, which has many tabs. A new column has been added for each item for Manufacturer,Product,Subsystem and Partcode.
I need to import these manufacturers,products,subsystems and partcodes, but into the tables with the correct relationships, i.e. product1 and product2 are products of manufacturer1 and so cannot come under manufacturer2, and so on.
I hope this makes sense, Thanks in advance for any help you can give!
I am working on a massave aplication that has been running in Access 2000, but recently several of the file sharing users have installed Access 2003 because of the limited availability of Access 2000. All the users are using the same file off the server.
The problem we are having is that when we reference a subform in the "[Forms]![FormName]![SubformName]![FeildName]" Access 2003 does not recognize it and returns an error. I have found that if I will modify it to "[Forms]![FormName]![SubformName].[Form]![FeildName]" it is recognized in both 2000 and 2003.
To try and change every instance of a subform reference will take forever and I am garuteed to overlook something. We reference subforms all over our program, missing any one of them would be a disaster. Before I went to the tedious task of looking through everything I just wanted to throw the situation out there and see if any of you had any great ideas on how to get it fixed efficiently. I would apreciate any ideas.
I have made a form on access which will be used by other employees within the company, however they have never used access before and they are wanting to access only just the form as I feel with Access and all the tools in the background will confuse them, plus I don't want them editing the data base its self.
Is there a way to only bring up the form, unless I obviously need to edit the date base.
I've done some research on Google and it seems I need to use:
SW_SHOWMINNOACTIVE
However I can not seem to find how I would use this or where?
and also if i did find a way to only bring up the form, how would I be able to switch it from that veiw to the veiw I edit in?
I upgraded a 2000 db to 2003 recently. When I ran the function below it gave me an error on the line in green. Any thoughts? Thanks. Const FIRSTROW = 13
Dim wsp As Workspace, dbv As DAO.Database, tblResolve As DAO.Recordset Dim tblVchs As DAO.Recordset, tblImpTmp As DAO.Recordset Dim ObjXLApp As New Excel.Application Dim FileToOpen As String, WhereCriteria As String, ImportTemp As String, tmpVch As String Dim TotalDupes As Integer, TotalGood As Integer, TotalRejects As Integer Dim TotalBlank As Integer, R As Integer, C As Integer Dim BadSheet As Boolean, ImpFail As Boolean Dim tmp, tmpType, tmpCtr, tmpRsn
If Forms![Import Block Vouchers]![Import Program] = "0" Then MsgBox ("You must select a Program to load.") ObjXLApp.Quit 'Exit from MS Excel Exit Function End If
