@Kelly said in Access Web Application With SharePoint Online - Set Relationships:

@garak0410 said in Access Web Application With SharePoint Online - Set Relationships:

@Kelly said in Access Web Application With SharePoint Online - Set Relationships:

Access Web App is basically another front end on a list. There is nothing relational available to it.

Understood. Will try for another option based upon my current knowledge and abilities...

Post back here if you do find something. I have a quick DB project that I haven't been sufficiently fussed about to spin up a real engine for.

I've mentioned my other projects ad nauseam. Hate to even seek help anymore. Don't want to appear as if I am always spinning my wheels because I'm not...Wife is after me to get a new job but I just don't see that happening right now. Overall, this is still an amazing job but just trying to wear too many hats.

@Kelly said in Access Web Application With SharePoint Online - Set Relationships:

Access Web App is basically another front end on a list. There is nothing relational available to it.

Understood. Will try for another option based upon my current knowledge and abilities...

@BRRABill said in Access Web Application With SharePoint Online - Set Relationships:

Countdown to a @scottalanmiller Access comment in 5...4...3...

Love it! ...but right now with my limited time, it is my ONLY option for my latest "Project"...

Any Office 365 users out there that can answer this question? If you create an Access Web Application that saves to SharePoint Online with Office 365, how can you go in and set relationships with the tables. Considering I've checked every tab and setting, I'm thinking this is something that can't be done.

Thanks...

Quick update...I've had zero time to devote to this because Accountant needed an ancient VB6 program enhanced and took me 1/2 of last week to do this. And this week, another manager wants me to convert an Excel Sheet to a web-based database. Office manager still demands an invoice program in 2 weeks and wants that "legacy" former IT guy to be involved...she ignored my pleas for help and friendly reminders that what she wants can't be done at my work load/skill level and the fact they don't want to pay a developer. Not counting the day to day (our VOiP system needed some work, a few PC rebuilds and phone replacements)...

And this point, it would be easier for me if I could run this Invoice Ninja (self-hosted) on my Windows Server 2012 R2 Applications/Web Server but even had struggles getting that going...

@garak0410 said in Invoice Software - Office 365 Or Purchase Software Suite?:

@garak0410 said in Invoice Software - Office 365 Or Purchase Software Suite?:

@DustinB3403 said in Invoice Software - Office 365 Or Purchase Software Suite?:

@garak0410 said in Invoice Software - Office 365 Or Purchase Software Suite?:

@scottalanmiller said in Invoice Software - Office 365 Or Purchase Software Suite?:

Do you have a GUI on this server?

Yes...running latest Ubuntu DESKTOP version...

Why the "desktop" version?

Linux has always been designed as a server first, and things removed for the desktop version. If you're using this to host applications, you really should use the "Server" version.

Just honest ignorance of Linux options...trying server now...

I've set up Ubuntu Server...so, trying the install again...

Ubuntu Server is set up...both of these commands worked this time:

sudo apt-get update
sudo apt-get dist-upgrade

Still can't get the docker to work... on docker compose-up still get this:

ERROR: In file './docker-compose.yml' service 'version' doesn't have any configuration options. All top level keys in your docker-compose.yml must map to a dictionary of configuration options.

Here's my version information:

docker-compose version 1.5.2, build unknown
docker-py version: 1.8.0
CPython version: 2.7.12+

@garak0410 said in Invoice Software - Office 365 Or Purchase Software Suite?:

@DustinB3403 said in Invoice Software - Office 365 Or Purchase Software Suite?:

@garak0410 said in Invoice Software - Office 365 Or Purchase Software Suite?:

@scottalanmiller said in Invoice Software - Office 365 Or Purchase Software Suite?:

Do you have a GUI on this server?

Yes...running latest Ubuntu DESKTOP version...

Why the "desktop" version?

Linux has always been designed as a server first, and things removed for the desktop version. If you're using this to host applications, you really should use the "Server" version.

Just honest ignorance of Linux options...trying server now...

I've set up Ubuntu Server...so, trying the install again...

@DustinB3403 said in Invoice Software - Office 365 Or Purchase Software Suite?:

@garak0410 said in Invoice Software - Office 365 Or Purchase Software Suite?:

@scottalanmiller said in Invoice Software - Office 365 Or Purchase Software Suite?:

Do you have a GUI on this server?

Yes...running latest Ubuntu DESKTOP version...

Why the "desktop" version?

Linux has always been designed as a server first, and things removed for the desktop version. If you're using this to host applications, you really should use the "Server" version.

Just honest ignorance of Linux options...trying server now...

@scottalanmiller said in Invoice Software - Office 365 Or Purchase Software Suite?:

Do you have a GUI on this server?

Yes...running latest Ubuntu DESKTOP version...

@momurda said in Invoice Software - Office 365 Or Purchase Software Suite?:

@garak0410
That error usually means you have something open like Software Updater or something else needs to be closed.
Just reboot, login open terminal(if using a gui) and then do your
sudo apt-get update
edit forgot this: sudo apt-get upgrade
sudo apt-get dist-upgrade

Same errors as above...

@scottalanmiller said in Invoice Software - Office 365 Or Purchase Software Suite?:

@garak0410 is your Ubuntu up to date? Both did you install the latest Ubuntu which is 16.10 and have you done this to make sure that it is properly patched?

sudo apt-get update
sudo apt-get dist-upgrade

Got this on the update attempt:

sudo apt-get update
[sudo] password for user:
Hit:1 http://security.ubuntu.com/ubuntu xenial-security InRelease
Hit:2 http://us.archive.ubuntu.com/ubuntu xenial InRelease
Hit:3 http://us.archive.ubuntu.com/ubuntu xenial-updates InRelease
Hit:4 http://us.archive.ubuntu.com/ubuntu xenial-backports InRelease
E: Could not get lock /var/lib/dpkg/lock - open (11: Resource temporarily unavailable)
E: Unable to lock the administration directory (/var/lib/dpkg/), is another process using it?

@garak0410 said in Invoice Software - Office 365 Or Purchase Software Suite?:

@Danp said in Invoice Software - Office 365 Or Purchase Software Suite?:

@garak0410 It's sudo apt not sudo app.

Installed now...moving...will report progress...

docker-compose up
ERROR: In file './docker-compose.yml' service 'version' doesn't have any configuration options. All top level keys in your docker-compose.yml must map to a dictionary of configuration options.

I'm sure this is a newbie thing too...

@Danp said in Invoice Software - Office 365 Or Purchase Software Suite?:

@garak0410 It's sudo apt not sudo app.

Installed now...moving...will report progress...

@hillel369 said in Invoice Software - Office 365 Or Purchase Software Suite?:

sudo apt install docker-compose

Yes...says sudo: app: command not found

@hillel369 said in Invoice Software - Office 365 Or Purchase Software Suite?:

@garak0410 What errors did you see, I'm happy to try help fix it.

Trying the Docker file at https://www.invoiceninja.com/self-host/

When I try docker -compose up, it says docker-compose isn't installed and to try sudo apt install docker-compose. Stuck there...and I am sure it is due to my inexperience with linux commands...

Still in Limbo over this project...I tried to install the self-hosted Invoice Ninja on Ubuntu but even following the directions here https://www.invoiceninja.com/self-host/ or trying the Docker file, I am running into errors I don't know how to fix (total newbie with Linux)...the "legacy" developer they still insist on using wants to try something in "DreamWeaver" he said.

Oh the fun...

Try also servermanager from the command prompt...

@Ghani Hmmm...

So PowerShell can't be started at all? If it can, try this...

Add-WindowsFeature Server-Gui-Shell, Server-Gui-Mgmt-Infra
Then
Shutdown –r -t 0

Can you run SConfig ??

@hillel369 said in Invoice Software - Office 365 Or Purchase Software Suite?:

To keep things simple but flexible I'd suggest the following:

• Use the self host version of our app with our automated Softaculous installer:
  https://www.softaculous.com/apps/ecommerce/Invoice_Ninja

• Create reports using a graphical tool, there are some good options listed here:
  https://www.quora.com/What-would-be-the-best-report-generator-tool-for-mySQL-DB-that-is-web-based-and-open-source

While you can create reports using our API it'd most likely be easier using the database.

Great advice...thank you...