Search results for query: *

No need to reply anyone. I have been bloody stubborn and have finally worked out how to do it. For those who are interested, set up the ADODB connection; no recordsets required; the SQL statement should read like this: strSQL = "INSERT INTO tbl_Dealers IN 'C:\Documents and...

I am getting so frustrated with my quest. Thanks to cmmrfrds, but I cannot update a table in one secured database from a table in another secured database. I am using the ADODB.Connection; manage to open both databases, but just do not know how to construct the clause for the SQL statement to...

Thanks everyone. Markphsd. Your solution was the one I have used so far, but it is very cumbersome. I wanted to use an SQL statement. Cmmrfrds. Your answer gives me what I want, but I was so sure that I tried this. It was the actual syntax that was giving me the problem, that is the reference...

Get the utility from Microsoft called ldbview.exe. This will show you who HAS and IS logged into your db. The code is also published.

Are you refering to Linked Tables? If yes, then I have an excellent routine which will check whether your tables are linked. If not found because you have moved the backend to elsewhere, the routine will allow you to navigate to its location and automatically relink the tables. The next time...

LDBView.exe is a useful utility which is available from Microsoft. Search their KnowledgeBase. It displays users who HAVE and ARE logged into your DB. Just reflecting on the previous note about Admin deleting a user account. A secure database is not secure if the default Admin account has...

I have two secured databases, both of which use different MDW files. I need to open both of them and then update the tables in one from the other. I am using the ADODB.connection where I parse the database file names, user IDs and passwords etc. This works fine, but I just don't know how to...

I have written two applications which are written in MS Access 97; both of which have full security using different systemdb files. In order to open the second database it is necessary to stipulate the name and location of the workgroup (systemdb) file that is used with that database, eg...