Database is created now how to distribute it

[ACCESS NEWB]

HI all
So I manage to create database and now have to figure out how to set it on few remote laptops.Those 2 laptops will not have internet access all the time,and are not on same network.Is there a way to send database updates via e-mail or similar?
I read something about FE and BE, but could FE user see old data or just ones he entered and before update them to BE?

 

[DCrake]

Simple Software Solutions

Sorry to be the bearer of bad news but I suspect you are going to run into alot of difficulties Firstly not having a front end back end is bad enough but users not being able to access a central access point is even worse.

Think about uniqueness and referential integrity. What happens if you give two people a copy of the whole database and each one adds new records to each one. how do you propose to sync them so that all records are unique and are up to date?

What happens of user A deletes a record and user B does not. Which action is correct? Again user A does something to a record that should not have been done. When User B sees this how does he respond?

Suggest you change your stratergy pretty soon.

CodeMaster:

 

[ACCESS NEWB]

true but
there shouldnt be any deleting, and user A should be 1 that fill certain tables with Data.User B should just be able to see all that.Generally I did plan to separate which tables are can be used by certain user.
That probably still have some holes but what options do I have?

 

[DCrake]

Simple Software Solutions

The only way to make sure that data is intact is to only give it to one user at a time. So if user A is using it , user B will have to wait until they have finished with it.

Your comment about taking ownership of the mdb via email is viable however remember to compact and zip it up first prior to sending as your ISP or IT dept might have limits on type and size rules.

David