front end back end or link the tables?

[Michael]

I was just posting another question and started to wonder if I have set up
my database correctly. I am not sure if you use the database splitter if it
does more than just create basically what I have done.

I have two databases. one with everything except the data. I have linked all
the tables to a second database that just holds the data. I have done this
to make sure all the data is current and to make it easier to update the
forms and reports. I think this would also create less of a load on the
network as only the data flows back and forth.

Is there a problem with the way I have done it? It is a program that is
still growing and if I have done it wrong, it would be better to change now
than latter.


The problem I have now is to use a pda to update the data as i have
mentioned in the post, I cannot import the data into the pda as it does not
follow the link, nor would I want the entire database in the pda,

thanks
Michael

 

[Guest]

Hi Michael,

You can split a database manually, or by using the database splitter wizard.
Both methods are equivalent. The wizard does not do anything extra.

I think this would also create less of a load on the
network as only the data flows back and forth.

Correct....as long as you place a copy of the front-end on each user's local
hard drive.

Is there a problem with the way I have done it?

Not at all. You've done good. However, there are additional steps that you
should take, such as disabling NameAutocorrect, setting all SubDatasheets to
[None] and maintaining a persistent connection to the back-end database. Take
a look at the following suggestions:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html



Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

I was just posting another question and started to wonder if I have set up
my database correctly. I am not sure if you use the database splitter if it
does more than just create basically what I have done.

I have two databases. one with everything except the data. I have linked all
the tables to a second database that just holds the data. I have done this
to make sure all the data is current and to make it easier to update the
forms and reports. I think this would also create less of a load on the
network as only the data flows back and forth.

Is there a problem with the way I have done it? It is a program that is
still growing and if I have done it wrong, it would be better to change now
than latter.


The problem I have now is to use a pda to update the data as i have
mentioned in the post, I cannot import the data into the pda as it does not
follow the link, nor would I want the entire database in the pda,

thanks
Michael

 

[Michael]

Thanks tom for you advice on both postings, I don't know why I did not try
to bring in the backend before. I guess, I thought that the pda would also
be using the forms and queries, I have allot to learn ... thanks
michael

Hi Michael,

You can split a database manually, or by using the database splitter
wizard.
Both methods are equivalent. The wizard does not do anything extra.

I think this would also create less of a load on the
network as only the data flows back and forth.

Correct....as long as you place a copy of the front-end on each user's
local
hard drive.

Is there a problem with the way I have done it?

Not at all. You've done good. However, there are additional steps that you
should take, such as disabling NameAutocorrect, setting all SubDatasheets
to
[None] and maintaining a persistent connection to the back-end database.
Take
a look at the following suggestions:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html



Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

I was just posting another question and started to wonder if I have set up
my database correctly. I am not sure if you use the database splitter if
it
does more than just create basically what I have done.

I have two databases. one with everything except the data. I have linked
all
the tables to a second database that just holds the data. I have done this
to make sure all the data is current and to make it easier to update the
forms and reports. I think this would also create less of a load on the
network as only the data flows back and forth.

Is there a problem with the way I have done it? It is a program that is
still growing and if I have done it wrong, it would be better to change
now
than latter.


The problem I have now is to use a pda to update the data as i have
mentioned in the post, I cannot import the data into the pda as it does
not
follow the link, nor would I want the entire database in the pda,

thanks
Michael

 

[Douglas J Steele]

While Windows CE had an application known as Pocket Access, unlike Pocket
Word and Pocket Excel, it isn't a cut-down version of Access that will run
on PDAs.

You might take a look at
http://www.oreillynet.com/pub/wlg/3300
http://www.oreillynet.com/pub/wlg/3358

In addition to the the options mentioned in the second article, I'm also
aware of Pendragon Forms
http://www.pendragon-software.com/

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Thanks tom for you advice on both postings, I don't know why I did not try
to bring in the backend before. I guess, I thought that the pda would also
be using the forms and queries, I have allot to learn ... thanks
michael

Hi Michael,

You can split a database manually, or by using the database splitter
wizard.
Both methods are equivalent. The wizard does not do anything extra.

I think this would also create less of a load on the
network as only the data flows back and forth.

Correct....as long as you place a copy of the front-end on each user's
local
hard drive.

Is there a problem with the way I have done it?

Not at all. You've done good. However, there are additional steps that you
should take, such as disabling NameAutocorrect, setting all SubDatasheets
to
[None] and maintaining a persistent connection to the back-end database.
Take
a look at the following suggestions:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html



Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

I was just posting another question and started to wonder if I have set up
my database correctly. I am not sure if you use the database splitter if
it
does more than just create basically what I have done.

I have two databases. one with everything except the data. I have linked
all
the tables to a second database that just holds the data. I have done this
to make sure all the data is current and to make it easier to update the
forms and reports. I think this would also create less of a load on the
network as only the data flows back and forth.

Is there a problem with the way I have done it? It is a program that is
still growing and if I have done it wrong, it would be better to change
now
than latter.


The problem I have now is to use a pda to update the data as i have
mentioned in the post, I cannot import the data into the pda as it does
not
follow the link, nor would I want the entire database in the pda,

thanks
Michael