Can fields in system table be accessed for editing somehow?

D

djh

I need to modify the import specifications stored in a
database, so that the first row is not skipped. I do not
see this field when I pull up the saved specs from the
Advanced tab of the Import Text Wizard. I know that it
is the StartRow field in the system table, MSysIMEXSpecs,
but I am unable to change the values there. Any ideas
other than re-entering all the specs again.
 
D

Douglas J. Steele

It's really not recommended that you update the system tables directly, even
in those rare cases where it's possible (most, if not all, of them are
read-only).
 
P

Pieter Wijnen

in this case it is possible though, but you have to use an update query

HTH

Pieter
 
G

Guest

Thanks. That was easy, and much, much quicker than
reentering the many field specs into the import text
wizard.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Specifications Start Row 2
Excel import specification 2
Create Specs 3
Testing if record in form is available for editing 1
editing a record in a table 1
Avg fields in a table 1
Reverse display of stored checkmark 1
lookup in datasheet view based on the entry in other field 1

Top