April 6, 2015 at 11:56 am
Hello all! I'm new here and this is my first post. I'm also new to sql however I'm a self-taught advanced access novice I guess you'd say.
I have written a database for our company over the years that we use for just about everything from inspections to employees to inventory, etc.
We have moved the back-end to Sql Server and so far I've been able to do anything I needed on Sql as it's close enough to access at least in what I've needed to this point.
What I need now is the ability to go mobile. We'd like to have the guys out in our plant have ipads or tablets with some sort of app that connects them with the tables, etc. they need to perform the tasks in the plant and automatically update the tables.
I'm not sure if that makes sense but is there a wyswig editor or access similar program that I can teach myself easy enough use to accomplish this?
Thanks in advance for any help you may have.
April 6, 2015 at 12:24 pm
To build a web front end for your database can be a lot of work. There are multiple third party products out there that should help. Assuming you have an MSDN license, I'd go with using the native tools (they're free). Check out this article. It should help. There are probably other ways to get this done with Visual Studio.
There's nothing built into the native SQL Server tools for doing this. You have to look elsewhere.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 6, 2015 at 1:23 pm
Thank you so much! At least that gives me somewhere to start reading. 😛
April 6, 2015 at 4:11 pm
dianne 32446 (4/6/2015)
Thank you so much! At least that gives me somewhere to start reading. 😛
Sorry, wasn't trying to be unhelpful. There just really isn't anything for putting together a front-end like there is in Access. You have to move to developer tools.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 7, 2015 at 2:19 am
This seems to be a good starting point
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply