I used the following macro but I get "user-defined type not defined" with database highlighted, is there something I am doing wrong? Did you add a reference to the DAO object library? What do you mean - Is the access database "secured"? Either way, there are means of delaing with both issues. Yes, the database is secured. What would you considered more effecient?
The method is so convenient or I think it is convenient because the report is exported from an Oracle-type program to an excel spreadsheet. I was thinking of using this spreadsheet as the source for updating the database. Is there a way of copying and pasting data onto access? I dont think access is the "copying and pasting" type.
That's quite a different matter from what I thought you were asking about using Excel as an ongoing data entry-type front-end for an MS Access set of data tables. Your Oracle DBAs may be somewhat reluctant to share this information, and for some understandable reasons, however. Why use Excel or a report if you don't need to if you can directly get the data form Oracle into Access for your needs? However, your management might not be willing to suffer the political slings and arrows necessary to get authorization to do so through your IT organization's bureacratic defenses Also, Access can import data tables directly from Excel - either from a given worksheet or from named ranges.
Where are you with this thing now, Abdulmi? I would go with Stefan's recommendation. I used that exact same code about 1 week ago, on a secured Access mdb, and it worked fine no need to enter a password, even though the mdb itself was password protected.
You may want to take a look at the link below, when you have some free time:. The following code sample of for reading a. That sounds like someone may have opened that database in. This will result in a. IF you have never used any of the Access form controls or form editing features which are not backwards compatible with Access , then Jet should be able to open the database again. Knowledge is the only thing that I can give you, and still retain, and we are both better off for it.
The content you requested has been removed. Ask a question. Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites.
Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation. Details required : characters remaining Cancel Submit. Was this reply helpful? Yes No. Sorry this didn't help. Thanks for your feedback. I don't know for sure, but I suspect the problem with the database being locked is due to your running the query in the front-end, and if you're in the database and have gone into design view on anything , the database will have been locked.
However, if the data ultimately comes from the back-end, why not have Excel query the back-end directly? If you need a stored query for Excel to call, why not save that in the back-end? Sure, the back-end is normally used for tables only, but you can save queries in it, and call them from outside. Close End Sub I'm having a an issue with this approach. Is there another approach I could take? For example, to also update the Department of David to Customer Service.
To update multiple records, first prepare a Table or Query that contains new salary of employees. I personally prefer to prepare such Table in Excel and then use Linked Table because it is more flexible to maintain the table in Excel.
In Update To , specify the Table name of the Salary field. Your email address will not be published.
0コメント