One of my user gets the following error from MS Access running from his local machine and linking to the database & appropriate tables. The front end MS Access application uses back end SQL server to get info from. ODBC connections are in place, folder/file NTFS security for this user is also in place. he is admin on his PC. His machine uses DHCP to connect to the network. One thing I'd like to mention is: We have Citrix server on which this application is published and this user can connect and perform the same tasks using the Citrix client. He is having errors in connecting to the tables Only when he launches locally.
Recently he got new upgraded PC and since than this problem arose. He was OK on his older PC. Any ideas what & where else to look?
In my opinion, it must be some tweak that needs to be done on user's machine.
PS: The problem appeared only on this user's new PC, from his old PC he was able to get to the tables and all other good stuff. All other users in the same group do not have any problems at all.
I have two tables, submit and imgdest. Submit is edited by front-end users to load pictures for back-end users who then delete the images when they're done with them. Submit is edited by a form, in the form I've placed a button (Command37) that has code:
Code: Private Sub Command37_Click() Call InsertData MsgBox "Completed", "0", "Completed Backup" Exit Sub End Sub Private Sub InsertData()
[code]....
This code was working for a short while, now anytime it's run I get error 3027 - Cannot update. Database or object is read-only. However, I can open the linked table and manually change information in it with no problems.
Code:I'm getting this error:Microsoft OLE DB Provider for ODBC Drivers error '80040e14'[Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement./mljnew/welcomeportal/registration/registration/test.asp, line 7
What am I doing wrong ??? The code here is probably the MySql correct code (Access uses different data types / field names ???) Hope somebody can help me out, because I can't find the correct data types anywhere ! (like use TEXT instead of VARCHAR, that's all I know...)
Here's the actual sql i'm using (displayed by response.write sql): CREATE TABLE roel (id INT(10) PRIMARY KEY AUTO_INCREMENT, email VARCHAR(155), gevalideerd VARCHAR(10) DEFAULT 'nee', inlogCount INT(10) DEFAULT 0, lastLogin DATETIME)
Hi guys i tried to run this create table statement and each time i get syntax error. I pasted the code in sql view windows of access 2000 and pressed the run code and i get this error massage saying there is syntax error. Could any one help me write correct create table statement that does not give me this error.I know u might tell me why u do not create table in design view or .. but i want to do this since i want learn this method as well.thanks
CREATE TABLE PLAYERS (PLAYERNO SMALLINT NOT NULL CHECK (PLAYERNO >0), NAME CHAR(25) NOT NULL , INITIALS CHAR(5) NOT NULL , BIRTH_DATE DATETIME, SEX CHAR(1) NOT NULL , JOINED SMALLINT CHECK (JOINED >=1980), STREET CHAR(15) NOT NULL , HOUSENO CHAR(4), POSTCODE CHAR(6), TOWN CHAR(10) NOT NULL , PHONENO CHAR(10), LEAGUENO CHAR(4), PRIMARY KEY (PLAYERNO) )
Hi guys i tried to run this create table statement and each time i get syntax error. I pasted the code in sql view windows of access 2000 and pressed the run code and i get this error massage saying there is syntax error. Could any one help me write correct create table statement that does not give me this error.I know u might tell me why u do not create table in design view or .. but i want to do this since i want learn this method as well.thanks
Code:CREATE TABLE PLAYERS(PLAYERNO SMALLINT NOT NULL CHECK (PLAYERNO >0),NAME CHAR(25) NOT NULL ,INITIALS CHAR(5) NOT NULL ,BIRTH_DATE DATETIME,SEX CHAR(1) NOT NULL ,JOINED SMALLINT CHECK (JOINED >=1980),STREET CHAR(15) NOT NULL ,HOUSENO CHAR(4),POSTCODE CHAR(6),TOWN CHAR(10) NOT NULL ,PHONENO CHAR(10),LEAGUENO CHAR(4),PRIMARY KEY (PLAYERNO))
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');'
I am pretty new to access and trying to create a form to enter data into a table. I keep getting a syntax error. Below is the part of code where I keep getting the syntax.
i have a database in access 2003 when i open it with access 2003 it shows data in table but when i open same table in access 2007 it shows only header rows , no data
how can i see this data into access 2007 or excel 2007.i want to link these table data with excel 2007 or access 2007 but with above problem i can't do it
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've imported an Excel file into Access as a textfile. All of the information on the Excel spreadsheet was successfully imported in Access. The only problem that I have is that some of the fields on the table have quotation marks (e.g. "Stults, David, "KWK, Inc.", "7,860.27", etc.) My first question is whether these quotation marks can be removed from the table.
My second question - There is information on this table that needs to be manually entered on a data entry screen in Access. Is there anyway to automate this process?
Hi all, I wonder if anyone can help. I'm not sure of the best way to describe the problemb but will try anyway. I have noticed that when using my database, every so often after a period of use the toolbars start to have problems i.e. when you select edit no drop down appears but if you roll over where it should be some options start to appear. Also the use of the copy, cut, paste etc buttons become unusable. However, if I close all forms, queries etc and reopen a starting form, the problem is gone again for another period of time. I run off Access 2000 and wonder if this is a problem with this version or something else. I would be very thankful if someone could shed some light on this problem i.e. explain it better to me and offer some advice on fixing the problem if possible.
Thanks hope I explained in a way that is just about understandable.
Wend im trying to open my database this error message shows up.
"Microsoft office has detected curruption in this file. To try to repair the curruption, first make a backup copy of this file. Them, on the tool menu, point to database utilities and click compact and repair database. If you arecurrently trying to repair this curruption then you will need to recreate this file or restore it from a previous backup"
I am getting a Microsoft Access Error when I try to open a database on a network drive. The error message says "The Microsoft Jet database engine could not find the object 'Databases'. Make sure the object exists and that you spell its name and the path name correctly." I also got a message that "Windows was unable to save all the data" for the database. This database worked fine Monday morning, but after lunch everyone who uses the database received these messages and the database would not open (myself included, and I am the owner of the database). I compacted and repaired the database late Friday afternoon. The size of the database is only 6.91 MB (I read in another post that a database cannot be more than 2 GB). Do you know why this would have happened and what I can do to prevent it from happening again?
Hi I have made an application in Access 2002 on my computer using in Regional and Language Settings/Language for non-Unicode Programs "Romanian". Now, I need to run my application as a front-end on other computers where the language is "english" but my application is refusing to work. I receive the same error for all my buttons, combo boxes, on "something" action: "the expression on <<action>> you entered as the event property setting produced the following error: a problem occurred while was communicating with the ole server or activeX control". I work to activeX and references but all seems to be ok. If I change the language back on to 'Romanian", the application work fine. What can I do to make it work on other computers with other language?
If I hit Debug and then Play, the script will continue its process till the end just fine. But I have to continue hitting it everytime it starts a new loop. So, I have been babysitting this script until the loop is complete.
Questions are: 1. Where do I find MaxLocksPerFile registry? 2. What does this error message mean?
When opening a certain Access database a user is recieving this error: Function isn't available in expressions in query expression '(((PRODUCTION.DATECREATE)=Date())'.
This only happens on a specific computer. I've tried uninstalling and reinstalling Office, Access, I've even tried just installing Office 97. I also went through and reinstalled all the ActiveX controls that have to do with the date (MSCAL.ocx gives us trouble sometimes).
I'm not that familiar with the programming for the database, it was done quite some time before I got here, but I know enough to understand what is happening. I think the problem lies with the Date() function (this still happens as admin on her machine so it isn't a permissions error) but I have no idea how to fix it.
I remember reading something not long ago about a similar issue that had to do with differing versions of library files for VBA. I was going to try and replace the library file containing that function on her machine with one from mine, until I found that it apparently isn't stored in a file.
Any help would be greatly appreciated as I'm at my wits' end with this thing.
I have a small dabase shared by 4 users on the network. when someone opens the db, then someone else opens it there is no problem. when user 1 has a report open and user 2 tries to update a record, user 2 gets the following error
You do not have exlcusive access to the database at this time. If you proceed to make changes you may not be able to save them later
I have split the database into 2 seperate Db's one is the tables only the other is the objects.
I am new to the use of access. I have defined the database in the dsn and named that 'abexp', now when i go to access open the database and then create a module and try to establish a connection to the abexp, it gives me an error - database has been placed in a state by an unknown user that prevents it from being opened or locked. Can someone tell me what am i doing that is incorrect over here. i am trying to get convert from sql server to access.
Is there any resource that gives a definitive run down on all the errors that can exist within access; their causes and solutions. For example; the enter parameter msg box that appears when it doesn't recognise field value.
Does anyone out there have any ideas on how I can get a full list of the error codes and their descriptions for microsoft access?
I've set up a simple table with two fields, one for the error code and the other for the description. I've written a short bit of code (see below) to build the table for me, but it only generates 88 codes with the highest being 746.
Now I know that there are error codes up in the 3000 area because I'm trapping a few of them.
What I'm looking for is a list of the error code so I may write an extended list in my error trapping routines.
Code as follows:
Private Sub Form_Load() Dim My_RecordSet As DAO.Recordset, My_DataBase As DAO.Database Dim My_Error As Long Dim My_Description As String
I keep getting the error Syntax Error in INSERT into statement. I don't know why
This is the sql statement:
Dim intRequest As Integer Dim intRequest2 As Integer Dim strSQL As String Dim intInvoiceNumber As Integer Dim strInvoiceDate As String Dim strName As String Dim intBalanceDue As Double repeats:
If Paid.Value = -1 Then intRequest = MsgBox("Now that you have checked this as been paid, do you wish to finalize this and become irreversable? (If you want further help about this click the Cancel button)", vbInformation + vbYesNoCancel) If vbNo = intRequest Then cancellation: Paid.Value = 0 Call MsgBox("Request cancelled.", vbInformation) Exit Sub ElseIf vbYes = intRequest Then ' Perform action here Invoice_Number.Enabled = True Invoice_Number.SetFocus intInvoiceNumber = Val(Invoice_Number.Text) Invoice_Date.SetFocus Invoice_Number.Enabled = False strInvoiceDate = Invoice_Date.Text Bill_To_Name.SetFocus strName = Bill_To_Name.Text strSQL = "INSERT INTO Paid-Address (Invoice-Number, Invoice-Date, Name, Balance-Due) VALUES ('" & Val(intInvoiceNumber) & "','" & strInvoiceDate & "','" & strName & "','32')" Invoice_Number.Enabled = False MsgBox (strSQL) DoCmd.RunSQL strSQL Else intRequest2 = MsgBox("You have checked this invoice to be paid but if you don't finalize it, it be assumed an error or the cheque has bounced. If you finalize it in the other hand this invoice will be permenantly deleted from this record and entered into the paid summary instead. Do you wish to return back to the request message or do permenant cancellation?", vbInformation + vbYesNo) If intRequest2 = vbYes Then GoTo repeats GoTo cancellation End If End If
The expression On Load you entered as the event property setting produced the following error: A problem occured while Microsoft Access was communicating with the OLE server or ActiveX Control.
Also same message but for on current.
Here's my code
Public Function WinName() Me.username = GetWindowsUserName End Function
Public Function Edit() If Me!username = [tblpersonnel.username1] Then AllowEdits = True ElseIf Me.username = "martiscm" Then AllowEdits = True ElseIf Me.username = "larsong" Then AllowEdits = True Else: AllowEdits = False End If End Function
Also once I'm in the form, if I navigate to the next record I get the same message but it's for On click.
