I need to update data in a bunch of tables of a sql server database. The database has 300 tables which I have linked via odbc. I'm hoping there is a simple way, using vba, to loop through my linked sql server tables and determine which of them are views as opposed to tables.
Hello, I get the above message when I try to open a database created by someone that no longer works here. I tried to create a new version of the workgroup information file and assume the permissions of the administrator, but I still cannot access the database. Any leads?
My membership database has worked fine until recently. Now I cannot save inserted data. On attempted saving "Update or CancelUpdate without AddNew or Edit" appears.
The problem. relates to 2 tables Member and Addresses. PK in the parent table Member is ID. In the Addresses Table the FK is ID. There is a One to One relation between the tables and Referential Integrity is set. I know 1 to 1 is not good but it worked fine in this small database.
I have a form to add, edit, and delete Records from a table. I am using the following VBA
Private Sub cmdEdit_Click() If Not (Me.frmlEmpDetailsSub.Form.Recordset.EOF And Me.frmlEmpDetailsSub.Form.Recordset.BOF) Then With Me.frmlEmpDetailsSub.Form.Recordset Me.txtAddEditname = .Fields("Name") Me.cboRoster = .Fields("Roster") Me.cboPermFctn = .Fields("PermFctn") End With End If End Sub
Instead of referring to the Subform to load the data i would like to refer to a combobox:
Its not an issue but This Combobox contains 5 columns...
I get an error "update or cancel update without add new or edit" which seems to point to this code.I am using MS Access 2010.
Private Sub Form_BeforeUpdate(Cancel As Integer) 'Store when record was last modified and by who. 'Initially stores when the record was entered. If Me.NewRecord = True Then Exit Sub 'Exit if new record Me.DateLastModified.Value = Now() Me.LastModifiedBy.Value = getUser() End Sub
I'm creating a database full of contacts. I have a contacts table with detailed info on each contact and I also have a company table with details on each company - all companies attached to a contact are in the company table plus a few others. I'd like to be able to pull up a company profile and see all the contacts we have associated with that company displayed in a list.
I have tried to put an Event Procedure on the AfterUpdate (or OnChange) of the Combo Box, and i wrote in it:
------------------------ Private Sub COFNumber_Change() ' Find the record that matches the control. Dim rs As Object If Me![BillNumber] <> Null And Me![BillNumber] <> " " Then: Set rs = Me.Recordset.Clone: rs.FindFirst "[Bill Table_CustomerName] = '" & Me![BillNumber] & "'": If Not rs.EOF Then Me.Bookmark = rs.Bookmark End Sub -------------------------
I try the form, and i get the following message:
"Update or CancelUpdate without AddNew or Edit"
I dont know what this means, and i dont know how to get it working. Anyone has an idea?
I have a form that displays fields from two tables. I have set the properties of Allow Edit, Allow Additions, Allow Update, Data Entry to NO. However I want to allow users to be able to add new, edit/update and delete records from the form by clicking on respective command buttons.
the problem is that the code that I am using is giving me errors that says that I "You cannot go to the specified field" I need help on proper VB code to use that will allow me to enable input and update on the records in the table.
I have a form which uses a list box to select which record to display. The code is all generated by Access during form design. It is a method I have used numerous times inthe past in various database without problem (even in the current database I am developing).But for some reason on this one form I get the following error;-
"The expression After Update you entered as the property setting produced the ollowing error; A problem occurred while database was communication with OLE Server or Active X Control".
I have a table linked to an SQL Server table in my MS Access 2000 Application containing 5 text-fields (SQL Server Type, in Access seen as MEMO-fields) and several other fields (in total about 140 fields). Updating any field works fine except for some records. In those records I can only edit the non-text-fields in my application. When I try to edit one of the text-fields I get a error message telling me that another user has edited the record and i have to discard my changes.
The strange thing is that this problem only crops up for some records. (1 in a 100 or so) All other records work fine.
Does anyone know what happens here? And how this can be fixed?
I would like to edit a MS Database structure from a Web Browser using ASP. What I mean is I would like to be able to add more columns to a database table or delete or rename...Not the data that is already in the columns... Is this possible? If so can some one please point me in the right direction. I've searched these forums and have not been able to find the answer.
I am used to old Access 97 where I could edit a report while others are in it. I created an Access 2007 db and it does not let me edit unless I have exclusive rights to the file. Is there a way to turn that functionality on?(editing reports/queries/ while others are in the database. ?
I have created a few split multiuser databases in Access 97 that my company has used over the past few years. Currently, we are trying to move everything to a new network server. When I did a simple copy and paste on Friday moving everything to the other server it seemed to work fine. Until I tried to open any of the databases. I kept getting the message that they all were read only.
Do I need to bring the database back together before transferring it? I also plan on converting the databases to Access 2003. What precautions should I take in doing this?
Thanks for any and all information you can pass along.
I am new to split database format... If I put the backend on say windows server 2000 or 2003 in a folder, is there anything else I need to do? Any setting on the server?? Or do I need a specific type of server os ie sql server etc?
At work a few of us all need to access the database to edit/update etc and at the moment only one of us can use it at once.We are getting a server in the near future so we will all be able to access it at the same time but I was wondering if there is an alternative way to do this in the meantime? I have been looking at "shared folders" but am unsure if they are suitable or how they work.
When I attempt to open any of my Access databases I am presented only with the form that has been selected as the 'startup' option. Furthermore, it seems to be impossible to switch to 'design' view and my only options on the toolbar are File, Edit, Insert, Records, Windows, Help. As far as I can tell, none of these enable me to select the options required to give me my entire database back.
I am something of an Access novice, so if the above problem seems familiar to anyone i'd be grateful for the solution! The help option within MS Access hasn't been particularly useful.
I have an Access database on my server. My client does not like the idea of having to download the db, make changes, then upload it back. In the past, he has dealt with SQL databases, where you can create an access data project, that will give you a desktop shortcut straight to the database. I was wondering if there was any way to do something similar with an Access database. There is FTP setup for the site and all required permissions are setup. Is there any way to create a desktop shortcut, so he can edit the database in real-time, without having to download and upload? Thanks for any help.
I have a database with a couple of search forms to use for my company. My boss wants me to place this on the intranet so anyone can use it not only those with MS Access, which many people do not have on their computers. Please let me know if there is a way to do this and still make it interactive by means of searching. Thanks
Hi, I am not sure where to put this thread hopefully someone here can help me.
I have spent a good deal of time developing a very effective access database for a client. It is split into a front end and back end and connected using the Linked Table Manager when necessary.
The front end is quite loaded with queries, reports, forms, macros etc and the back end simply has the tables.
The front end is about 15 mb and the back about 8 mb.
Current set up is a small workgroup network with about 4 -5 consecutive users at any one given time.
I am looking for some advice on how to set up or facilitate getting the backend on the internet so anyone with a front end can access it outside of the LAN.
Today I set up an account with WebDrive which can connect to and assign a drive letter on your pc to any FTP, HTTP site.
I made the connection with WebDrive and using the linked table manager successfully linked the tables on my local machine to the back end on the FTP server - and actually ran the database at a pretty good rate.
I noticed however that it was downloading the backend to my local pc and once I closed the (a) form it was uploading the data back to the server? Very slow and often threw errors.
This of course is not what I wanted. Has anyone heard of doing this? Any work arounds or setting params would be greatly appreciated.
I have been told to create the DB in ASP but I do not have any idea on how to do that whatsoever...
I log into my server via remote connection from 3000 miles away. My database resides there.
If for what ever reason, I dump locally - the server does not recognize that I dumped - and thus keeps me logged in.
When I log back in, it logs me in as a second instance.
Here is the problem:
I was in access changing a form when I was dumped. (power went out). Now the server thinks I am still connected working on it. How do I shut down the service that has the DB locked - and delete the record-locking file that resides in the directory beside the database. (this record-locking file is the file that access creates whenever you start editing your database forms..etc...). I can't just delete that file - as access tells the server that it is still in use.
I am almost sure a reboot would rectify this issue - is there ANOTHER way to do this? (what is the service that is running that can be forced down?)