Recent content by JuriSim

@dragnor :Have you already find a good solution for this problem?

Thanks for your replies. I don't create new links each time I restart my application. It's simply a Refreshlink-command. Like MsAccessRookie suggests, i make use of a parameter. I don't refresh each time. Only the first time when client starts up his application. For example: My app is...

I design the app at home - linked to my sql-db when I install this app at customer's side, all tables should be relinked to their SQL-db. Also: when sql-server crashes (never happened before) i can simply reconnect to another sql-server. Relinking of my tables makes uses of "link-files" where...

I have written several app's. Front-End is always Access, Back-End SQL-server (2000 or 2005). So, I make use of linked-tables to the sql-db. Each time my application starts, I relink the tables. code looks like: For each tbl in Currentdb.Tabledefs tbl.refreshlink Next tbl After...

Best way is to make use of stored-procedure directly in SQL-database. How, is to difficult to explain over here. In sql-db you can also make use of tempory tables. So with a stored procedure (SP) you can store data into a tempory table. After this you can export this result to other tables...

Linking a sql-table or view is just the same. You can refresh the link in the load of your application with "refreshlink" (see post of Rabbie) One remark: when you link a view; Access will ask what the primary key is. After a while this primary key will be lost. you can re-add the primary...

Then you shoud open the whole excel doc; afterwards just select the sheet xlapp.Sheets("Madrid").Select

xlapp.sheets("Tokio") should work as well

Hello, After opening your workbook you can always use the following: xlapp.sheets(1) Tip: use the macro editor in Xls to see what code is generated...

Hello, I found the solution myself. For the persons who are interested: 'Run the following code from a blank database: Dim appAccess As New Access.Application Dim xSource As String Dim xDestination As String xSource = InputBox("Please enter path+file which you want to convert"...

you shoud make a tempory table. in form_open event you can delete contents of table after this you shoud run a function which fills the table making use of function DIR example: Dim xPath As String Dim MyFile As String Dim tmpset As DAO.Recordset CurrentDb.Execute "Delete from...

Perhaps there are too many records in your Acc Table? Excel is limited to approx. 65000 records

Hello, A few years ago I have made a program made in Access 97 (front end and back end; both in Acc 97 db format). Now we want to upgrade to Access 2003. (The reason why we don't upgrade to 2007 is: some of our clients use Windows Server 2003) I know there is a converting tool in Access...