i have about 20 users who have their own access front end and write to a backend. i need to do an update to the backend, and every time i try to do it offhours, it seems that someone is still logged on because the file is locked! how do i get around this? i do tell the users to log off at the end of the day but a lot of them forget! is...
I am upsizing my back-end from Access 2003 to SQL Server 2008 R2. My pilot migration attempt went all right, but it appears the Access 2003 front-end won't play well. (I can make native links if I convert it to an .adp project, but then I can't modify the front-end; so it's back to .mdb, which uses (slow) ODBC links.) Apparently I s...
I have an application with the front end in Access 2007 (Access 2000 file) with the backend on SQL Server 2008. The application has been running for two years now and I have noticed that on some PCs the queries are taking forever to run while on others it runs quite fast. Each PC has its own file of Access, so they don't share the file. ...
Hey guys I've written a little module/macro that helps our inventory department, they will need to run the module/macro a few times every month. They receive the databases from out in the field these are exported from some 3rd party inventory tracking system we have. My question, is there any way to install this module/macro outside of ...
Hi there, Would anybody be able to recommend any free or paid for services out there to assess and critique a database produced in MS Access? Any help or advice appreciated, cheers Noel ...
i would like to distribute an access front end to some people and i want to make sure that they do not edit anything in it; however when i change the extension to ACCDR it makes all the forms and tables disappear. what settings do i have to change in order for them to be able to open forms but not view them in design view or make any cha...
I'm quering the table MsysObjects for making a list of the objects in my database: SELECT MsysObjects.Name, MsysObjects.Type FROM MsysObjects WHERE (((Left$([Name],1))<>'~') AND ((Left$([Name],4))<>'Msys')) ORDER BY MsysObjects.Name; I know these values: -32768 = Form -32766 = Macro -32764 = Report -32761 = Module 1 = Table 5 = Query...
I'm scratching my head whether this idea is worth exploring: I'd like to use a tab control to filter a subform field by the value of the tab control page. There are about 5 different values for that field, so it would be neat to have 5 tabs where you click on the tab and see the list of just those matching records. I'm a bit of an Acce...
I'd like to have a macro, called Macro1, for example, run every day at 9 AM. It works great on its own from the VB code editor in Access 2007 but I would like it to be able to execute automatically without access being open. Please note that I don't want there to have to be any human intervention, it needs to be able to run automaticall...
I usually make applications with the front end in Access 2003 - 2007 and the back-end on SQL Server 2008. When I create an ODBC to link the tables in access I have two choices in the ODBC Data Source Administration page on my Windows XP PC: Server 2008: SQL Server Native Client 10.0 v.2007.100.2531.00 SQL Server v. 2000.85.1132.00 W...
My Access programming is a little rusty, & I've never worked with Excel files all that much. I have a requirement to bring data from Excel spreadsheets into Access 2007. These spreadsheets have a fixed (predictable) format, but it includes a "header area" where I need to read single data items from specific cells, followed by a mass of ...
I looked through similiar questions and attempted to apply to my situation with no avail: I am counting the number of projects aborted in a month (between [begin date] and [end date]) which works as long as there were any projects aborted, however most months there are none and I need to return a result of zero. I created a table (LU_R...
Hey, I've been trying to make a form with 68 items while positioning all the items on a form via a loop, but this loop isn't working :( Can someone please help me get this to work? I've tried looking everywhere but can't see what to do :/ Dim Items(67) As String For x = 0 To 67 Items(x) = "Ctl" & x Next #It goes from 1 he...
This design problem is turning out to be a bit more "interesting" than I'd expected.... For context, I'll be implementing whatever solution I derive in Access 2007 (not much choice--customer requirement. I might be able to talk them into a different back end, but the front end has to be Access (and therefore VBA & Access SQL)). The two ...
Hi all, I hope someone can help me out, or at least help figure out a workaround. I'm using Access 2007's split form feature, and have the code below run on the Form_Open event, as well as after two button_click events. The code works fine when run after the button_click events, but when it runs on the form_open event, it causes prob...