INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Access Front end that can work offline??

Access Front end that can work offline??

(OP)
I need to create a MS Sql front end application and would like to use Access because it is what I am most familiar with. but, I need it to be able to work with data Offline. is this possible? How would I go about setting it up??

Thanks
John

Thanks

John Fuhrman

RE: Access Front end that can work offline??

Define: "work with data Offline".
Is that going to be just SELECT statements against the data base? In which case you may just copy relevant data locally before you go 'off line'.

Or are you going to have some UPDATE, INSERT, and DELETE actions?

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

RE: Access Front end that can work offline??

(OP)
Regretfully, All the above.

But for the most part it will be used to store new data and when the primary back-end becomes available use the new rows to perform several select statements to run a QC process.


There is also another pre-existing application that I would like to add this capability to. The second with be more difficult. It has one primary Call Tracking table,a Customer contact table, and a lookup table.
Tacking and the Contact tables are constantly being updated and added to. The lookup table is fairly static, it might change 3 or 4 times in a year.

Thanks

Thanks

John Fuhrman

RE: Access Front end that can work offline??

I know years ago there was a 'feature' where you could sync up a local database to a master database. Of course it meant having all the data available on the local copy. Do not remember what the 'feature' was called or if it is still supported.

RE: Access Front end that can work offline??

The years ago feature was "replication" and it was used for Access data tables. If you want to manage merging of data from offline files/tables you should at a minimum add a column to every table with the "last update" date/time. You must also make sure you have primary/unique keys on all tables that might need updating.

Duane
Hook'D on Access
MS Access MVP

RE: Access Front end that can work offline??

(OP)
This is a general response to the running conversation.

I am familiar with the old 'Replication' feature, but to my knowledge this was supported only by using local Access DBs. This is not what I am looking for because I have an Enterprise Microsoft SQL Server that the databases will be on and Access will be using linked tables connected to the SQL server.

This is what I was thinking. The primary databases would reside on the production SQL server and the workstations would have a local installation of SQL Express. The configure SQL express to 'sync' with the production server when it is available. The thought was that this way MS Access would always be using the local SQL Express tables and have SQL Express update production tables.

Granted this is just in the prelim stages and I am looking for some thoughts on how some of you have accomplished similar projects.

Thanks!!!
John Fuhrman

Thanks

John Fuhrman

RE: Access Front end that can work offline??

If you plan on using SQL and SQL Express with replication, you might want to consider posting questions in the SQL Server forum. I'm sure you would find better SQL support there. You can post connection and other Access related questions here.

Duane
Hook'D on Access
MS Access MVP

RE: Access Front end that can work offline??

I would also revisit the idea of being “Offline”
I know you are not going to be connected to the ‘main’ data base, but will you be connected to the Internet? If so, maybe this is the time to consider something as a Web application instead? This way you will never be “Offline” smile

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close