Search results

Well, As I supposed.... I got the information that my app is way beyond the scope of "normal" useage of access.... Yeah-right! This is exactly what I expected. Of course my little app is within the limits of Access and network usage. Example: Front end; The new menu system in access 2010. Five...

Hi again. Our network guys have started to look into it.... Our company have several sites in my area, with ca 50 - 70km betveen the sites. The network, Lan and Wan is running at 100Mb. The network guys have to come up with a reason which tels me why the amount of kilometer between the sites...

In the new Access menu system, I used the main form which helds all the sub menues/forms. I believe(hope) this will aways have the status open...

Yepp. On my main forms On Open event I have setup an ADODB recordset, get some values, and hopefully this stays open until I close the app.. I have no rsThisrecordset.close in the app. Maybe I should do this differently? Regards,

Hi again. Just an update; I have done most of thing on the list posted earlier here; - Changed the Subdatasheet Name Property to None - Track name Auto Correct to Off - Location of the back end closer to the servers root (only two levels down) - Cleaned up all the code. - Use the comiled state...

Thank You for Your answer. The code is to lang to put here, but I can try to explain better: The App are made up around two standard forms for registrating data. With a main and subform for each. Just plain standard forms which are imported into each "menu button" in the new web-menu lookalaike...

I must check tomorrow, but I think it should be 100Mbits. At least on the paper... Regards.

Hi all. I have run into a problem wich I can't figure out how to fix. Background is Access 2010. I have made a splitted database system. Due to a perfomance problem over the network, I tried to compile the fornt end to a ACCDE file. I have used the new "menu system" for access 2010, with top...

Thank You! I will go through everything and try to check out as much as posible in the liste. Regards.

Hello all! I have ran into a problem which I can't figure out why happening. Background: Access 2010, wide area corporate network. I have made a app which are splitted in a "front end" with everything except tables, and a "Back end" with all the tables. The "Back End" are 7 tables, all tables...

Well, how can it not be there when I only opens a query for editing (without actually editing), save the query and then the problem is solved? For me it's very close to call this a bug... (very very close....) All computers used for testing (5 pcs) where all running with win 7 and Access 2010...

Hi there. I am sorry to say - I have found (almost) the same problem here. When I copy my access 2010 app from one pc to an another pc, the forms which have queries as source goes blank. (no info, no nothing). When I tries to run the queries manually, I got a error message similar to "invallid...

Well, this is just half way. The real problem is when using the new menu system in Access 2010. I have several "forms" which have querys as datasource. When moving the app from one PC to an another PC, somethings happen to the query. The "forms" shows up blank - no info, no labels, no notihing...

The Language in this case, where not the problem. It seems like it, because when entering into stored queries and changed the norwegian words to uk/us, the error seem to disapear. But the real problem is the stored queries it self. In all windows which I have problems, I have to open each query...

Hi all. I am writing a program on my own private version of Access 2010, which are in norwegian language. But the users of this program are using a (international) / US / UK version of the Access 2010. When they start using my program, serverel "windows" in the new menu system will not load...

Hello All! I am very sory, I may have misled You all! First, using "sql-string" = '" & midbundle "'" works perfectly. I was mixing error messages due to another error i have found and fixed: I am using two differen sets og tables; Dim rsTable1 As ADODB.recordset Dim rsTable2 As...

Thanks for the reply I did the change and removed the square brackets, but I still get the same error messages...

Hello all. I am really stuck in a case which I think is easy for "fresh" eyes to se what I am doing wrong. I have a simple (!) opening of a table with the folowing statment: rsCable.Open "SELECT * FROM [Cable] WHERE [Cable!BundleID] = " & midBundle The error message (in norweigian) can be...

This is embarrassing! :) I am sure I tried this earlier with no result. But now - when I have restartet access, now this work... But thank You anyway - Your answer make me try one more time.. Regards,

Hi. I have got a mysterious problem - at least it is a problem for me. I have a sql that print records based on a Date field, and the criteria is only: Not IsNull on this date field. But I would like to "empty" the date field in the table - just for avoid printing this records. In my...