Recent content by sjslall

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

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

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.

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.

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

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

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

thanks, tried and has worked.

I agree, will try this out

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

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

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

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

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

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