Search results

I will check with the new database engine part

thanks on the update. Found a code to run a refresh linked on all tables: Relink Tables in Code Ever had to relink tables as you've moved a database. Want users to map whatever drive they like. Let users store a database where they want and then ask for the location and pass it as a string...

I think we need to link the tables....

NIce question: What do we mean by "Table Linked" here. Anyways how do we link the table

I have an accdb database which is being accessed via frontend in a networked environment. Users have access to the networked folder (read and write: full access) when they try accessing the database via the fromend, they get the error code # 3051: need permission to access or DB is locked for...

I have tried all the possible steps mentioned above. Let me make it VERY CLEAR: The table is on a database which is at a different location, so cbobox.rowsource is raising an error mentioning the datasource is on a different location. I have tried assigning the cbobox.recordset to a recordset...

can u help with the query part. I cannot hardcode the above distinct field query into the rowsource of the cbobox as the database is at another location. so pls give an example of how to write the query to the rowsource. should it be something like at runtime in vba: cbo.rowsource="select...

I have 2 accdb files - one is the frontend form and the other the backend database I have a combobox that needs to be populated with a field from the database. And after a new record is added, the combobox list needs to be refreshed/updated/requeryed with the new data that has been added to the...

Good News: Was able to add the Docs into the database: However need help with clearing the contents of a ComboBox which when the form loads get populated with KB_SEC I would like to know how we can requery or clear the combobox and repopulate with new data. The rowsourse is not assigned, I do...

yes I have done the changes to the database (accdb). Created an Attachment field. Now would try myself and research on how to get this up and running and would call u out incase I hit a wall, but would like to 1st try myself. Your recommendation and assistance is greatly appreciated.

Thanks on your advise. I have decided to go with it.

Thanks on the update. I will try this code I want to and will update. I am doing this project as we are creating a knowledgebase of our process. Currently we have the word files on our sharepoint server but would like to have a smaller more user friendly version with us. will keep u posted.

I currently am using MDB on Access 2007. I can shift to the ACE (accdb) database format. This is something I think might work: Create a recordset (dynaset) Insert a Record and add update the fields other then the OLE field Next at ruintime assign the controlsource property of the OLE Object...

Scenario: Have a separate Access GUI front-end (local) and separate mdb (on network share) Have a table with the following fields on the MDB: Doc_ID>>ID Doc_Details >> TEXT DOC >>> OLE OBJECT This is what will be done: 1. Browse for Doc file and load into unbound/bound OLE control (This has...