Search results

Are the front ends on each machine, or in the network?

Please see this post by Allen Brown, in "Configuration" area.

Sorry, I know no better advice. What you are looking for is like building a hospital under a broken bridge, instead of fixing it.

Did you split to a local location, or network? from local location things should run better.

They may be other advice, but not better. You should have a front end for each user. You can have this code in a file on the network, designated to copy a file from the network to a temp local location, and open it: Private Sub copyAndOpenMdbFile(FileName As String) On Error GoTo...

Hi, I'm trying to improve my SQL Server skills, and got stuck in the beginning... I have SQL Server 2012 & VS 2013 installed, and downloaded Northwind and Pubs sample DBs. I can't get the sample DB's attached to the server, these are 2000 versions... Any way around this? A link to a newer...

I can't understand why would someone have a calculated field in a table, in my opinion, that's just what views are for... in any case, to the best of my knowledge, these are not optional in 'regular' mdb or accdb files. I would truly reexamine the requirements: field C should be calculated in a...

Enter the formula to the control's ControlSource property: =IIf(IsNull([A]) Or IsNull([B]),Null,[A]+[B])

Hi, I would say the answer is no. What you could do is have a OnTimer event on a form, and have a process run without other Human involvement. but as far as I understand computing, there is a basic need for a human decision before software starts running... this decision is captured as an event.

Hi, My advice is to go with Frothingslosh's lead. You can read some more here and here. Based on this object model, you can also record Excel Macros for other specific actions. ATB

Here is what you are looking for: http://btabdevelopment.com/export-a-table-or-query-to-excel-specific-worksheet-on-specific-workbook/ Send a RecordSet to an Excel sheet. You can find there other options too. And here is another discussion on the topic. ATB

Please follow Glaxioms post in this thread, and the posts he links to there. I have it bookmarked because it seems like a great concept, but have not practiced it yet.

Well, not DDL, but I have 2 cases: for one client I have the quite a few BEs, by time slice, any modification in the BE is made for all BEs. In an other case, a colleague provides his clients the application in a terminal server. It is more accurate to loop through all BEs, and make the...

That is true when working in VBA module, but modules are objects, or tools, within Access. you can create an entire application using Macros, and not a single line of VBA code (it would not be a very rich application...), and to the contrary: you can create a user defined function, and run it as...

DLookup() for one Field in one record, or DAO.Recordset for more. It seems to me you will need a criteria too, to define the flightDate of witch record (=flight) do you need. ATB

Hi, I have fine experience splitting data to a few BEs and linking to them once at a time, this structure suites my clients' needs, even though offering BI is an issue... Searching this topic, i came across this post, he dose not recommend Processing 2GB of data, even from multiple DBs, in a...

There is no limit to the size of a table, there is a 2GB limit to the size of a DB. Access 2010 specifications

Hope I'm over with this: I believe the issue is DB locks, not index overhead. First: when error handler had code: If Err.Number = 3086 Then Resume Code execution usually continued. While process ran, I saw the ldb file being created and deleted constantly, locking and unlocking the tables...

Hi spike, and thanks for replying Well, if I had something solid I would have posted it... Maybe a few facts: 1. The Process was tested on this same data a few times, each test resulted with a different number of errors, not necessarily from the same records (same p_Code and same XmlFile). 2. I...

Hi, in brief: running these simple lines of code CurrentDb.Execute "DELETE FROM Components WHERE Code = " & p_Code CurrentDb.Execute "DELETE FROM Packs WHERE Code = " & p_Code sometimes causes error 3086 - 'Could not delete from specified tables'. usually, works fine. In detail: In a data...