Backend update

Don't know what you need. I'm using the code I downloaded to create/modify
the tables. I found that once the code had run it did not append to the
table that recorded the latest ID of the table modifications therefore when
the code ran it tried to recreate a table that already existed - alwasy
starting at 1. I then added my own code to check if record count was 0 - if
so add new record then use the ID as the value. Once the value had been
entered into the upgrade progress table the original code worked (if dcount
0). However, to improve upgrades in the future how do I determine if a
table exists before VBA tries to create it?
"John W. Vinson" wrote in message
...
On Sat, 3 May 2008 16:47:51 +1200, "Jason" wrote:

I'm getting
Run-time error '3010'
Table 'TblName' already exists. Is there a way to check if a table exists
before trying to create it?
"Jason" wrote in message
...
Found how to set autonumber - it was at the top of the list
But can't set property type Caption. Nor set default value to "".
"Jason" wrote in message
...
Also the command RunCommand acCmdSaveRecord always generates an error
"Jason" wrote in message
...
I think I've figured out how to use the B/E upgrade mdb file. How
do I
add
an autonumber field - this is not listed in the drop down list).

Thanks,
J.








Jason, you may be assuming that the volunteers here can see your computer
monitor and read your mind concerning what you are trying to accomplish.
Maybe
some of the gurus around here can, but I certainly cannot.

Please explain the context, what you're trying to accomplish, what steps
you
have taken to accomplish it, and the specific error messages you're
getting.
--

John W. Vinson [MVP]

On Sun, 4 May 2008 14:11:15 +1200, "Jason" wrote:

Don't know what you need. I'm using the code I downloaded to create/modify
the tables.

"The" code. What code? You haven't indicated where you downloaded it from, or
posted any of the code.

I found that once the code had run it did not append to the
table that recorded the latest ID of the table modifications therefore when
the code ran it tried to recreate a table that already existed - alwasy
starting at 1. I then added my own code to check if record count was 0 - if
so add new record then use the ID as the value. Once the value had been
entered into the upgrade progress table the original code worked (if dcount
0). However, to improve upgrades in the future how do I determine if a
table exists before VBA tries to create it?

Again, Jason: you are not the only person posting to this newsgroup. Maybe you
have posted your code, a description of your table structure, and what
specific opreations you're trying to carry out... but I'm sorry, as an unpaid
volunteer I really don't have time or interest to Google search for all your
prior postings.

If you post a SPECIFIC question, *with code and a description of your tables*,
I or another volunteer will be glad to try to help. But please reread the
above with the assuimption that what you posted is *all* the information
available to someone trying to help: someone who does not know your business,
the structure of your tables, or the content of your code. Not much to go on,
eh?
--

John W. Vinson [MVP]

I shall repost:
Jason,

You can update the Front-End file easily by sending the client a new
version. However, if you will need to make changes to the Back-End
file you need a different method. Assuming that you cannot visit each
client to make the necessary changes you need to add some code to the
Front-End which will make the relevant changes to the Back-End files
automatically.

There is code at this site :-
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE%20Update%20Utilit y.mdb'
which will do that for you. Just import the form, table and code
module into your database, add one line of code to your 'start up'
form and you are done. To add a new table or field to the Back-End you
just call up the BE Update form, enter the details of the table,
field, relationship, etc and the Back-End file is updated without
affecting the client's existing data.

You will also need to add relinking code to relink the Front-End file
to the tables in the Back-End file. See this site to do that
automatically :-
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE_ReLink.mdb'

There is full documentation on both sites to explain the procedure
fully.

HTH

Peter Hibbs.

On Thu, 1 May 2008 18:58:18 +1200, "Jason"
wrote:

It is split as you say the tables in the user mde is for temporary data and
data i enter for look-ups etc. Since the data files have changed over time
I
have found the process of copying and importing easier. Can you post an
example code where the table is checked and modified (i.e. fields added,
modified or deleted).

ALSO tables that are added

Thanks,
J
"Larry Linson" wrote in message
...
"Jason" wrote

How do I upgrade existing data? A database upgrade
i did involved copying the existing files using a batch
file, then copy the new files over the existing files then
a long routine in Access to import the old data into the
new tables.

Sounds as if you have not split your database into front end (queries,
forms, reports, macros, and modules) and back end (tables, data, and
relationships), with each user having a copy of the FE and the BE on a
shared folder.

-- The most common updates will be to the interface, so each user can
just
get
a new copy, because it does not store data (other than, perhaps,
some
rarely-
changing lookup tables -- state abbreviation and state name, for
example).

-- When you have to make a change in the data structure, the common
approach
(if you can't go to the location, and open the back end manually)
is
to
write
VBA code in DAO or ADO to modify the table design (if needed) and
data
in the shared back end, and update with any additional data that
you
are adding,
and have one user or administrator at the production site execute
that
when
they have exclusive access.

There's other information about splitting and about an Auto FE Updater
for
use in multiuser environments at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm.

Good luck with your projects.

Larry Linson
Microsoft Office Access MVP





"John W. Vinson" wrote in message
...
On Sun, 4 May 2008 14:11:15 +1200, "Jason" wrote:

Don't know what you need. I'm using the code I downloaded to
create/modify
the tables.

"The" code. What code? You haven't indicated where you downloaded it from,
or
posted any of the code.

I found that once the code had run it did not append to the
table that recorded the latest ID of the table modifications therefore
when
the code ran it tried to recreate a table that already existed - alwasy
starting at 1. I then added my own code to check if record count was 0 -
if
so add new record then use the ID as the value. Once the value had been
entered into the upgrade progress table the original code worked (if
dcount
0). However, to improve upgrades in the future how do I determine if a
table exists before VBA tries to create it?

Again, Jason: you are not the only person posting to this newsgroup. Maybe
you
have posted your code, a description of your table structure, and what
specific opreations you're trying to carry out... but I'm sorry, as an
unpaid
volunteer I really don't have time or interest to Google search for all
your
prior postings.

If you post a SPECIFIC question, *with code and a description of your
tables*,
I or another volunteer will be glad to try to help. But please reread the
above with the assuimption that what you posted is *all* the information
available to someone trying to help: someone who does not know your
business,
the structure of your tables, or the content of your code. Not much to go
on,
eh?
--

John W. Vinson [MVP]