Recent content by Timtropolis

Follow up question: Does the owner of the object (in this case, tables) have any bearing on a multi-user database? Also, do the permissions for the database file itself (these would be accessed when right clicking the .accdb file and then selecting Security, Advanced) have any bearing the...

Yeah, like I said this is a very odd thing. The problem is I'm using snapshots for both the datasheet views and for the report views, so not sure why that would lockdown the database tables. Thanks for you help though, very much appreciated.

Yes I have, as I stated in my original post I have set these accordingly and experimented with different settings but to no avail.

Hi arnelgp, Tried that but that did not help.

Greetings all, I've developed a split db (A2010) that has a FE installed on local machines(7 users in all) and the BE up on the network. The issue I'm having is that if one person opens the front end on their machine and they open up a report, or a table (which I have setup using a datasheet...

Check to see if you have a rogue "End sub" within your code. I've gotten this error on occasion and its because I've accidentally chopped off a sub/function by placing code before or after the sub/function declaration (Public sub... or, End sub) or I've made a syntax mistake.

Try doing a requery on the dropdown control. You can place the following code in the Open event of the form. i.e. docmd.[yourcontrolnamehere].Requery HTH Tim

Greetings all, Have a wierd question that I have not found an answer for so I thought i'd post it here. I started a new gig and inherited a database. Database was originally created in Access 2003, but was upgraded to 2007 format. Database is split but runs locally on my HD for the time...

Greetings all, I have a problem and was wondering if I could get some help/hindsight. I have a information file that I need to process. The file is HUGE. Plus it is denormalized, meaning that it has header info, type info and origination info, as well as the records being processed. In...

Thx Guus, but that didn't resolve the problem. Anyone else?

Hi Cozzy, There are a couple different ways to approach this. Assuming you are using a data entry form to enter in the new data, you could write some vba code in the BeforeInsert event, something like this (you'll have to edit it to suit your needs): Dim dbs As DAO.Database Dim rst As...

Greetings all, Have a unique scenario here. I am calling a stored procedure in SQL Server 2008 from my Access 2010 database. (see my code below). Dim objConnection As New ADODB.Connection Dim objCom As ADODB.Command Dim x, y As Variant Dim rst, rst2 As ADODB.Recordset...

Greeting all. I have a question regarding an error I'm receiving when running an SSIS package that xfers data from a flat file to an 2003 Access db. SSIS is able to find the flat file and recognize it. Also, SSIS is able to connect to the database using OLE DB (see attachment 1). There is a...

Not sure what this has to do with my question about default selection. Anyone else?

Greetings all I have a popup form which is used to provide data to a function. On the form are two combo boxes.... these are used as criteria to populate a listbox. When the user enters data in the second of the two combo boxes, I do a requery of the listbox (from OnChange event). I also do a...