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?
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.
Can anywone help me in this regard? :confused:
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?
View 1 Replies View RelatedDear Guys,
How to Establish the connection between Ms-Access2000 & Oracle using DAO Connection through Code?.
I created one table in Oracle and I created User-DSN in ODBC.
I linked that oracle table into Ms-Access MDB using Link table option in ms-Access.
Now, Whenever I open that mdb, we need to establish the ODBC connectivity automatically through code (I mean, we need to refresh automatically).
I need to hardcode all the information in the Ms-Access code.
My User DSN Name: abcd
Oracle Database Name: abcd
Schema Name(User Name): abcd
password: abcd
Hello all,
It's the first time I use VB.NET. I already use VB to connect to an Access database with ADO objects.
But now, I don't know what should I use and how.
For now, I have try OleDbConnection object with the Provider Microsoft Jet OLEDB 4.0
but when I connect to my database, I have the error following:
"Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
.....
Line 54: OleDbConnection1.Open()
......"
If you have any idea, please tell me
Lord
hi everyone,
i have an access file (access 2003) in my root folder. an ASP page where i select the records from the access database table. in this page all are working perfect. my asp code:
ASP Code: Original - ASP Code <%Dim adoConDim rsGuestbookDim strSQLSet adoCon = Server.CreateObject("ADODB.Connection")adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("testdb.mdb")Set rsGuestbook = Server.CreateObject("ADODB.Recordset")strSQL = "SELECT * FROM table_name ORDER by user_id;"rsGuestbook.Open strSQL, adoCon%><table bgcolor="#ffffff"><%Do While not rsGuestbook.EOF%><tr> <td><a href="somepage.asp?user_id=<%Response.Write (rsGuestbook("user_id"))%>"><%Response.Write (rsGuestbook("user_id"))%></a></td> <td><a href="somepage.asp?user_id=<%Response.Write (rsGuestbook("user_id"))%>"><%Response.Write (rsGuestbook("email"))%></a></td> <td><a href="somepage.asp?user_id=<%Response.Write (rsGuestbook("user_id"))%>"><%Response.Write (rsGuestbook("city"))%></a></td></tr><%rsGuestbook.MoveNextLooprsGuestbook.CloseSet rsGuestbook = NothingSet adoCon = Nothing%></table> <%Dim adoConDim rsGuestbookDim strSQL Set adoCon = Server.CreateObject("ADODB.Connection") adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("testdb.mdb") Set rsGuestbook = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT * FROM table_name ORDER by user_id;" rsGuestbook.Open strSQL, adoCon%> <table bgcolor="#ffffff"><%Do While not rsGuestbook.EOF%><tr> <td><a href="somepage.asp?user_id=<%Response.Write (rsGuestbook("user_id"))%>"><%Response.Write (rsGuestbook("user_id"))%></a></td> <td><a href="somepage.asp?user_id=<%Response.Write (rsGuestbook("user_id"))%>"><%Response.Write (rsGuestbook("email"))%></a></td> <td><a href="somepage.asp?user_id=<%Response.Write (rsGuestbook("user_id"))%>"><%Response.Write (rsGuestbook("city"))%></a></td></tr><%rsGuestbook.MoveNextLooprsGuestbook.CloseSet rsGuestbook = NothingSet adoCon = Nothing%></table>
when i click one of the links to view the details of each record, the page displays this error:
Quote: ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/some_page.asp, line 0
this is the code of my page:
ASP Code: Original - ASP Code <%Dim adoConDim rsGuestbookDim strSQLDim user_iduser_id = CLng(Request.Form("user_id"))Set adoCon = Server.CreateObject("ADODB.Connection")adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("testdb.mdb")Set rsGuestbook = Server.CreateObject("ADODB.Recordset")strSQL = "SELECT * FROM table_name WHERE user_id=" & user_idrsGuestbook.Open strSQL, adoCon%><table width="300"><tr> <td>UserID:</td> <td><%Response.Write (rsGuestbook("user_id"))%></td></tr><tr> <td>E-mail:</td> <td><%Response.Write (rsGuestbook("email"))%></td></tr><tr> <td>Telephone:</td> <td><%Response.Write (rsGuestbook("telephone"))%></td></tr><tr> <td>Fax:</td> <td><%Response.Write (rsGuestbook("fax"))%></td></tr></table> <%Dim adoConDim rsGuestbookDim strSQLDim user_id user_id = CLng(Request.Form("user_id")) Set adoCon = Server.CreateObject("ADODB.Connection") adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("testdb.mdb") Set rsGuestbook = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT * FROM table_name WHERE user_id=" & user_id rsGuestbook.Open strSQL, adoCon%> <table width="300"><tr> <td>UserID:</td> <td><%Response.Write (rsGuestbook("user_id"))%></td></tr><tr> <td>E-mail:</td> <td><%Response.Write (rsGuestbook("email"))%></td></tr><tr> <td>Telephone:</td> <td><%Response.Write (rsGuestbook("telephone"))%></td></tr><tr> <td>Fax:</td> <td><%Response.Write (rsGuestbook("fax"))%></td></tr></table>
any idea is acceptable.
thanks in advance
Hi :
I have a question of the connection between SQL Server and MS Access.
I have a project, which is using SQL Server as backend, we use MS Access forms as the frontend.
Firstly, I created the datbase (db1) in the SQL Server, and create a few tables in db1. And then, I create a few forms in the MS Access, I used ODBC connection to link tables from SQL Server to MS Access, it is working fine. Those forms can access the linked tables.
After it is done, I put the MS Access database in the sharing drive, many people can share the files in this sharing drive.
When I go to my associate's computer, and then open the MS Access database in the sharing drive. The forms is working, but, it cannot access to linked tables from SQL Server.
I go back my computer again and then open the MS Access database, it is working fine.
What's the problem with it?
Does anybody need to install SQL Server software and also have db1 database in SQL Server and the path?
I want any user can access the linked tables from SQL Server, but I do NOT want any user can open the SQL Server and open the tables directly. I just want the users can access the linked tables through MS Access Forms only. Because I will make security in the MS Access. So, I don't let the users modify/open the tables in the MS Access, the users must access the tables via the forms only.
Please tell me the steps how to solve it.
Please help.
Thanks.
Hi, I am completely new to ASP. I have experience in other programming languages, but for my job I need to use ASP, sigh.
Anyways, just learning ASP I decided to try a free host to "get to grips" with it. It has been great for the first couple days, and am moving onto databases.
I have hit a snag where I upload a simple MS Access database to the host (7host.com) and try and connect to it. I have tried W3Schools, and numerous other tutorials but none of them seem to work
This is the kind of code I am trying:
Code:Set conn = server.createobject("adodb.connection")conn.connectionstring = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=db1.mdb"conn.Open
Which comes up with this error:
Code:Microsoft OLE DB Provider for ODBC Drivers error '80004005'[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1238 Thread 0x10b0 DBC 0x267a024 Jet'./virtual/test.asp, line 16
Now, I really don't have a clue about ASP databases, so please be gentle ><
Thanks
virtual
I have a question about connection strings. Basically I have an access front end and an access back end. It works fine for now, but when it gets rolled out, I don't want to have to manually relink the tables every time. Is it possible to hard-code the database connection strings for all the tables used in the solution as the paths won't change once deployed?
View 4 Replies View RelatedI have an MS Access front-end with a SQL back-end database. It works great, I connect the MS Access front-end to the SQL back-end using a File DSN.
I have a few users (who are in the database the most) who get ODBC disconnection errors time to time. The cause of the error is not consistent, they seem to just appear out of no where. The table that reports the disconnection is not consistent either.
The only way for the users to resolve the errors is to exit the MS Access database, and then re-enter it.
I have had the DBA team analyze the SQL server, and it does not appear to be having any difficulties. We moved the database to another server (so it would be on a server with less traffic) and I rebuilt the File DSN. But the errors continue.
I will have the network team look into any errors, but I am not certain if they will find anything or not.
Has anyone run into this, and what resolutions did you come up with/work arounds did you perform? I am starting to consider upgrading to a Visual Basic .Net front-end, but wanted to see what options were left.
Thank you for your time.
T.J.
HiI currently have an Access Database in a BE/FE, server/client LAN architecture at a single office location. My client would like to allow one user to 'add new records' to the database on the weekends (i.e. after hours), without needing to come into the office.From my research, it seems I can setup Remote Desktop to connect from the client's home PC directly to the server PC, across the internet, using Windows XP Professional on both computers. Is it that simple, or should I be considering other things?
View 5 Replies View Relatedhi guys,
this is my first thread on this forum...,, i am new out here..
i am not able to establish a connection with a MS Access database. I am using DSN Connection for it..
The error that i am getting is...//
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
/airtickets/scripts/dbconn.asp, line 4
please help...??
I have a question about connection strings. Basically I have an access front end and an access back end. It works fine for now, but when it gets rolled out, I don't want to have to manually relink the tables every time. Is it possible to hard-code the database connection strings for all the tables used in the solution as the paths won't change once deployed?
View 9 Replies View RelatedI have a Access front end connected to a MS SQL database using a ODBC connection which is working fine of course.
When I compile it as a runtime version and install it on the business computer I get an error with the ODBC connection (I can't remember exactly what pops up). On the business computer I have installed SQL Native Client and in the ODBC added a System DSN (which works).
I am in need of consultation for MS Access reading data from ODBC connection. I have SQL Server that has all the data for the project financials etc.
I need a database that will read only certain data from the tables, for example, I don't need to import all 500,000 lines from SQL through ODBC connection, I just want to bring certain data for a list of projects whichever are opened and load only that data in MS Access so the group then can add additional details for that project in a shared MS Access.
Right now, all I can do is connect to that database through ODBC and brings all the data which I don't need all as it increases the size of the database, but just a criteria to specify which data to bring, if that's possible to do.
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?
View 7 Replies View RelatedHi all,
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.
Thanks for your time,
Today a guy who has done some Access programming told me that an Access table has a limit on the number of records.
Whereas I was thinking the only limit is the 2 gig size.
Which one of us is correct here?
(Access 2003).
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?
I have MDB database linked to SQL SERVER through VPN connection.I created links to the sql server Links are dsnless..Everything works fine but when I lost VPN connection or sql connection has been broken I can't refresh links to the tables.I receive message 3146 sql connection failed..I must close database and start again...
I tried different methods like ado,dao, and vba docmd.transferdatabase,aclink... but no success, table cant be relinked.
Only way I can relink is to change ip adress in conn.string
E.g. 192.124.0.2 (1st ip- router server ip) and after connection failed i can use 192.124.0.32 (2nd ip - server local ip) and that's it if i lost connection for the 3rd time... i must restart application.
It seems that access database keep the previous connection..how to reset or drop database connection to the sql server and refresh links to the tables with vba code without closing access database...
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.
Example preliminary test code:
Thanks in advance for any help provided regards.
Daryl
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?
Right Ok i hope i can get some help cause im absolutely stumped..
i cant get my login page to work since moving it from my PWS(iis on xp) DSN connection
to a 24/7 server on the net with DSNless connection
here is the code for the include file "conntopwd.asp"
http://www.pritchardwebdesign.pwp.blueyonder.co.uk/conntopwd.txt
the username and path has been changed slightly for security purposes,
and the code for the login page which attempts to access the database is here
http://www.pritchardwebdesign.pwp.blueyonder.co.uk/login.txt
the connection has been tested by one of the tech support guys at brinkster and he told me it was ok,
the problem was the way that the data is called from the data base is wrong ..
The tech support guy said that it was this line that was causing the problem..
MM_rsUser.ActiveConnection = MM_conntopwd_STRING
Any help would be much appreciated as im stuck for now..