Search results

  1. S

    Access DB hosted on website ... is it possible to conect

    Is it possible to connect to an Access 2007 DB which is hosted on a website. I can access the various folders on the website using FTP (which is used to upload). The website is a normal website and has no backend support for the DB. Also would like to know how can we connect to the MYSQL DB...
  2. S

    Linked Table issue - Shows as read-only

    I split my Access 2007 DB to FE and BE. The FE has been distributed to multiple users. The BE is on my system and I have granted full control access (read and write) to all the folders and subfolders where the BE Access 2007 is located. I have been informed that all users get the information...
  3. S

    Issue with attachment field in VBA

    DB Setup Backend: Table with attachment field Frontend: Forms with linked table to backend The app has been created and worked fine. I was able to add the attachment to the table and retrieve the document. All went fine. Now once this was ready for multiuser access, I compiled the VBA code...
  4. S

    Need help with VBA - Urgent!!!!

    I have a switchboard that has command buttons and which opens their respective forms. I have created the accde file and have enabled all macros and have placed the accde in a trusted location and have enabled sub-folders as well. When I launch the switchboard, and click on any button, none of...
  5. S

    Need help with ListBox

    Listbox setup as value list Need to populate the listbox with items and each item has a special integer code associated with it. How can we assign the code to each item in the listbox and also how can we extract which item has been selected in the click event (multiselect is disabled) so that we...
  6. S

    Need help with attachment Control

    I have an accdb file with a table that has an attachment field. Each record has ONLY one attachment I would like to use the attachment control to show the attachments from the table. Form Layout Attachment Control 2 Command Button (to keep showing the next and prev record attachment) When the...
  7. S

    Need help with Form

    I have created a remote database access application. I have configured from Access Options to load the form1 as the Home Screen. This screen has 3 command buttons which when clicked should open their respective forms. I need assistance with the following: When the appl (accde) is launched, is...
  8. S

    Error 3051 encountered

    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...
  9. S

    Need help with combobox

    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...
  10. S

    Need help with VBA - Insert records with OLE Object (Word Doc) along with details

    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...
Back
Top Bottom