Go Back   Access World Forums > Apps and Windows > Web Design and Development

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-01-2013, 10:18 AM   #1
gemadan96
Newly Registered User
 
Join Date: Oct 2012
Posts: 21
Thanks: 0
Thanked 1 Time in 1 Post
gemadan96 is on a distinguished road
Move Access 2007 DB to Access 2010 Web Database

In Access 2007 I've used the Asset Management Database template and customized it for a customer.
It has five key tables: Assets, Contacts, Incoming, Outgoing, Transactions. I've made it as simple as I can for the majority of users. Their primary responsibility is when an asset is being delivered to a contact that it is assigned to that contact or when an asset is being returned it is checked in.

The way it works now is when assets are being assigned to a customer a form is opened by selecting a customer. Using a barcode scanner all assets are scanned and entered in the form which is connected to the Outgoing table. When done the employee selects the Process Outgoing button. This runs a macro that updates the status of the asset and its location in the assets table, it appends the transactions table, then deletes the records from the outgoing table.

When an asset is returned the incoming form is opened and the barcodes are scanned in. The process incoming button runs a macro that updates the asset status and location in the assets table, appends the transactions table, and then deletes the records from the incoming table.

The customer would like to have this web based so I'm considering migrating it to Access 2010 and setting it up as a web database on Sharepoint. I know that this is limited to select queries.

The question is how can I accomplish my update, append, and delete queries in a web database? Can it be done through macros? If so how?

The incoming and outgoing append queries appends the barcode, owner, and date fields of the transactions table.
The incoming and outgoing update queries update the assets table, based on the barcode, for the location, date, and owner fields.

gemadan96 is offline   Reply With Quote
Old 05-01-2013, 12:36 PM   #2
Beetle
Duly Registered Boozer
 
Join Date: Apr 2011
Location: Camp Swampy (Denver, CO)
Posts: 1,806
Thanks: 13
Thanked 458 Times in 449 Posts
Beetle will become famous soon enough Beetle will become famous soon enough
Re: Move Access 2007 DB to Access 2010 Web Database

Quote:
The customer would like to have this web based so I'm considering migrating it to Access 2010 and setting it up as a web database on Sharepoint. I know that this is limited to select queries.

That's not entirely true. An A2010 or A2013 web app can be a hybrid, meaning that it can contain both web objects (queries, forms, reports) and client objects. Client objects will only run inside the Access client, but still have the same functionality and design options that you're used to with older versions. Web objects will run in a browser over the www, but are much more restrictive as far as what you can do with them. You have to remember that anything you do with a web object has to be able to be interpreted by a browser (IE, Chrome, Firefox, whatever). The browser has no knowledge of, or way to interpret references to, any of your client objects. So it's not that you can't have action queries in a web app, it's that there is no way to run them from a web form.


Quote:
The question is how can I accomplish my update, append, and delete queries in a web database? Can it be done through macros? If so how?

Well, if your intent is to be able to duplicate this functionality in a web form running in a browser, then you would have to rewrite everything with data macros using For Each Record In / Create Record In or For Each Record In / Edit Record In loops.


Before you take on this project, you really should sit down with your client and determine what exactly it is they want. If they would be satisfied with using most of the existing functionality from within the Access client and they just want a few forms or certain data available over the web, then it might not be a huge undertaking. On the other hand, if they want the whole thing available on the web then you could be looking at spending hundreds of hours completely redesigning the entire application almost from the ground up. There is no way to convert existing client objects to web objects. You would have to completely recreate all your forms, code, reports, everything except maybe the tables. In that case, you would need to determine whether Access is even the right tool for the job. You might be better off using a real web based platform (.Net or whatever)


BTW - If you're going to cross post in different forums, then it is considered common courtesy to inform us of that fact so efforts are not duplicated by the volunteers who respond in these forums. I have posted this answer in both forums.
__________________
Sean Bailey

Dim Thirsty As String
Thirsty = "Insert Into Glass (Select Beer From Fridge)"
DoCmd.Execute Thirsty, dbPourAnotherOnError
Beetle is offline   Reply With Quote
Old 07-23-2014, 10:41 PM   #3
mimimimi
Newly Registered User
 
Join Date: Jul 2014
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
mimimimi is on a distinguished road
Re: Move Access 2007 DB to Access 2010 Web Database

i want to recognize barcode in vb.net do you thnk is it possible?

mimimimi is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question How to open Ms access 2010 database in ms access 2007 javafun General 6 05-20-2016 03:37 AM
database size-MS access-2010/2007 SKJ Queries 2 05-09-2012 02:05 AM
Move access 2010 screens to Desktop Sanjo Forms 1 03-24-2012 03:20 PM
Question How safe it is to develop an existing MS Access 2007 Database to MS Access 2010? spenzer General 0 03-18-2012 10:22 PM
Access 2010 doesnt recognise 2007 database jibb General 0 02-07-2012 02:20 AM




All times are GMT -8. The time now is 06:44 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World