Access Limitations
I am getting ready to start a rather large website for a company. Its basically going to be a auction type website. This site has the potential to get extremely big if they market it correct. My question is can Access handle it?
I've heard there are certain size limitations in Access, but have never heard what those are. Has anyone out here actually reached those limits? Also how hard would it be to convert a Access db to SQL Server 2000? Is there a conversion tool within SQL Server or Access?
View Replies
ADVERTISEMENT
I am having problems with CSS expression. I have setup page that expresses some inline CSS within a repaet region. I am finding that after around 25-30 repeats the CSS stops expressing. The CSS is designed to set the size and position of a table and after too many record repeats it stop positioning the tables in internet explorer.
This may be a browser limitation becasue when I examine the source code of the expressed document the CSS is intact but it is not showing up in the browser.
View Replies
View Related
I am using variable passing through the url, and as it is getting larger, I am finding that occassionally some values are getting trimmed. Is there a limit to how long a url can be?
View Replies
View Related
I need to use an script that uploads via one of these three components: ASPUpload, SA-FileUp or SmartUpload.
If any of you have some recommendations or know upload scripts using one of these components, it'd be great. Unfortunately, I need it to be able to upload huge files on the server (300 megs).
View Replies
View Related
I would like to know what I am allowed to do in Sub OnTransactionAbort and
what I am not allowed. (Or where can I find some material about this.)
I seem to have experienced that I am not allowed to do further database
transactions and cannot see the global variables. I can see Session
variables and do file transactions, however.
View Replies
View Related
Just migrating some code from CDONTS to CDO and noticed some behaviour I want to verify.
When using cdoSendUsingPickup the outgoing email spools to the local filesystem first before being routed out. When using cdoSendUsingPort it goes directly to the remote email server and seems to bypass the virtual SMTP server running on the local machine (which can be stopped). This is all fine.
I noticed that sending emails that exceed the maximum filesize limitation set in the SMTP server properties pages only seems to trigger an error when using port, not pickup. Is this expected?
View Replies
View Related
i need to use bigger numbers that integer allows in asp. what should i use? i still need the whole number quality of the integer, but when i use anything larger than about ,100,000,000 i get the error Overflow: '[number: xxxxxxxxxxx]'
with the x's being the number i used. anyway around this?
View Replies
View Related
I am coding an ASP script, which currently requires a 5-dimension array, i.e. array(a,b,c,d,e)
I remember reading somewhere, a long time ago, that there is a limit to the number of dimensions in ASP. That was a long time ago, and I don't remember.
View Replies
View Related
ASP based Cookies. What is the limitation in data you can store with them? 4kb? How can you get the current size of Cookies your domain has placed on the computer? Another thing. Are ASP based cookies actually written to the client computer, like javascript ones are; or are they stored in sessions?
Sessions. I know a Session can hold quite a bit of data, but I never found a limit. All I know is the more data you place in a session, the more resources the server is losing. Can anyone recommend how many different keys I should place in a session?
I usually hold things like Username, Password, AccessLevel and one or 2 other preferences, but I'm not sure if that's too much as is. What other common ways are Sessions used for?
View Replies
View Related
Does cookies have any limitations when used in frames?
View Replies
View Related
I'm looking to manage an email list with SQL server and send out newsletters. Does anyone have an idea of the limitations of sending emails with CDONTS.MAIL object? How long would it take to send out 1000 emails via asp. I guess there are many variables with that, but that's say there were no attachments and we have 15k emails. These news letters really will only be sent once a month or so. But lets say our list grows to 10000 users or even 100,000. Is that a good idea to send 100,000 thousand emails through an asp page? I wouldn't think so .
View Replies
View Related
Users are required to log into my website. I store the users name in a session variable. If the user doesn't log out and the session expires after 20 minutes, is it permissable to have code in the session end function of the global.asa which accesses a database and makes alterations to the users login status?
The reason I ask this is that I am having problems trying to get the logout to work for sessions which have timed out. If the users logout using the logout button, the code works fine.
View Replies
View Related
I'm trying to implement the server.execute instead of using SS includes in a new project I'm doing. the server.execute command will not transfer variables or classes/subroutines defined on the other pages. Is this correct?
That's what I'm seeing but I want to be sure that I'm doing it right. I had to go back to SS includes to include my functions and classes I have stored in other files.
View Replies
View Related
I have installed aspSimpleUpload and can upload files, up to 8 megs. However, I need to be able to upload any file size without any restrictions. Are there any file uploaders that I can use that will solve this problem?
View Replies
View Related
I've been trying to use javascript for form validation. I want to get all the validation done in one function since it seems onSubmit can only handle one "return functioname()"
But there seems to be strict limits to javascript function complexity. For example, it seems I can't do this
if ( (a < 3 && b < 2) || (c < 5 && d < 9))
it seems I can't do any 'else if condition x'
also it seems I can't do any nest 'if condition return true'. Is there a way for a single javascript function to handle many different form validations? Or can onSubmit handle more than one returning function?
View Replies
View Related
I have a Development server that is running Win2k, IIS 5.0, and ASP enabled. I am trying to gain access to an Access 2000 DB located on a file server within my domain. I'm pretty sure I have all the correct permissions set, but I am having problems when trying to access the DB.
The error is similar to:
The Microsoft Jet Database engine cannot open the file '******'. It is already opened exclusively by another user, or you need permission to view its data.
I'm looking for ways to fix this... Microsoft suggests turning off the ability for IIS to sync passwords. Unfortunately, this is not a viable solution for me.
Is it possible to create a new virtual server that is a share to my file server? Put my ASP and MDB file in there and have it work? Anyone have any other ideas?
View Replies
View Related
I'm working on a site that inserts records into an Access database and Access assigns an auto-incrementing id for the record. How can I quickly figure out what id that was just created? I seem to remember there being a function for this....
View Replies
View Related
I want to move my only window shosted client to linux. The site they have access a Microsoft Access database with the below code but i can't get it to work under Linux.
<code>Dim MM_connPang_STRING
'MM_connPang_STRING = "dsn=pangDSN"
MM_connPang_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:clientdatabasepangDB.mdb"</code>
View Replies
View Related
I'm trying to access a table in a MS Access database using ASP but the name of the table is causing me some trouble. The problem is the table name has a space in it eg, "My Table".
If i try and access it using a query "SELECT * FROM My News", it says i cant find table "My". If i remove the space from the name (to MyTable) it works fine. But the trouble is its a customers database and i cant easily rename it because its linked to other tables and db's.
How can i access a table with a space in its name? I've tried "SELECT * FROM My_News" but that doesnt work either.
View Replies
View Related
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ".
The 'F:' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.
View Replies
View Related
I'm looking to make an online multiplayer game which will utilize Access Database... basically I require thousands of people writing and reading from the same database... I was wondering if this is possible for that... or is mdb file restricted to 1 person at a time...
If it is limited what would you suggest as the best way to control an interactive online environment? .txt files possibly?
View Replies
View Related
What is this all about? Generally I run against SQL Server but now I have to use access. The query I want to run is a simple double join
SELECT tblArtists.*,tblGenres.name AS genreName,tblPages.pageId
FROM (tblArtists
INNER JOIN tblGenres ON tblArtists.genreId = tblGenres.genreId)
LEFT JOIN tblPages ON tblArtists.artistId = tblPages.artistId
ORDER BY surName ASC, firstName ASC
Now If I run this question in access against the database it accurateley returns two posts. BUT When I paste the same query into an asp document and runs it with a fileDSN against the same database it returns nothing!? Is this some kind of joke from Microsoft?
View Replies
View Related
I have an Access DB which contains couple of link tables. All these tables are from different databases. So each one has it's own database password. Since there is no way to save the password during the DSN creation. Then you need to manually type in the password each first time when open the table.
This causes the problem in ASP code during run a query. Since the table cannot be accessed due to the password protection. Is there any statement than can open a table and meanwhile pass the password in? Does anyone experienced with the similar situation?
View Replies
View Related
I generate my codes using a generator. My problem is that I can not write into my Access database. I had gone to tools to allow access permission . still nothing.
View Replies
View Related
I have a MS Access file that consits of 500 movie titles, I already upload this file onto Brinkster.com, but I don't know to code this into ASP or PHP so I can have an on-line database. Please help me code this Access file into an ASP or PHP file.
View Replies
View Related
I have a field in my Access db which is used to put a category against a company, rather like Yellow Pages. The categories are held in another table in the same db. The Category field in my companies table is a look up field using this syntax
SELECT [categories].[ID], [categories].[Category] FROM categories;
My problem is when I want to list a company and do a response.write rs("Category") I get the ID relating to that category rather the description. How can I get the description instead?
View Replies
View Related
I am using Access and ASP.I am just trying stuff out.I created an access database and put some validation in access on some fields.
I created an ASP program to insert into my database.
When I try to insert a record that validates OK with access rules all is fine.
Then I type input that violates the access rules; I hoped to get a helpful message back.
All I got was my message saying an error had occured and it was Error number 0 and native error 2097228.
As I was testing I know it is due to failing a validation in access.
I am learning I wanted to look up this native error, I cannot find it in access help or internet searches where would I look for native errors please?
I know I need to validate client side that is not the issue it is understanding native errors!
View Replies
View Related
I'm trying to search the Access database using 3 fields and I think there's a problem in my If statement...pls check it out for me.....I'm using ASP...this is what I'm trying to do:
If Request.Form("txtUser_Id") = "User_Id" and Request.Form("txtWeekNo") = "WeekNo" Then
strSQL = "SELECT (MSD + Methods + Analysis + Architectures + Models + Studio + Elective1 + Elective2 + Elective3) AS PersonTotals, FirstName, LastName, WeekNo, Semester, StudioTeamName FROM tblpersons"
strSQL = strSQL & " WHERE Semester=" & Request.Form("DaInBox")
'strSQL = strSQL & "WHERE Semester ='" & strSemester & "'"
End If
View Replies
View Related
I'm planning to change my database from MS Access to an SQL database. So, what do i have to change in my code for that?Is it possible to have multiple tables in SQL which are linked to each other?Are there pro's and contra's ?
View Replies
View Related
I made a little app that selects data from a database depending whether there is a NO, in the YES/NO column. The data is exported to a txt file with aso. What i'm wondering is, is after the data has been downloaded to that txt file, how to write to the database saying all they were marked NO, go to YES.
View Replies
View Related
I have never dealt with XML before, So this is way out of my realms...
I am trying to get a XML feed into an Access Database..
The XML source can be found here:-
but as you can see.. there is another problem.. the file is in a .GZ format.. so i need some way of Un-Zipping it onto my web host, and then importing the XML data into the database..
Ive looked around, and the only information i can find is un-zipping it onto a local machine, and then uploading the XML file.. but that's not practical.. i don't want my web page to be dependant on my PC at home being logged on...
As for the import of the XML to Access... that's another black hole there.. ive never done anything like this before..
View Replies
View Related
I'm still very much on the learning curve when it comes to writing ASPs and have always used Access for my db. A colleague in work has told me that I should never use access on a commercial site where I'm likely to get a lot of traffic. Is this correct, is Access totally unsuitable?
View Replies
View Related
Alright, I am opening an Access XP database via ASP. One of the fields is a numerical field, and I would like to force it to display the number + 1 digit to the right of the decimal. For some reason it is only displaying digits to the left.
In Design View, my Access Table (names 'arlist') looks like this:
Field Name: level, Data Type: Number, Field Size: Integer, Format: Fixed, Deciaml Places: 1
My SQL Statement: SELECT * FROM arlist;
Then the VBScript I'm using to access the table looks like this:
Response.Write"<TD align=""right"" bgcolor=""" & strBG & """ width=""10%""><P class=""body"">" & rsDC.Fields("level") & "</TD>" & vbCRLF
I am opening the table via ADO Statically with a Read-Only pointer because the page just displays the contents of the table. I've tried everything I can think of to preserve the decimal place. If I view the table in Access, the decimal places are correct.
View Replies
View Related
