Search results

Hi All.. Quick question.. I'm creating a project where all the major database tables are on Oracle with only a few application tables within Access (although they don't really need to be - they can be located in Oracle should I need to). At present so that I can update some of the oracle...

Hi All, I've just a quick question with making an application client server. So far all the code I've written is for the front end application, which from what I have read is waht gets relesed to the user. However I want to write some marshelling code that will check the status of a table at...

Hi All, I have an extremely strange problem with a recordset. I have a recordset declared in a module as a public recordset. I then use this recordset to query a external databse (which is oracle) using ODBC and DAO. This returns the query fine, I envoke the 'edit' method on the recordset...

Hi All, Yet another question. Im trying to lock a row of data in a linked table into an Oracle database. At present im trying to use Pessimistic Locking. I use a function to open a recordset for the row that I want to lock, I then test to see if the rocord is already locked if not I carry...

Hi All, I hope someone has the answer for me here as I have been asked to save some space on our server which has about 12 large mdb files upon them all of which are in Access 2000. I went through the first one and changed all the feild sizes to suit the data which hardly made any difference...

Hi, Im trying to get a user defined function for the RowSourceType of a listbox to work. Unfortunatly Access (97) tells me my user-defined function 'may not be a valid setting for the RowSourceType property, or there was a compile error in the function'. Theres no need for me to post my code...