Search results

Thanks Pat, I'm not attempting to enter data directly into tables, just testing some scenarios. This all comes down to data security/protection. I have a number of tables with masked fields (sensitive data). I'm attempting to prevent users from opening a table in datasheet view (via...

Thanks MarkK, but there is no text box displaying the date. I'm referring to the table datasheet view, not a form view. While entering a "password" masked date in the table, not a form, the asterisks appear as you type. But, as soon as you leave field, the date appears, unmasked. The same...

Hi, I applied a "password" input mask to a date field in a table, but the date value remains visible. The password mask works fine for text fields. Text values display as ***** when viewed in datasheet mode. Dates, on the other hand, display as asterisks as you are typing in a value, but as...

Thank you The_Doc_Man and NauticalGent! Our development environment contains isolated FE and BE databases. When making design changes to the FE, it is pointing to the isolated BE (no production stuff). Let's see what happens going forward. There doesn't seem to be a ironclad answer to this...

Thanks for the quick response. Yes, the databases are split. The corruption message occasionally occurs when end users access a given database. But...most of the time the error occurs when a developer is in the front end make some sort of design change, even minor changes. The corruption has...

Greetings, Our company upgraded to Office 2010 about a year ago. Since then, both old and new databases become corrupt for no apparent reason. Various developers randomly receive the following error: "Unrecognized database format, database cannot be repaired or it is not a Microsoft access...

Hi All, I'm using Access 2010 to develop applications containing sensitive data. I would like to properly secure the data. I've created several applications with a front end (accde) linked to a back end (accdb). The back end databases are password protected. But...from all that I've read...

Re: SOLVED CopyObject table link? Awesome, it worked! "SELECT * INTO " & TargetTableName & " FROM T_Rate_Data_Compare_TEMPLATE WHERE TRUE=FALSE;" Thanks so much.

Thanks for the prompt response. Do you know of a way to copy a back end table into a local table (in the front end) via VBA? If I simply use the Copy and Paste function (table structure only) in the Object browser, it works fine. I get a new/empty local table with the same structure as the...

Greetings, I'm reviving this post. I'm using Access 2010 and have run into the same issue. I simply want to copy the structure of one table (source) to another (target). Access seems to link the tables together. Whatever I do to one table effects the other table. Delete a record in...

Oops, I meant to say view SYS.ALL_COL_COMMENTS, not ALL_TAB_COMMENTS. Although, I'll bet view ALL_TAB_COMMENTS might come in handy for other reasons.

Again, thanks for the feedback. It's too bad Access doesn't embed this functionality with their table linkages. Anyway, I found the 'view' I need with the column comments (SYS.ALL_TAB_COMMENTS). Cheers

Thanks for your responses. Perhaps I didn't state my case clearly enough. I'm looking to pull in Oracle column comments into Access. I attempted to attach a more illustrative example using a Word document but the forum site doesn't allow me to attach the document. The Word document is 711...

Greetings, I’ve linked to an Oracle table from an Access database (via ODBC). I would like to pull in the Oracle table ‘column comments’ into the Access table definition. I’m using Access 2010. In essence, I would like to populate the Access table column ‘description’ value with the...

Hi, This looks quite promising. I have a long running query (over 5 minutes) initiated from a form. I want to display some type of progress bar while the query is running. The standard Access progress bar is not prominent enough. I tried using the form Timer Event, but when the query...

I meant "report" in the generic sense. In essence, I'm getting the datasets I need. Thanks

Thanks CJ. I may be wrong, but I think what I originally requested cannot be done. That is, populate a form field with "complex" filter statement {e.g., where (table1.fld1 like ABC* or table1.fld1 like MNO*) and table1.fld1 not like *XYZ*} and then have the value of the form field be...

Thanks All. I think CJ's answer will work for a single LIKE statement. My larger goal is to build a complex query filter statement using a form field. For example, ...WHERE fld1 LIKE BRD* OR fld1 LIKE TLA* I realize my test table only has three records, but the real table will contain...

I’m on a role. Another weird occurrence in Access. I’m attempting to use a form field as the source for a query filter criteria. Everything works fine if I simply use an “if equal” filter condition. As soon as I try a “like” condition, nothing works. I created a test table with just one...

Thanks Peter! Your GetLongPath function did the trick.