Recent content by sjslall

  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 had added all the users individually for full access to the shared folder. I will try this once I get approvals for a file server folder. Thanks again....
  3. S

    Linked Table issue - Shows as read-only

    I am on my office domain and have granted full access to the files and folders to the users. Do you think we would have to try this on a file server.
  4. S

    Linked Table issue - Shows as read-only

    Yes I just checked with all the users. They had placed the FE in a Trusted Location Folder. They even tried to link the table manually from a new FE they created, which originated from the trusted location.
  5. 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...
  6. S

    Issue with attachment field in VBA

    Ok found out why the error is there. This is not related to just the attachment field. When I created a dummy Frntend and backend with just a text field and tried adding a rec to the BE database, get error 3027 : DB is read only. You get this error when someone else tries logging from their...
  7. 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...
  8. S

    Need help with ListBox

    thanks, tried and has worked.
  9. S

    Need help with ListBox

    I agree, will try this out
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. S

    Error 3051 encountered

    Worked like a charm....thanks. Was looking for this way as would like to locate the accdb file and then add the dbpath to the connection string with: &dbpath
  15. S

    Error 3051 encountered

    Well I am new to ADO VBA, so felt like a child. Anyways I have a question. is there a way to put the data source as a separate like: db.data source=dbpath I tried this and got an error that the database is not open
Back
Top Bottom