Search results

I would like a printout of all the object dependencies in my database. I can see them by going to Database Tools>Object Dependencies, but that only shows one object at a time, and I need a list of all of them. Does anyone know of a way to do that?

Thank you!

Thank you! I don't know what SSMS is, so apparently I don't have it.

i am working in the BE.

I would like to create a database model diagram from an existing Access database. Several years ago, I did this using Microsoft Visio, and Visio automatically created it. Now, I can't get that to work. The versions I have are Access for Microsoft 365 and Visio Plan 2. Does anyone know how to...

I have an Access database (I'm using Office 365 on Windows 10) stored on a network server. No matter what I do, I can't make my database trusted. I have gone into Trusted Locations in the Trust Center, and added the network location where the database resides being sure that the Allow Trusted...

Thank you very much! This is what I was wanting to know. So as far as you know, Oracle is pretty much just the back end?

Thank you, but I am aware of why I am being asked this by my organization. It is too long to explain here, but I still want to know the differences between Access and Oracle.

What are the major differences between Microsoft Access and Oracle databases? I have an Access database that I designed and have used for many years. In addition to the tables and queries, it has numerous forms and reports, and a lot of VBA code. It can also generate emails and Microsoft Word...

Thanks anyway for trying. I tried that, and unfortunately, I still get the same error message.

Since my original post, I have made some progress. I am no longer getting an error message in my Access Web App, I am getting an error message in SharePoint. Now, the error message I get in SharePoint is: "Where clauses must contain at least one field reference that includes the table name...

I agree. How do I insert a screen shot here?

I know. I've run across that web page too, but I cannot get it to work.

Thanks, but using asterisk wildcards does not work either. The following statement does work: [debtor name] = "*" + [txtDebtorName] + "*" but if I change the clause as follows, I get an error message: [debtor name] LIKE "*" + [txtDebtorName] + "*"

Apparently, the LIKE operator does not work in the Where clause of an access web app macro. Does anyone know an alternative? The following statement does work: [debtor name] = [txtDebtorName] but if I change the clause as follows, I get an error message: [debtor name] LIKE [txtDebtorName]...

I have figured it out from the last message on this post: https://forums.adobe.com/thread/578121 I just need to export my Access data to a text file first. As the poster said, it's not really a mail merge, but it will work for me.

Thanks for your response, but no not really. As I mentioned, this is a complicated form. It is three pages long with lots of embedded tables and many fields. The form is created by and used in Federal Court, so it must look EXACTLY the same. It would take so long to try to recreate the form...

I have a relatively complicated fillable form that someone else created in Acrobat. I would like to be able to fill it out using data from Access tables. So basically, I would like to do a mail merge with data from Access and an Acrobat pdf form. Is that even possible?

My company just got Access 2013 and SharePoint, so I am just looking into things, so please go easy on me. :) I have a desktop Access database that I would like to link to a SharePoint web app. I would like certain users to be able to use the full version of the database with forms, reports...

Thanks! I hope you are right.