I am using MS Access 2003. I would like to setup table link to sqlServer 2005.
sql server and access 2003 is in on the same pc. I have setup ODBC Data source to this sqlServer database. I tested the setup and it work fine.
Then I go to access and action; File/Get External Data/Link Tables.
On lick Link Tables, It open link popup windows. But when I select ODBC Databases() from the Files of Types dropdown, windows disappeared.
I have a website that is asp (not .net) based with an Access DB and I am in the process of replacing an old windows 2000 server with a much faster windows 2003 server. Here lies the problem I have a script as part of the admin that exports data to a csv file. The query joins 4 tables together to get the data needed for the export. On the windows 2000 server it takes 1-5 seconds to execute and have the csv file ready for download. On the window 2003 server it times out. I striped it down to use 2 joins and it worked although it took more like 10-20 seconds to export. This exports a specific range of ID's and the range is normally only 40-50 rows. If I put time stamps in the code the problem is in the query of the database, so I know its not in the file write etc.
I am going to rewrite it to use multible querys instead of one large query, but I have many other sites that I am moving to this server that would work better if I can figure out why it is so slow.
The windows 2000 is a 900 mhz server the windows 2003 is a 2.8GHZ server both have 1 GIG of ram. The database file is on the local drive on both servers. I am guessing it is a difference in the Jet version, I just haven't been able to find a solution to the problem. This uses a DSN connection, configured the same on both servers. I have also tried it as a DSN-less connection with the same result.
I have installed access on the server and to execute the command in access it is <2 sec.
I am not an access expert I normally program in .net and php and use MySQL and MsSQL for databases, we just have these legacy sites that use Access DB's
My customer has Access programs that work on their Windows 98 OS PC's, but when they try to use them on Windows 2000 OS PC's they will not work. The programs I believe were originally written in Access 97 and now they have Access 2000 on the PC's.
By not working I mean the following -
The Access program allows them to enter a document name and then the file opens in Word - BUT - when they use it in Windows 2000 it does not open the document at all. It says file not found in Windows 2000 and the file does exist.
** The reason they have Access opening files is that Access keeps track of them for auditing purposes.
Now here is something that I want to mention. On PC's that were upgraded from Windows 98 to Windows 2000 the programs work.
Can anyone here tell me what is missing from 98 to 2000 that would do this.
I am trying to give a new user access to the front end of a DB.
When I copy the FE from the server to the local C drive ( Windows XP)
the FE loses all its relationships and the user is not able to query anything.
I go back to the server and find that the FE is just fine on the file server.
I also tried running the FE from my PC ( Windows 2000 SP4) and it works fine.
Do any of you know what the issue could be. I also checked to see that the new user has permissions on the folder on which the file is located on the server and she does...
Any thoughts on what the problem could be would be highly appreciated.
I have noticed that the "warnings" in my access 200o database no longer pop up. As example, if I went to delete a table or record, I used to get a pop up warning from MS Access asking for confirmation. Now the record just deletes without a warning. This seems to be happening with other things too.
Hi, I am new to access and I have found important tricks in this forum. Thanks to everybody
Now, I am trying to use a query with multiple criteria. In particular it has to query a table that contains info about candidates tblCands using text boxes, check boxes etc etc present in a form. First, it works correctly but if I close the form and re-run it, statements in query disappear.
Could someone indicate me what would be the problem?
Well this is going to take a bit of explaining, because my colleagues and I are totally baffled.
I have an Access 2000 front end connected to a Sql production server. I went to make some changes to my forms and subforms, but I did not want to do it with the live data. So I made a copy of the database to my own Sql server on my desktop. So far so good . . . Now when I opened my main form, my subform appeared, but its controls were invisible--I still had not touched the code.
I looked at all the properties for my form and subforms and it is set to Visible and Display always. Now, even stranger, when I advanced my records, if the subform had data its controls would become visible, and then disappear again when I reached a record that had no data for the subform (the main form and the subform are bound to two seperate tables within my database, all the subform controls are bound as are the majority of the form's controls).
Then I went to the code. Nowhere do I change the Visible related properties within the form/subform code. I decided to put a Stop in the Form_Current code of the subform and see what happens as I advance from record to record. What happened was that when I reached a record with subform data present the stop would be read and I would toggle through the Form_Current code. When I would reach a record with no subform data, the Form_Current code would not be read as evidenced by there being no Stop action.
Anyone have an idea of what's going on? Something gets changed when I connect to my local SQL server. Even when I reconnect to the production server the problem remains. Its like some property changes, although I cannot find it, and it is changed permanently. The only property I play with by code is that I enable the controls of the subform when there is NO data in the subform, and I disable the controls when there is data. This code follows:
Private Sub Form_Current() On Error GoTo Err_Form_Current
If Me!AssignedNumber = True Then Me!AssignedNumber.Enabled = False Me!txtWTNumber.Locked = True Else Me!AssignedNumber.Enabled = True Me!txtWTNumber.Locked = False End If
Finally I tried to set Visible to true within my code for the individual controls, but that still did not overide the problem. I connect to my server via an ODBC connection to a .dsn.
Sometimes when I send a copy of an Access 2003 application to a remote user, a stored procedure or function will disappear. What causes this, and how can I get the entire application over to the users?
I use Access2007 under Windows 8.1 64 bits.Just ignore any message related to a splash form.The form will register revenues in the table TblLanc Receita sPJ. When either saving record input or closing the form, incomplete records must be eliminated from the table. When opening the form you should be able to see the unbound list of revenue inputs made. The list will show empty though because the last time I closed the form thru the button Close, table data disappears. Also, the same happens if I get into the form design mode to analyze the code and re-execute the form.
Please, click on the button Add to input a couple of revenue records thru the form to verify what I just said.I translated relevant input fields so the input should not be a problem. Fields named Quotation, Direct Purchase, and Contract, can be filled in with any data... just make sure only one of these fields per record be input, otherwise you'll get a pokayoke message. Save each input. After 2 or 3 record inputs, close the form and re-open it. Table will be empty. Redo and save new inputs. Go to the form design mode just because. Re-execute the form. Table will be empty again.
Another point is I want to click on a record of the unbound list and have the clicked record fields properly filled in the form. From that point I would decide if the record would be deleted or changed. The functionality of the entire code works but the selection on the list. In other words I do not understand why I am not able to fill in the form with the selected record fields. My code should do that but it does not.
My property sheet has disappeared I don't know what I did. How can I make it reappears? I have try by pressing the SHFIT key but it won't work. Also, I have created a new database and open it, the property sheet isn't appeared. The icon are still there but when I press on it, it does not response.
I am using MSAccess 2002. I have removed the tables and queries to reduce file size. I have set database password as "planning". In the form named "Form1" I have created a Shift-Key Enable/Disable button with password "SIMON". In Menu Starup, I have also disallowed Display Database Window, disallowed Built-in Toolbars and disallowed Toolbar/Menu Changes. Now I have problem because I cant unset the Security password and make changes in Startup.. because the Menu Tool/Security, Startup..etc have disappeared. How do I get them back again?
hey, i hav seen a similar thread about this (i think bout a year ago or so) and i didnt no whether to continue it or start a new thread.Option boxes - Making items visible that thread did not fully answer my question and after searchin around n finding nuthin i hav decided to ask
in my form i have the payment methods=> cash, cheque, credit. i did have these in a drop down menu, but i wasnt sure how to do what i wanted...which is based on the selection either make a couple of fields (credit card details etc) visible or invisible. so what i have done is changed the drop down list into an option group with radio buttons. i currently have this coding
this seems to work although say if my first record has credit card selected, then all the fields are visible, but wen i move onto the next record which is cash or cheque...they are still visible until i reselect cash or credit again..(and vice versa)
In a report there is a text box that disappears if certain data appears in a record. It is supposed to disappear but I cannot determine why it is disappearing and I need to fix the criteria that make it disappear.
The text box is unbound (the control source is ="Bonus Point Legend"), and there is not any code that refers to it, nor are there any references to it in a query (I can delete the text box and the report runs just fine). Interestingly, if I add a new text box and use the paint brush to format it based off the one in question, it also disappears and acts just like the one in question. But I can't find any code that even references a generic control and makes it invisible. The tag field is not in use either.
I have a query that's been working fine for years, however...the powers that be have requested a change. We need to track the lining owners in cars. We've recently gone to SQL on the back end (which I basically know NOTHING about) but I set up the new table, refreshed the connection, etc.
I can see the table fine and it says it has a primary key, auto numbers, etc. however, as you can see from the jpg below when I add the table to the query and link the id as in all the other tables, for some reason, this one makes all the data disappear when in datasheet view.If I delete the table from the query - it all comes back.
I seem to be having an issue with a split form I've been working on. I created this split form on Monday and it was working just fine but today, I have added a couple minor text boxes. Since then, I can view the form contents in Design View but when I switch to "Form View" or "Layout View", it's all gone minus the logo in the top left corner and the title for the split form.
I have a Login form, I set a query retrieve information from Login form's Text3 (username)
After that , if the user Successfully logged in then the Login form will close .
I set the query because i need to retrieve what is His/Her Department .
But , after I closed the Login Form , the query result disappear ...
Then I try open Login Form again and login again ... the result come out again ...
How to solve this problem ? Everytime the Form closed the criteria cannot work ad ... It will prompt me the parameter box want me to type again the criteria ...
So I am creating a Complaint Tracking Database with Access 2013. In my 'complaint entry form' I have added to ability to "Open" and "Close" the complaint. While the complaint is open the user is able to enter/edit data in the complaint (new or old). When the complaint is "Closed" (done so with a button on the form that prompts the user to enter a date of their choice) the user should not be able to enter/edit data in the given complaint. In my original thinking, I placed checks on various events (on load, after update, on click) that checked to see if the current complaint had a date in the "Close date" field.
If the close date field was null then that meant that the complaint was open and the the controls would NOT be locked. If the close date field was NOT null (i.e. a date was present) then the complaint was closed and the main form fields were locked but the data was still viewable and unless they "re-opened" the complaint they could not change the data.
Now, in the complaint entry form, I have a subform that acts as a action tracker that is used by the user to keep track of the actions taken on the complaint (i.e. they requested documentation from such and such on this date..etc). My problem through all of this is upon closing the complaint and locking the main form controls, my subforms data just vanishes! At first I figured the problem might be with the linking of master and child fields, so I made sure that I left the ID in the main form unlocked when I loop through my controls during the locking process. This did not solve my problem. Code below:
Private Sub Form_Load() Dim ctl As Control If Not IsNull(Me.close_date) Then Me.FormHeader.Visible = True Me.btnClosed.Enabled = False Me.btnOpen.Enabled = True For Each ctl In Me.Controls
In Access 2010 I have a Data Entry Form on which I have an unbound textbox in the header that the user can put a default date in. In the body of the form is a bound textbox that records the date and the default value is set as =defaultdatestat (obviously the name of the box in the header).
Problem: The default date shows up perfectly until a value is put in any of the other text boxes.
For further info : If you put values in text boxes default value disappears; if you then push escape the default value reappears when the values in the text boxes disappear.
We have recently converted from Office 97 to 2003 and Windows NT4 to XP.
In the old days, when I opened a database up I would use autoexec and the db would open to a particular form. On the windows display it would just show that I had a particular Access database open. On windows XP, if I open the database the same way I get two bars at the bottom of the screen showing the objects and the relevant form. This means that all the design is available for people to see.
I am not that clever to have front and back ends etc, so how do I get it to just display the appropriate query / form / report etc.
I hope that I have made it clear. The XP feature showing how many files you have open is quite handy if you want to look at two Word documents but in Access it allows people to fiddle. If they can't see it they can't fiddle with it.
Hey all I was wondering if there was anyway to open my program when windows opens, I have the XP sytem but I was also wondering if there would be a difference with windows 98... SO What i would like to accomplish is to open my access program without clicking on it when my windows, is loaded, can I open it when it loads automaticly. Does it matter that there are different users on my system or not. Thanks
I have an issue with access97 when installed on a windows XP pro sp2 machine. I am constantly getting errors from the vba332.dll module and access shuts down on me. This happens even if I try to go to tools - options on the main menu bar. If any one has encountered this before please help!
This is what I get in the application log:
Faulting application msaccess.exe, version 8.0.0.5903, faulting module vba332.dll, version 3.0.0.6908, fault address 0x000b6614.
