Backend update

J

Jason

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.
 
J

Jason

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 "".
 
J

Jason

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?
 
J

Jason

It's taken me all day to sort most of this out - one of the errors being
that there was an update command for an empty table.

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?

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 "".

Also the command RunCommand acCmdSaveRecord always generates an error

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).
 
P

Peter Hibbs

Hi Jason,

I assume you are referring to my Back-End Update code in your various
posts. If so, how are you getting on. You seem to be finding problems
and then finding the answers yourself. Have you now fixed all the bugs
in your code, if not then let me know and I will try and help.

Peter Hibbs.
 
P

Peter Hibbs

Jason,

I would just leave the Default Value property blank so that it
defaults to Null, I don't really see the point of setting it to ""
(unless I am missing something).

Peter Hibbs.
 
J

Jason

I've got into the habbit of using TxtFld & "" in if statements and other
areas because previous fields (in the years work) could be null - I've been
getting invalid use of null etc. So no problem with sticking with empty
field.

Peter Hibbs said:
Jason,

I would just leave the Default Value property blank so that it
defaults to Null, I don't really see the point of setting it to ""
(unless I am missing something).

Peter Hibbs.
Click to expand...
 
J

John W. Vinson

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?
Click to expand...

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.
 
J

Jason

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
Click to expand...
table exists before VBA tries to create it?
 
J

John W. Vinson

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

"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
table exists before VBA tries to create it?
Click to expand...

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?
 
J

Jason

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 Update Utility.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.
 
Top