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
Editing Link Specifications and system tables 5
Import Specs A2007 1
Excel import specification 2
Custom PWA Field in My Timesheet Cannot Be Queried 1
Create Specs 3
Date in Access table 2
Testing if record in form is available for editing 1

Top