Search results for query: *

No. Any changes to the data in the MDE file are not in your MDB file. If I was you, I would split the MDB file into 2 parts using the database splitter tool in access. This way the data is in one database (back end) and the forms, queries, reports is in another database (front end). Then make...

From what I understand you must keep your orginal MDB file and if the user requests changes, change the MDB and then create a new MDE file.

I am trying to call a dll that is not part of windows and is therefore not in the SYSTEM32 directory. I have declared the function. However, when I call the function I get an error stating the dll file can not be found. I have included the path to the dll in my path statement. Any thoughts????

I have done triggers on UDB 7.1 for OS/390 from one table to another table in the same Database. However, I am having a problem when the triggering table contains a timestamp column or a smallint column. When I try to create the trigger it gets a -189 sqlcode. E.g. of a create trigger for...

Please post code. It makes solving problems easier.

Juice05, What DBMS as you using? Do you have the IIF statement then I think I have a solution that will work. Table 1 contains the following data a hill b car c hop d hill e cat f apple Table 2 contains the following data hill top car hop Then by using the following query, all rows are...

impulse24, The only way I could think to show all the values in the gaps would be to create a table with all possible values in the table for the Certificate Number. Then you could do the following query ... SELECT A.X FROM Table2 AS A WHERE not exists (SELECT A FROM TABLE1 b WHERE b.A = A.X)...

Hi lorenzodv, Did you try to set the Access Database to have locking set for all records and not the default (no records locked). To set the default locking level to all records .. Select Tools from the Access Menu bar. Then select the Advanced tab and click on the radio button for record...

Rick, I took part of John solution and I got the following to work. Private Sub Command0_Click() Dim myStart As Variant Dim myFinish As Variant Dim IExplorer As Object Set IExplorer = CreateObject("InternetExplorer.Application") '*** Start IE, go to URL With IExplorer...

Not sure if this will help but I recently found out that Word defaults how it opens a document by checking settings on your computer. Have some else open the word file after you have run your code and see if the word document opens in normal view or master view. I hope this may point you in...