Search results

cant you open the third party access database? It is probable if you have linked it and only headings appear, there are no records in it.

Private Sub cmdTables_Click() Dim obj As AccessObject, dbs As Object Set dbs = Application.CurrentData ' Check each object of the AllTables collection For Each obj In dbs.AllTables ' When you find a table, display its name MsgBox obj.Name Next obj...

Private Sub attach_Click() dim rst as DAO.Recordset Dim wrk As Workspace Dim dbBack As Database Dim strTable As String Dim strFileName As String Set wrkDefault = DBEngine.Workspaces(0) set rst = currentdb.openrecordset("path") rst.movefirst do until rst.EOF strFileName =...

up for this post please.

sorry for phrasing it wrongly but what you have said dfenton is what I was trying to say that replication / synchronization is not available for the new access 2007 database format.

I dont understand it either. I just posted it there. I have no idea about Lotus Notes but as I have read, Lotus Notes is a client of a client-server application. so therefore, I think probably, access here would be the back end. So I thought that the link was appropriate.

Good day to all, I have this attached picture "paths.jpg" the purpose of this paths is for easy linking procedure. the form is a countinous form which has only three fields: pathnameid,pathname,pathlocation And I have this code: '------------------------------------------------- Private...

thanks for the replyies. datAdrenaline why do you call it a bug? Ok I will wait for the reply when you log tomorrow. thanks for helping me out.

why did you arrive in the conclusion that access is insufficient for you already? What made it insufficient for you? On what aspects? I guess its the old thing issues.

INSERT INTO [;DATABASE=D:\rommelfiles\Database2.accdb].table1 ( ID, Fn, Mn ) SELECT table1.ID, table1.Fn, table1.Mn FROM table1 LEFT JOIN [;DATABASE=D:\rommelfiles\Database2.accdb].table1 AS vDestination ON table1.ID = vDestination.ID WHERE vDestination.ID Is Null; wow this is already perfect...

yes. they would have a unique store / office id.

INSERT INTO Table1 IN 'D:\rommelfiles\Database2.accdb' SELECT * FROM Table1; I have tried the above code and it still works but the problem is it was just too slow to update the records in database2, maybe its because the fields where not specified unlike if the fields were specified, the...

INSERT INTO Table1 ( ID, Fn, Mn ) IN 'D:\rommelfiles\Database2.accdb' SELECT Table1.ID, Table1.Fn, Table1.Mn FROM Table1; instead of the above, can I use below: INSERT INTO Table1 ( * ) IN 'D:\rommelfiles\Database2.accdb' SELECT * FROM Table1; I replaced * "asterisk" there so that I wont...

I believe so. but I dont know who these power posters are? can you probably give me good links to outer join learning. I have been googling now but cannot find good one enough though.

Ok. I have tried this on database1 Galaxiom and it says syntax error. Do I need to link the table 1 from database2 in database1 first?

I dont want to use MDB format pbaldy because I am also after Access 2007 db password security. there may have been problem with the link you provided pbaldy because its not accessible "page load error". Maybe you can give me the gist of the link you provided, please. Galaxiom, what do you...

how about this information: http://www.easysoft.com/applications/lotus_notes_domino/odbc.html

well. I dont need them to be on real time, probably on at the end of the day daily basis updating only. Both of them are master databases. These databases are used for two or more office or store branches. Yes, I have searched in google that replication is no longer supported in access 2007...

INSERT INTO Table1 ( ID, Fn, Mn ) IN 'D:\rommelfiles\Database2.accdb' SELECT Table1.ID, Table1.Fn, Table1.Mn FROM Table1; This is my test for append query code that will update records in database2 from database1. However there will error appear if there is violation due to duplicate records...

thanks for the reply pbaldy. the question on this post relates to my idea of synchronizing two or more databases with each other. for example I have two database and I want to synchronize their records to each other, so it is only right to use Append Query right and not update query? so am I...