Warning Message

[Guest]

I have a Order and Invoicing Database - with help from this site it is now
working better than we had ever imagined

We now have a second computer so I Replicated the Database

The linked computer has a "Briefcase Folder" on the desktop and it is
working fine - all files are updated/merged once a day and we are very happy
with it

The annoying thing is when you open the "Briefcase Copy" of the datafile you
always get a Warning "you must have a database open to create custom
toolbars - and the database can't be read-only"

Is there anyway to stop this message coming up as it is annoying?

Tks

 

[Tony Toews [MVP]]

I have a Order and Invoicing Database - with help from this site it is now
working better than we had ever imagined

We now have a second computer so I Replicated the Database

Gak! Why? Replication is a huge PITA unless you are willing to spend
a lot of time with it.

You are much better off removing the replication and splitting the
MDB.

You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Guest]

That all seems an easier way to do it - but we also have the file on a LapTop
which is not always connected to the system - it is used in the field and
Orders are entered into it on site

Linking would mean they do not have the Tables connected

 

[Tony Toews [MVP]]

That all seems an easier way to do it - but we also have the file on a LapTop
which is not always connected to the system - it is used in the field and
Orders are entered into it on site

Linking would mean they do not have the Tables connected

Fair enough. But you should still be using a FE and BE and replicate
only the data.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/