Recent content by AccessHelp123

The problem seems to have resolved by itself. Not sure how... It would have been nice if I actually knew what happened.. Thanks for your help anyway....

Record changes using VBA and a form...

Yes. Users are able to create files in the folder and the .ldb file is visible when the application is open.

Hi All, We have an Access 97 database that used by several people in the company. Access to this database is granted using a .mdw file. Users have been complaining lately that people are unable to simultaneously make changes to the database. I checked the Tools-->options--Advanced section. The...

I had to create a new database and import all the tables. The errorneous table had to be imported in pieces using queries. Thanks for all your replies.

Was finally able to transfer data from this table by using queries and evoided those error rows in the queries. I reporpulated the table with non-erroneous data. New issue is that the database wont let me compact the databse it says "Record(s) cannot be read because of permissions". I dont have...

I had tried that as well. In the process of export, I get the same error message "unrecognizable format and the database becomes unusable" and nothing gets exported.I am sort of stuck in a loop.

Thanks for all your replies. I tried all suggested methods. Still no luck. I think I finally see what the issue is. There is a row in one of the table with #Error values in it. As soon as I click in the cell with the error the database goes bad (Unrecognized database format) and I have to start...

Hi, We have an access 97 database that has reached 1,048,580 KB. I am unable to compact the database to reduce its size so users can enter data into it. Here is what I have tried so far. I created a new 97 database and imported all tables into this new db. As soon as I do that I get an error...

Hi, I have a few projects that I need to publish but I want to disable email notifications on these projects. Does anyone know how I can accomplish this? Thanks.

Hi, I am trying to use excel macros to access enterprise MS project and get 'TimePhasedData'. I am not sure how to connect to the enterprise project on the server using VBA. Below is the code I have to opne a .mpp file residing on my local computer. Sub test() Dim oMP As...

I get the same result with an HTML form web part.

I am using SharePoint 2010 for this purpose. Thanks.

Nope. The issue is still not resolved, SharePoint is not creating the object in AD.

Hi, I created a page using enterpise wiki template. I added a Content Editor Web Part to the page and entered a link to an html page that has javascript in it. The javascript is supposed to expand and collapse items associated with a few buttons. The scrip works in an html page correctly. When...