Recent content by Joshann

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